# Visual Key Performance Indicators

**URL:** <https://community.amazonquick.com/t/visual-key-performance-indicators/2535>\
**Category:** Q&A\
**Tags:** visuals, analysis, quick-sight\
**Created:** [March 22, 2022, 8:26pm UTC](https://community.amazonquick.com/t/visual-key-performance-indicators/2535 "2022-03-22T20:26:26Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Prachi](https://avatars.discourse-cdn.com/v4/letter/p/7ea924/32.png) [@Prachi](https://community.amazonquick.com/u/Prachi)\
**Post date:** [March 22, 2022, 8:26pm UTC](https://community.amazonquick.com/t/visual-key-performance-indicators/2535/1 "2022-03-22T20:26:26Z")

</div>

I am using KPI visual in the chart which is showing percent difference between week of 20th March, 2022 vs week of 13th March, 2022. However, I want the difference between week 13th March , 2022 vs week 6th, March, 2022. I tried to use relative filter for previous week but it does not work. How can we customize the KPI visual to compare previous week vs prior week.  
 ![image](https://d1wl4jav5dp96l.cloudfront.net/original/2X/9/970bd44b10d2f56df079be9d2aebfd8edc806730.png)

---

<div class="post-metadata">

**Author:** ![Jesse](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/jesse/32/177_2.png) [@Jesse](https://community.amazonquick.com/u/Jesse)\
**Post date:** [March 23, 2022, 5:57pm UTC](https://community.amazonquick.com/t/visual-key-performance-indicators/2535/2 "2022-03-23T17:57:11Z")

</div>

In the relative date filter, make the relative periods broad enough to capture all your data (I used last 10 years in this example) and then use the second section which allows you to ‘Exclude’ the last 1 Week. Does that work for you?

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

---

<div class="post-metadata">

**Author:** ![Prachi](https://avatars.discourse-cdn.com/v4/letter/p/7ea924/32.png) [@Prachi](https://community.amazonquick.com/u/Prachi)\
**Post date:** [March 23, 2022, 9:09pm UTC](https://community.amazonquick.com/t/visual-key-performance-indicators/2535/3 "2022-03-23T21:09:35Z")

</div>

I did try doing it but does not seem to work. Attached is the screenshot where it continues to show March 20th, 2022 vs March 13th, 2022. However, with the applied filter it should show March 13th, 2022 vs March 6th, 2022. Please let me know if I am missing any parameter. Appreciate your help.

 ![image](https://d1wl4jav5dp96l.cloudfront.net/original/2X/8/822c4f35130cc3fbf211b6deaa53a5b22b6619ca.png)

---

<div class="post-metadata">

**Author:** ![Ying\_Wang](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/ying_wang/32/389_2.png) [@Ying\_Wang](https://community.amazonquick.com/u/Ying_Wang)\
**Post date:** [March 23, 2022, 9:38pm UTC](https://community.amazonquick.com/t/visual-key-performance-indicators/2535/4 "2022-03-23T21:38:58Z")

</div>

Could you please try this:

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

---

<div class="post-metadata">

**Author:** ![Prachi](https://avatars.discourse-cdn.com/v4/letter/p/7ea924/32.png) [@Prachi](https://community.amazonquick.com/u/Prachi)\
**Post date:** [March 23, 2022, 9:59pm UTC](https://community.amazonquick.com/t/visual-key-performance-indicators/2535/5 "2022-03-23T21:59:15Z")

</div>

It worked finally, did a little tweak in the end date. Thank you 🙂

 ![image](https://d1wl4jav5dp96l.cloudfront.net/original/2X/5/59d9b1280b3aaae39f517f7fe0529afe6575fed7.png)