Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to display the region with the max value, but filtered by a specific type. I have the following formula which finds the highest region based on count of IDs.
FirstSortedValue(DISTINCT Region,-Aggr(count(ID),Region))
Now I need to limit the above formula to evaluate where "Type" column is only "Robo". I tried using set analysis, but was unsuccessful:
=FirstSortedValue(DISTINCT Region,-Aggr(count({<Type={'Robo'}>}ID),PROVINCIA))
How do I find the Region with the highest count of IDs where Type is only 'Robo'?
Your formula should work, Is that not working for you?
=FirstSortedValue(DISTINCT Region,-Aggr(count({<Type={'Robo'}>}ID),PROVINCIA))
If it is not working, Perhaps restrict at end of dimension as well
=FirstSortedValue({<Type={'Robo'}>} DISTINCT Region,-Aggr(count({<Type={'Robo'}>}ID),PROVINCIA))
Or
=FirstSortedValue({<Type={'Robo'}>} DISTINCT Region,-Aggr(NODISTINCT count({<Type={'Robo'}>}ID),PROVINCIA))