# Creating comparison periods **URL:** \ **Category:** Q&A\ **Tags:** analysis, calculations, quick-sight\ **Created:** [August 18, 2023, 9:03pm UTC](https://community.amazonquick.com/t/creating-comparison-periods/17200 "2023-08-18T21:03:00Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![kstory](https://avatars.discourse-cdn.com/v4/letter/k/e68b1a/32.png) [@kstory](https://community.amazonquick.com/u/kstory)\ **Post date:** [August 18, 2023, 9:03pm UTC](https://community.amazonquick.com/t/creating-comparison-periods/17200/1 "2023-08-18T21:03:00Z")
How can I make a comparison period where I take a metric and select a single week and then the tile with the metric shows me the value of that metric the previous week? I want the option to see my metrics week over week and year over year but there doesn’t appear to be a very selectable way to do this. Whenever I select a date it shows me the metric value but doesn’t show the previous week’s value. ---
**Author:** ![WLS-D](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/wls-d/32/36109_2.png) [@WLS-D](https://community.amazonquick.com/u/WLS-D)\ **Post date:** [August 18, 2023, 9:28pm UTC](https://community.amazonquick.com/t/creating-comparison-periods/17200/2 "2023-08-18T21:28:46Z")
Hello @kstory! Would using a KPI visual and a date filter like the one I have set up below?: ![Screenshot 2023-08-18 162729](https://d1wl4jav5dp96l.cloudfront.net/original/2X/f/fc75bcf75a92dec868b2451ab5eb2465bfec6bfa.jpeg) Let me know if this works! ---
**Author:** ![kstory](https://avatars.discourse-cdn.com/v4/letter/k/e68b1a/32.png) [@kstory](https://community.amazonquick.com/u/kstory)\ **Post date:** [August 21, 2023, 1:28pm UTC](https://community.amazonquick.com/t/creating-comparison-periods/17200/3 "2023-08-21T13:28:30Z")
Thanks for the suggestion! I was hoping for a visual that would auto change the two weeks in the upper corners whenever I select a one-week window. Like if i select the date, July 16 - 22, the other corner will auto populate with data for July 9 - 15. ---
**Author:** ![WLS-D](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/wls-d/32/36109_2.png) [@WLS-D](https://community.amazonquick.com/u/WLS-D)\ **Post date:** [August 22, 2023, 3:17pm UTC](https://community.amazonquick.com/t/creating-comparison-periods/17200/4 "2023-08-22T15:17:24Z")
Hey @kstory , Is the screenshot below what you are looking for? The way that KPI visuals can be formatted allows you to show the sum, count, or avg (based on your field well aggregation) for the value that you are trying to display based on the time frame. ![Screenshot 2023-08-22 101317](https://d1wl4jav5dp96l.cloudfront.net/original/2X/b/b4a2e00786ca9deafe8e4453df118c993471df57.jpeg) ---
**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:** [August 28, 2023, 8:28pm UTC](https://community.amazonquick.com/t/creating-comparison-periods/17200/5 "2023-08-28T20:28:47Z")
@kstory We have not heard back from you regarding your question. We would still like to help. If we do not hear back in the next 3 days, we will archive the question. ---
**Author:** ![kstory](https://avatars.discourse-cdn.com/v4/letter/k/e68b1a/32.png) [@kstory](https://community.amazonquick.com/u/kstory)\ **Post date:** [August 29, 2023, 1:38pm UTC](https://community.amazonquick.com/t/creating-comparison-periods/17200/6 "2023-08-29T13:38:08Z")
Yes, the solution provided by Duncan worked. Thank you! ---
**Author:** ![Joseph\_W\_Waldrum](https://avatars.discourse-cdn.com/v4/letter/j/22d042/32.png) [@Joseph\_W\_Waldrum](https://community.amazonquick.com/u/Joseph_W_Waldrum)\ **Post date:** [August 22, 2024, 4:17pm UTC](https://community.amazonquick.com/t/creating-comparison-periods/17200/7 "2024-08-22T16:17:23Z")
Hey, so I am playing with the analysis done in the comments above. What I am working on is a tad bit different. I have it how you have it set up but need the settings changed and not sure if it is a possibility. I am trying to get a summed count for a MTD metric but have that compare it to the prior year same period. For instance August 1-22 2024 and then comparing that to Aug 1-22 2023. Would need it to continuously stay MTD as the date changes through new periods