Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How do I get the number of rows that have a value in a dimension?
I have tried:
Sum(Aggr(Count(DISTINCT {<ExpectedCases = {'*'}>} OperatorName),OperatorName))
noofrows(column(1))
Sum(if(isnum($(vEC))=-1,1,0))
max(rank(total column(1))
What I'm trying to do is modify this formula
(rank(total column(1))/(noofrows(TOTAL)/2))-1
so that denominator is number of records in the dimension that have a value instead of the total records in the dimension.
Please let me know if you have any questions.
Wow, I am glad it finally worked, but it leaves me cursious why some of the others didn't work.... Another option to use in the chart may be this
NoOfRows(TOTAL)