Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have a stacked bar chart with 2 dimensions (YearMonth, Job Type) and 1 measure (Jobs Count). As there are many job types and I want to limit the job type by Top 5 and also i need to sort the stacks(Job Type) in descending order. I am not able to achieve this. Need help on this please.
Thanks
Vijay
@tsbrian Please use the below expression to the top 5
if(Aggr(rank(sum(jobcount)),Month,Jobtype)<=5,Jobtype)
And to sort the job type:
If this resolves the issue, please like and accept it as a solution.
@tsbrian Please use the below expression to the top 5
if(Aggr(rank(sum(jobcount)),Month,Jobtype)<=5,Jobtype)
And to sort the job type:
If this resolves the issue, please like and accept it as a solution.