Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i have a scenario where i have to get top 5 repetitive complaints of the month
how can i achieve this?
Try this way with your data fields
=If(AGGR (rank(sum(Sales)), Customer) <=5 , Customer)
Try:
If(AGGR (Rank(Count(Sales)), Customer) <=5 , Customer)
but how this expression will find the repetitive values?
Count() will count the frequency, if you rank on them that means most numbers of times occured sales would be taken into consideration. If any doubt, please sample app.
i have two columns named:complain and month ,i want to get the repetitive compalints of the individual months from jan to dec so how an i achieve this
Hi Shivali,
may be like attached sample?