Gauge question

[#1]

Hi guys,

Can you help me with this? I've created a gauge that includes a 0-5 rating. However, I'd like to exclude the 0 ratings in the average? How do I do it? Thanks 

[lironbaram]

hi

you can use

avg({<Humorrating={">0"}>}Humorrating)

[#3]

Perfekt thanks alot

[skaredovs]

or avg(if(Humorrating>0,Humorrating))

[lironbaram]

great it helps

please mark the discussion answered so other people will know