Forum Discussion
Stacked chart and date drilldown
Hello
I have a two tables with date/time and several columns worth of data in each. I have for each created a Date column without the time, and created a separate table with just a Date in it as well. All Date tables are set up with a hieracy Year, Qtr, Month, Date and the two tables with date have a Many-One relationsship with the Date table.
I currently have a stacked chart with axis as date and values set to max. My problem is when I would like to click 2012 for example, and then the Stacked bar chart should zoom in and show values spread out over 2012 from january-december. Instead it just shows the values for that year as dot.
How do I go about getting it to "zoom" correctly to that area? Or for instance can I use a Slicer with dates and then get it too zoom after that?
4 Replies
- timg
Solution Sage
Hi ,
Could you verify whether you are using the date or the year in the axis? If you have the date selected, it should still show all dates within the year interval you filter. If you used year in the axis it will indeed only return a dot since it will aggregate the values by year. Below you'll find an example:
Best regards,
Tim
