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

[alespooletto]

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

7

3.30%

Notebook

8

5.13%

Tablet AGV

8

8.53%

Posta

20

17.70%

SAP

9

21.26%

Others

2.07

29.68%

[JandreKillianRIC · Accepted solution]

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

[alespooletto]

Thanks a lot @JandreKillianRIC !

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

[JandreKillianRIC]

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

[alespooletto]

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