I have a timestamp date field in my analysis and it has come to my attention that when using bar charts and drilling down or drilling up, the drill down works as expected when using the menu options pane at the right top corner VS when I select a data point with right click and then drill down.
Example:
The way the chart is set by default:
Based on the information I have in the date field only the second option of using the right top menu returns the correct drill down hierarchy.
I also noticed that in my analysis where I have around 6 clustered bar combo chart this happens in all of them, and besides of that, the drill down/drill up options at the top right are not available in all of the charts (although they are all the same chart type). I want the user to be able to drill down using both right click and the options menu, and get the same results.
Why is this happening and how can I solve? Thanks!
Hi @joana,
When you select the ‘drill down’ option, it will drill down on the specific values that you have clicked on. For example, when date is setup as month, if you click on one of the bars in ‘February’, it will drill down to the weeks that make up February (of that year).
Whereas, when using a parameter, it will return all values within that window and group by your default aggregation setup for the visual.
Here’s some additional documentation that explores the drill up/drill down functions.
perfect Brett, that makes sense!
regarding when the options for drill down will appear or not in the top left corner, is there something in specific that needs to be activated in the visual for those options to always be available?
Hi @joana,
Drill Up/Down features are normally linked to either date fields (as they have various aggregation levels built in) or you will need to build a hierarchy.
The document I linked above it includes the visual types that allow drilling features along with what’s needed to set up through a hierarchy.
Hi @Brett, I am not seeing the ability to drill down up in the top right of visuals that are reportedly supported by quicksight. On the same dashboard, it seems that only standard bar charts are supported.
What could be difference between these two to result in this? They have the same date column in the x axis.
Also when I drill up to week and then back down to day, only the month that was attached to the week column I drilled down on is shown. The only way to reset this is drilling down to hour and then back to day. Any solve for this? You mention using parameters?
Hi @HYP_Ryan. Did you find a solution for this issue? I also am unable to get the drill up/down options on the top right of charts that should be able to have it.
