Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have two drilldown groups, Group1 and Group2 and one expression.
I would like to display a line chart.
In the chart, when I drilldown from Dimension1 to Dimension2,
For eg., if the percentage achieved at Dimension1 level for a field is 40%, then, all the row values at dimension 2 level
Should add upto 40% only
this one works according to the description in the document
Hi Ramon,
It is only working by first drilldown group, not by second drilldown group.
I am pulling my hair out 😕
Please see the attachement.
try with a nested if
=if(GetCurrentField(DrilldownByTime) = 'TripMonthYear',
if (GetCurrentField(DrilldownByDelay) = 'Rail', Num(sum(LateTrips)/count(LateTrips),'##.##%'),
Num(sum(LateTrips)/COUNT( total <TripMonthYear> {<DelayType>} LateTrips),'##.##%')
), Num(sum(LateTrips)/COUNT( total <TripMonthYear> {<DelayType>} LateTrips),'##.##%')
)