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

**URL:** <https://community.amazonquick.com/t/i-need-to-show-historical-trend-for-current-week-top-10-stations-only/16317>\
**Category:** Q&A\
**Tags:** error, calculations, quick-sight\
**Created:** [July 31, 2023, 6:49am UTC](https://community.amazonquick.com/t/i-need-to-show-historical-trend-for-current-week-top-10-stations-only/16317 "2023-07-31T06:49:44Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Vindhya](https://avatars.discourse-cdn.com/v4/letter/v/90db22/32.png) [@Vindhya](https://community.amazonquick.com/u/Vindhya)\
**Post date:** [July 31, 2023, 6:49am UTC](https://community.amazonquick.com/t/i-need-to-show-historical-trend-for-current-week-top-10-stations-only/16317/1 "2023-07-31T06:49:44Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![wstevens01](https://avatars.discourse-cdn.com/v4/letter/w/e9c0ed/32.png) [@wstevens01](https://community.amazonquick.com/u/wstevens01)\
**Post date:** [July 31, 2023, 12:45pm UTC](https://community.amazonquick.com/t/i-need-to-show-historical-trend-for-current-week-top-10-stations-only/16317/2 "2023-07-31T12:45:13Z")

</div>

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](https://community.amazonquick.com/t/period-over-period-and-other-date-comparison-calculations-yoy-mom-ytd-rolling-90-days-etc/564), [here](https://community.amazonquick.com/t/create-week-over-week-calculation/5921) and [here](https://community.amazonquick.com/t/need-week-over-week-metric-along-with-the-weeks-data-in-table-view/5611) for a few.
4. See Quicksight docs [here](https://docs.aws.amazon.com/quicksight/latest/user/period-over-period-function.html)

 ![Screen Shot 2023-07-31 at 6.38.25 AM](https://d1wl4jav5dp96l.cloudfront.net/original/2X/4/4dbfcdb82b2c7280e2d0f515d83ceb4ecbc813e2.jpeg)

Let me know if that helps!

ws