Aver Expression

[brf10043]

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)))

[sunny_talwar]

Do you have Support_Commitment as one of the dimensions in the chart where you are using the above expression?

[Anil_Babu_Samineni · Accepted solution]

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))