Forum Discussion

UPF1KOR's avatar
UPF1KOR
Frequent Visitor
2 years ago

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.

 

 

1 Reply

  • VijayP's avatar
    VijayP
    Community Champion

    UPF1KOR  Try using this measure

    Line Value = CALCULATE([Measure for Line],FILTER(table,shiftlevel column = Desired shiftlevel column)), 

    This measure shows the line only for that portion