Is there a way to show in one dashboard gadget last week data vs. current data to show progress

Josh Shelton

Weekly I report to my boss on open, resolved issues as they relate to areas of our technology. He is wanting to see last weeks number next to this week's numbers with the % increase/decrease in one gadget. Is that possible without exporting to excel?

Gabriel Senna

Hi Josh,

You can use two gadgets with different filters.

For example, you use a Pie Chart gadget to show the issues that were closed in the last and present week.

status changed TO "Closed" AFTER startOfWeek(-1) BEFORE endOfWeek(-1) - last week

status changed TO "Closed" AFTER startOfWeek() BEFORE endOfWeek() - present week

This way, it will show the issues where the status changed to "Closed" in the start of week -1, meaning last week and from the present week.