Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have an expression to count the times the equipment goes down (next start floor is lower than current one). This is aggregated per equipment and timestamp
=count(aggr(if(([start_floor]-below([start_floor])>0),1),[equipment],[timestamp]))
I also have building filter, but the measure is set to be "Always one selected value". However now I want to show the above measure as a bar chart across all buildings. With simpler expression this works for example the next expression counts the average travel time for the buildings with less than 10 floors.
=avg({<[building]=>}if(Aggr(max({<[building]=>}[start_floor]),[building])<=10,travel_time))
I can't get the top expression to work showing all buildings. I've tried things like
=count({<[building]=>} aggr(if(([start_floor]-below([start_floor])>0),1),[equipment],[timestamp]))
and other variations but they don't work. Any idea?
May be this
=Count({<[building]>} Aggr(
If(Only({<[building]>}[start_floor]) - Below(Only({<[building]>}[start_floor])) > 0, 1)
, [equipment], [timestamp]))
May be this
=Count({<[building]>} Aggr(
If(Only({<[building]>}[start_floor]) - Below(Only({<[building]>}[start_floor])) > 0, 1)
, [equipment], [timestamp]))
Thank you! Exactly what I was looking for