How can I make a comparison period where I take a metric and select a single week and then the tile with the metric shows me the value of that metric the previous week?
I want the option to see my metrics week over week and year over year but there doesn’t appear to be a very selectable way to do this. Whenever I select a date it shows me the metric value but doesn’t show the previous week’s value.
Hello @kstory!
Would using a KPI visual and a date filter like the one I have set up below?:
Let me know if this works!
Thanks for the suggestion! I was hoping for a visual that would auto change the two weeks in the upper corners whenever I select a one-week window. Like if i select the date, July 16 - 22, the other corner will auto populate with data for July 9 - 15.
Hey @kstory ,
Is the screenshot below what you are looking for? The way that KPI visuals can be formatted allows you to show the sum, count, or avg (based on your field well aggregation) for the value that you are trying to display based on the time frame.
We have not heard back from you regarding your question. We would still like to help. If we do not hear back in the next 3 days, we will archive the question.
Yes, the solution provided by Duncan worked. Thank you!
1 Like
Hey, so I am playing with the analysis done in the comments above. What I am working on is a tad bit different. I have it how you have it set up but need the settings changed and not sure if it is a possibility. I am trying to get a summed count for a MTD metric but have that compare it to the prior year same period. For instance August 1-22 2024 and then comparing that to Aug 1-22 2023. Would need it to continuously stay MTD as the date changes through new periods