Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am having trouble creating a graph that will only display values about a certain range. I have a Company list and there avg rev. ave rev is an expression. I only want to display ave revs above a certain value on my graph. How can I do this? since it is am expression I cant write a dimension that will hide the zeros, or can?
Thank you
try an IF condition.
IF(avg(revenue)>10,avg(revenue))
this will only show the average revenue, if its hihher than 10