I need to show historical trend for current week top 10 stations only

Question & Answer
, , ,
1

Hi All,

I need to create a visual for a dashboard which provides an historical trend week over week for the current week’s top 10 values. How do we do this on quick-sight?

2

Hi @Vindhya ,

There’s several ways that you can show week over week comparisons in Quicksight. Start with a timeline and set the time aggregate to WEEK. The you can do one or all of the following:

  1. Use one of the periodoverperiod functions. I used periodOverPeriodDifference(sum(Sales), {Sales Date}, WEEK, 1)to show the wow difference in the attached screenshot
  2. Display one of the ‘period over period’ insights. See attached screen shot for available insights.
  3. Use one of the techniques from the community. See here, here and here for a few.
  4. See Quicksight docs here

Screen Shot 2023-07-31 at 6.38.25 AM
Screen Shot 2023-07-31 at 6.38.25 AM1920×848 112 KB

Let me know if that helps!

ws