# Weekly analysis for reports **URL:** \ **Category:** Q&A\ **Tags:** filters-controls-and-parameters, Business-Intelligence-Engineer, quick-sight\ **Created:** [May 15, 2024, 5:53pm UTC](https://community.amazonquick.com/t/weekly-analysis-for-reports/30108 "2024-05-15T17:53:42Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![GauriQS](https://avatars.discourse-cdn.com/v4/letter/g/edb3f5/32.png) [@GauriQS](https://community.amazonquick.com/u/GauriQS)\ **Post date:** [May 15, 2024, 5:53pm UTC](https://community.amazonquick.com/t/weekly-analysis-for-reports/30108/1 "2024-05-15T17:53:42Z")
I’ve set up CID dashboards where my data is accessible. By default, the data granularity is monthly. However, I require weekly data analysis. What adjustments should I make? ---
**Author:** ![shravya](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/shravya/32/9969_2.png) [@shravya](https://community.amazonquick.com/u/shravya)\ **Post date:** [May 17, 2024, 3:00am UTC](https://community.amazonquick.com/t/weekly-analysis-for-reports/30108/2 "2024-05-17T03:00:21Z")
Hi @GauriQS, So, you want to adjust the data granularity in CID dashboards from monthly to weekly. You can follow the below way to adjust it. You can click on the 3 dots beside the date field and click aggregate by week. ![WeekAggregation](https://d1wl4jav5dp96l.cloudfront.net/original/3X/6/b/6bc96fc97cd91e147443d6fa1b82d6f07a9d93b1.gif) Let me know if this is what expected and if this answered your question Thank you, Shravya ---
**Author:** ![GauriQS](https://avatars.discourse-cdn.com/v4/letter/g/edb3f5/32.png) [@GauriQS](https://community.amazonquick.com/u/GauriQS)\ **Post date:** [May 17, 2024, 4:15am UTC](https://community.amazonquick.com/t/weekly-analysis-for-reports/30108/3 "2024-05-17T04:15:20Z")
Hello Shravya, Thanks for responding. I have changed the data granularity from month to week. However, I am unable to view the weekly data, as it shows no data for the selected visual. Data is only visible when I choose monthly aggregation. If you have any ideas or solutions for this, please let me know. ---
**Author:** ![Sanjeeb2022](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/sanjeeb2022/32/20947_2.png) [@Sanjeeb2022](https://community.amazonquick.com/u/Sanjeeb2022)\ **Post date:** [May 17, 2024, 5:52am UTC](https://community.amazonquick.com/t/weekly-analysis-for-reports/30108/4 "2024-05-17T05:52:45Z")
Hello @GauriQS - I will suggest create a simple graph ( tabular) and see whether you are able to see the data on weekly basis or not. Regards - Sanjeeb ---
**Author:** ![Sanjeeb2022](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/sanjeeb2022/32/20947_2.png) [@Sanjeeb2022](https://community.amazonquick.com/u/Sanjeeb2022)\ **Post date:** [May 17, 2024, 5:53am UTC](https://community.amazonquick.com/t/weekly-analysis-for-reports/30108/5 "2024-05-17T05:53:43Z")
Thanks @shravya . I thought of create a calculated field and sum on daily basis, however the info is available in QS easily ( power of QS). Thanks for sharing this. Regards - Sanjeeb ---
**Author:** ![abacon](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/abacon/32/2291_2.png) [@abacon](https://community.amazonquick.com/u/abacon)\ **Post date:** [May 22, 2024, 3:08pm UTC](https://community.amazonquick.com/t/weekly-analysis-for-reports/30108/6 "2024-05-22T15:08:16Z")
Hi @GauriQS, I’m just checking in on this question, as we have not heard back from you. Did the response from @Sanjeeb2022 help? If we do not hear back in the next 3 days, we will archive the question. Many Thanks, Andrew ---
**Author:** ![GauriQS](https://avatars.discourse-cdn.com/v4/letter/g/edb3f5/32.png) [@GauriQS](https://community.amazonquick.com/u/GauriQS)\ **Post date:** [May 23, 2024, 12:23pm UTC](https://community.amazonquick.com/t/weekly-analysis-for-reports/30108/7 "2024-05-23T12:23:09Z")
Hello Abacon, I have created a calculated field for the week, derived daily data, and used it for analysis Regards, GauriQS ---
**Author:** ![Sanjeeb2022](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/sanjeeb2022/32/20947_2.png) [@Sanjeeb2022](https://community.amazonquick.com/u/Sanjeeb2022)\ **Post date:** [May 23, 2024, 4:21pm UTC](https://community.amazonquick.com/t/weekly-analysis-for-reports/30108/8 "2024-05-23T16:21:59Z")
Thank you @GauriQS . Can you please mark the require reply as the solution so that it can help other community member. Regards - Sanjeeb