Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Stupid question.
How do I write an average expression for this?
This expression gets me the run line. Now I need an average. I can't seem to get this worked out for some reason.
if(Support_Commitment='SCV Not Available',avg(distinct TOTAL_OUTAGE_DURATION_HOURS),(sum(TotalWSC)+sum(TotalOSC)))
If you want on top of Average, You can define like
Avg({<Support_Commitment = {"SCV Not Available"}>} Aggr(if(Support_Commitment='SCV Not Available',avg(distinct TOTAL_OUTAGE_DURATION_HOURS),(sum(TotalWSC)+sum(TotalOSC))), ChartDim1, ChartDim2))
Do you have Support_Commitment as one of the dimensions in the chart where you are using the above expression?
If you want on top of Average, You can define like
Avg({<Support_Commitment = {"SCV Not Available"}>} Aggr(if(Support_Commitment='SCV Not Available',avg(distinct TOTAL_OUTAGE_DURATION_HOURS),(sum(TotalWSC)+sum(TotalOSC))), ChartDim1, ChartDim2))