I want to to create a Master Item to be used as a Dimension in some of my charts. I need to show only the streets with more than 9 houses.
I tried the following:
But it returns an Invalid Dimension, any ideas?
Thanks in advance.
if( aggr(sum( NUM_OF_HOUSES),STREET)>=10, STREET, Null())
Retrieving data ...