# Drill down by date in line chart (dashboard) **URL:** \ **Category:** Q&A\ **Tags:** dashboard, Business-Intelligence-Engineer, quick-sight\ **Created:** [December 18, 2024, 2:56pm UTC](https://community.amazonquick.com/t/drill-down-by-date-in-line-chart-dashboard/40141 "2024-12-18T14:56:29Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![jonfrank3366](https://avatars.discourse-cdn.com/v4/letter/j/c5a1d2/32.png) [@jonfrank3366](https://community.amazonquick.com/u/jonfrank3366)\ **Post date:** [December 18, 2024, 2:56pm UTC](https://community.amazonquick.com/t/drill-down-by-date-in-line-chart-dashboard/40141/1 "2024-12-18T14:56:29Z")
Hello, I have a date field that is set as a date type. I can change aggregation in my line chart visual in the analysis both in the visual and on the field well without issue. I can’t do this in the dashboard though. My end users need to be able to see the data by various date aggregations. Documentation I’ve read indicates this should work, but I don’t have the ability to change the aggregation type in the published dashboard version of the analysis. Am I missing something or is this not possible to do in the dashboard? Thanks! ---
**Author:** ![prantika\_sinha](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/prantika_sinha/32/21878_2.png) [@prantika\_sinha](https://community.amazonquick.com/u/prantika_sinha)\ **Post date:** [December 18, 2024, 3:42pm UTC](https://community.amazonquick.com/t/drill-down-by-date-in-line-chart-dashboard/40141/2 "2024-12-18T15:42:05Z")
Hi @jonfrank3366 , When you publish the dashboard, can you check the option under Data point options checked for drill down? ![image](https://d1wl4jav5dp96l.cloudfront.net/original/3X/9/4/941aaad6e1ae6b7bfafa0bc9a4a01c7c6a6dedcb.png) Thanks, Prantika ---
**Author:** ![Brett](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/brett/32/36494_2.png) [@Brett](https://community.amazonquick.com/u/Brett)\ **Post date:** [December 18, 2024, 3:45pm UTC](https://community.amazonquick.com/t/drill-down-by-date-in-line-chart-dashboard/40141/3 "2024-12-18T15:45:06Z")
Hi @jonfrank3366, The easiest/quickest way to handle this (which would require your sheet to be in free form); would be to create copies of your visual, one for each time aggregation. Then, create a custom drop down parameter for those time aggregations (you’ll create a string parameter though) and add a control on the sheet for it. Last, you’ll create a rule for each of your visual copies. You’ll set them to match the parameter you just created (I.E. When parameter equals ‘Day’, show the ‘by day’ visual. Check out this Arena View where I setup this scenario and let us know if you have any additional questions [Drill Down By Date in Line Chart](https://community.amazonquick.com#Arena-dashboardId=120a7214-8116-4bed-a4da-0dd3ce25c5b5&authorId=CU-15230) ---
**Author:** ![jonfrank3366](https://avatars.discourse-cdn.com/v4/letter/j/c5a1d2/32.png) [@jonfrank3366](https://community.amazonquick.com/u/jonfrank3366)\ **Post date:** [December 18, 2024, 4:51pm UTC](https://community.amazonquick.com/t/drill-down-by-date-in-line-chart-dashboard/40141/4 "2024-12-18T16:51:39Z")
Thanks. Unfortunately this is already enabled when I go to the advanced settings in the publish screen. ![image](https://d1wl4jav5dp96l.cloudfront.net/original/3X/9/9/99473857cbfa02040a2ca1feffc95e41858b6047.png) ---
**Author:** ![jonfrank3366](https://avatars.discourse-cdn.com/v4/letter/j/c5a1d2/32.png) [@jonfrank3366](https://community.amazonquick.com/u/jonfrank3366)\ **Post date:** [December 18, 2024, 4:52pm UTC](https://community.amazonquick.com/t/drill-down-by-date-in-line-chart-dashboard/40141/5 "2024-12-18T16:52:39Z")
Thank you for sharing. I appreciate the thoughtfulness and effort. Is there not a simpler way to handle this though? This seems like something really basic that any BI tool should be able to do, provided the date field is formatted as a date type. ---
**Author:** ![prantika\_sinha](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/prantika_sinha/32/21878_2.png) [@prantika\_sinha](https://community.amazonquick.com/u/prantika_sinha)\ **Post date:** [December 18, 2024, 4:56pm UTC](https://community.amazonquick.com/t/drill-down-by-date-in-line-chart-dashboard/40141/6 "2024-12-18T16:56:19Z")
Ok, next check , when you click on the data points in the dashboard do you see the option to drill down? how does it look? Do you see similar option? ![image](https://d1wl4jav5dp96l.cloudfront.net/original/3X/7/f/7f6248596612251663ede79a832642d63765c46d.png) ---
**Author:** ![jonfrank3366](https://avatars.discourse-cdn.com/v4/letter/j/c5a1d2/32.png) [@jonfrank3366](https://community.amazonquick.com/u/jonfrank3366)\ **Post date:** [December 18, 2024, 10:04pm UTC](https://community.amazonquick.com/t/drill-down-by-date-in-line-chart-dashboard/40141/7 "2024-12-18T22:04:42Z")
Wow that works! I can’t believe I was missing that. Thank you!