# Date range Comparison in KPI Visual Type

**URL:** <https://community.amazonquick.com/t/date-range-comparison-in-kpi-visual-type/14746>\
**Category:** Q&A\
**Tags:** filters, quick-sight\
**Created:** [June 16, 2023, 1:02pm UTC](https://community.amazonquick.com/t/date-range-comparison-in-kpi-visual-type/14746 "2023-06-16T13:02:10Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Mudgal](https://avatars.discourse-cdn.com/v4/letter/m/90ced4/32.png) [@Mudgal](https://community.amazonquick.com/u/Mudgal)\
**Post date:** [June 16, 2023, 1:02pm UTC](https://community.amazonquick.com/t/date-range-comparison-in-kpi-visual-type/14746/1 "2023-06-16T13:02:10Z")

</div>

In KPI Visual I need to show in the Trend Group 2 things -

- previous 7 days avg/count on one side
- previous to previous 7 days avg/count on the other side

And in between the difference of the above two date ranges mentioned.  
Currently I am only getting the previous date and the date before in the trend area and the difference of them in the visual.  
The visual is as below

 ![Screenshot 2023-06-16 at 6.29.38 PM](https://d1wl4jav5dp96l.cloudfront.net/original/2X/e/ec89f3f2131cf8a715c8781f13504d97a75a0134.png)

Thank you  
Regards - Himanshu

---

<div class="post-metadata">

**Author:** ![Max](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/max/32/2288_2.png) [@Max](https://community.amazonquick.com/u/Max)\
**Post date:** [June 18, 2023, 10:41pm UTC](https://community.amazonquick.com/t/date-range-comparison-in-kpi-visual-type/14746/2 "2023-06-18T22:41:13Z")

</div>

Hi @Mudgal

You can add a date filter to filter everything before the previous week.

 ![image](https://d1wl4jav5dp96l.cloudfront.net/original/2X/b/b2b6b4dde1ff54d7b2b457ad3879f924b74ae14e.png)

Secondly you can group your dates to the weeks.

 ![image](https://d1wl4jav5dp96l.cloudfront.net/original/2X/e/e0926333bfa7eb0cff235476bc5c6cc822e4d62f.png)

---

<div class="post-metadata">

**Author:** ![Mudgal](https://avatars.discourse-cdn.com/v4/letter/m/90ced4/32.png) [@Mudgal](https://community.amazonquick.com/u/Mudgal)\
**Post date:** [June 21, 2023, 1:14pm UTC](https://community.amazonquick.com/t/date-range-comparison-in-kpi-visual-type/14746/3 "2023-06-21T13:14:12Z")

</div>

Hi @Max

yes this worked, Thanks

Regards - Himanshu