Hi all, I have a small question, I m using a simple calculated field ifelse(((completetime)>=(starttime)),‘yes’,‘no’) as ec2 acted
when I select all it is showing 101
I’ve helped the customer offline yesterday. Capturing results here for other users.
The pie chart was aggregating data using distinctCount which is not an additive measure. That’s why it is possible to see 101 both when “Select all” is selected and when “no” is selected.
To get the expected result when “no” is selected in the filter, we needed to change expression from
ifelse(((completetime)>=(starttime)),‘yes’,‘no’)
to
ifelse(((maxOver({completetime}, [event_type, event_id], PRE_AGG))>=(maxOver({starttime}, [event_type, event_id], PRE_AGG))),‘yes’,‘no’)