topic Number of Occurrence in Visualization and Usability

Number of Occurrence

aarav021 — Fri, 04 Nov 2022 10:28:32 GMT

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.

Re: Number of Occurrence

Chanty4u — Sat, 29 Apr 2023 07:13:16 GMT

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), ''),

Re: Number of Occurrence

Kushal_Chawda — Sat, 29 Apr 2023 20:02:10 GMT

@aarav021 not quite get what exactly you are looking for. Could you elaborate further?