Sort graph values by sum of count

[loic_dev]

Hello experts,

I have a problem sorting my graph, i would need some help ^^'

My measure is this little expression: Count({<$(vChoixSA)>} Num_FIF)

I wanted to sort the result by the sum of my count for each customer but nothing is working 😞

Could anyone help me please ???

Thank you very much guys

[Digvijay_Singh]

Is Customer the dimension on Y axis? If yes then you need to sort by expression and use something like this

Count(Total<Customer> {<$(vChoixSA)>} Num_FIF)

Use descending or ascending property as you desire.

Thanks,

[loic_dev]

Yes you're right, Customer is the dimension on the Y axis, and I already tried this expression but the result is not what i need...

The add of TOTAL<Customer> don't change anything

Maybe something to make a sum by customer (or Nom_H1 which is my other dimension) of  "Count{<$(vChoixSA)>} Num_FIF)"

Thanks,

Loïc

[Digvijay_Singh]

Can you share the image of location where you tried this, I am still thinking why its not working, I recently used it in one of my chart and it worked.

[Digvijay_Singh · Accepted solution]

Other option could be

Aggr(Count({<$(vChoixSA)>} Num_FIF),Customer) in the sort properties under customer dimension. Customer dimension should be the first one in the sort properties.

[loic_dev]

I do not think i am doing something wrong...

I'm getting this problem when i add my second dimension on the chart

[loic_dev]

I have the same result with this expression

[loic_dev]

I think this is a data problem here, your expression seems correct

Thanks,

Regards