topic Re: Sorting by a dimension doesn't work on bar line chart in App Development

Sorting by a dimension doesn't work on bar line chart

alespooletto — Wed, 29 Jan 2025 07:18:24 GMT

I have this bar line chart and when I try to sort by the count of tickets it doesn't work, it just stays as it is shown here. What's the reason?

As it is now, the Number of ticket should be more prominent making them sorted in descending order. The measures Numero TIcket and Contributo in % are calculated as follows:

Numero ticket
Avg(Aggr(Count(Ticket_ID),Categorie))

Contributo in %
RangeSum(Above(sum([HIST_Workhourminutes]), 0, RowNo()))/sum(Total [HIST_Workhourminutes])

An excerpt of data:

Categorie	Numero Ticket	Contributo in %

Totals

4.15

0.00%

iPhone

3.30%

Notebook

5.13%

Tablet AGV

8.53%

Posta

17.70%

SAP

21.26%

Others

2.07

29.68%

Re: Sorting by a dimension doesn't work on bar line chart

JandreKillianRIC — Wed, 29 Jan 2025 08:06:05 GMT

Hi @alespooletto

On your sorting tab. Sort the dimension by expression. The expression would be

Avg(Aggr(Count(Ticket_ID),Categorie))

See the example I quickly built.

Regards Jandre

Re: Sorting by a dimension doesn't work on bar line chart

alespooletto — Wed, 29 Jan 2025 08:11:03 GMT

Thanks a lot @JandreKillianRIC !

Could I please ask you also if boxplots could be limited by top n categories like in this graph?

Re: Sorting by a dimension doesn't work on bar line chart

JandreKillianRIC — Wed, 29 Jan 2025 08:13:51 GMT

Hi @alespooletto

I will need to have a look for you. Do you have a example possibly with a inline load that you can send with the expected outcome?

Regards Jandre

Re: Sorting by a dimension doesn't work on bar line chart

alespooletto — Wed, 29 Jan 2025 08:18:53 GMT

Okay, sure thanks a lot! I guess this should be its own post then, so I will give the info directly there and tag you