Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I just need to find the count of no of occurrence of the below data A,B,C without showing the calculation at the front end but the calculation should be done only at the expression level. A,B,C are basically the category for the three years that is 2019,2020,2021. Also the Category which appears max times should only be visible for particular customer id.
Try this
if(aggr(count({<Year = {'2019', '2020', '2021'}>} Year), CustomerID) = max(aggr(count({<Year = {'2019', '2020', '2021'}>} Year), CustomerID)),
maxstring({<Year = {'2019', '2020', '2021'}>} Category), ''),
@aarav021 not quite get what exactly you are looking for. Could you elaborate further?