Hello,
I would like to add a horizontal reference average line to my combo chart. the average reference line will show the average time and I am not able to do that as the time is a measure field, a continuous one and I am not able to filter down the same with either the if statement or the set expression. I need a simple thing to show, something like this:
=if(Match([Client],'A') and Match([type],'B'),time)
The measure- time is already created using the avg aggregation and stored in a similar fashion. Hence I don't need to do an average again in the if statement.
Any help would be useful!
