I am working on a bar chart to show Revenue by month. I need to show data for rolling 12 months. When we try to drill up to Quarter, chart looks fine. But issue is when we try to drill back down to Month, chart is only showing 3 months of data. It is not resetting correctly to show rolling 12 Months.
If I drill down to weeks and drill back up to month , it works.
Is this normal behavior or I am missing something ?
Thank you!
Note : I tried changing chart type to Pie Chart and changing date field, still having same issue.
One quick question to understand how do you drill down to month.
Do you right click on a bar representing the Quarter to drill down to month? Something like this:
If yes, its because when we do so, we are asking QuickSight to only drill down for the Quarter that we select. However if you use the up and down arrows on the top corner to drill up and drill down, the visual will consider whole timeline to drill down/ drill up.
If this is not the case, then will suggest you to create a sample use case in the arena to help us understand the drill down response better.
Hi @panditjoshi,
Since we haven’t heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.
