Is there a way to get top movers to calculate based off a previous period

[tate]

I am struggling to create a top movers component that works outside the confines of the day/week/month definitions it assumes based on the date period selected.

My goal is to have a rolling Top Movers insight based on metrics for the previous 7 days. I have a date filter programmed to a rolling past 7. In the screen below is the result I get when I have a range from 11/7-11/13. It gives me a top movers for the week of 11/10 because that is the most recent “week” in the range.

What I would like to do is calculate top movers for 11/7-11/13 vs 10/31-11/6. Is this possible?
I understand this could be done as a table, but I prefer how narratives present the information and options to conditionally format text based on the results.

[Giridhar.Prabhu]

Hi @tate

See this. The suggestion from @prantika_sinha may be suitable for your requirements as well.

Rolling 12 month Calculation

I’m working on a dashboard where I need to calculate a Rolling 12-Month Total. The calculation works perfectly when I display all the months of data. However, when I apply a filter to display only the past 3 months, the rolling sum calculation automatically adjusts to include only those 3 months, instead of the full 12 months. Example: Data for Months 1 to 12: Month 1: 100 Month 2: 100 Month 3: 100 … Month 12: 100 When I display data for all 12 months, the rolling 12-month total works as e…