Forum Discussion
Stack Column Chart in Drill Through with Line Chart having different level of Aggregation
Hi All,
I am looking for a solution if its possible.
I have a 'Line & Stacked Bar Chart' where I have 3 fields on X- Axis- Month, Date and Shift. As Stacked Bar I am using 3 values Parts Ok Count, Parts Not Ok Count and Parts Unknown Count. Now, these values when visualized will give me a nice stack chart which is aggreagted till Shift Level.
Now, I need a Line chart where the Line is aggreagted not on Shift level i.e. the lowest level but its aggreagtion on each day.So, think it as SUM of all Parts Ok in all possible shifts and show as one data points. Whats happening is, The Line chart is showing the data point on each shift level.
Refer: In below snapshot, I am looking for that blue pen marking. For 19th, there should be just one point rather than for each shift.