Sorting Stacks in Stacked Bar Chart

tsbrian — Mon, 10 Jul 2023 16:23:43 GMT

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

Re: Sorting Stacks in Stacked Bar Chart

sidhiq91 — Mon, 10 Jul 2023 17:27:05 GMT

@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.

topic Re: Sorting Stacks in Stacked Bar Chart in App Development

Sorting Stacks in Stacked Bar Chart

Re: Sorting Stacks in Stacked Bar Chart