Forum Discussion
Customize hierarchy drill down line chart
Hi!
I need help to customize a line chart when I drill down in a hierarchy. I want to compare the count of two products A and B that is visualized in a line chart. The X-axis is a hierarchy of "age" (week and day). However these are not related to a normal "date hierarchy".
I would like the x-axis to show one level of the hierarchy (week) but the lines in the visual to show the next level in the hierarchy (day) to be able to see the daily fluctuations
I tried to drill down and switch off concatenate labels, however this is the result (below), where only some weeks are showing and I would like to avoid the need to scroll.
I am expecting a result like this, so one is able to see the fuctuations in day, however that the x-axis shows weeks:
2 Replies
- vanessafvg
Community Champion
so if i understand correctly what you are saying is when you drill down to day you dont want to see the weeks you only want to see the days? how are you drilling down to week? are you using the expanding arrow or the drill down arrow
So when I used the drilldown that you marked above, then the x-axis only shows a small interval of the whole "age" range in weeks. In the screenshot below I only see for example week 25, 26, 27, 28, 29, 30.
I would like/ expect to see the whole range on the x-axis (which is week 14 to 80) and the x-axis should show weeks and the line itself should show the spike in days not weeks. My expected result is show in the picture below:
So my 2 problems are:
1) If I do drill down, then the x-axis range is cut into only a small interval, and the line chart does not show the whole picture/ gives very little information.
2) If I don't do a drill down, then the line in the chart only shows what is reflected in the x-axis . If the x-axis is weeks - the line shows spikes in weeks. If the x-axis is days - then the line shows spikes in days. But I need to combine those two, so the x-axis shows weeks and the line itself shows spikes in days.
