Sorting on expression

[manu1512]

Hi all,

I have created a bar chart where i am sorting based on expression but when i am selecting a field the sorting is not working ..

Can any one help?? me in this

expression used :=round(count({<Equipment_isSMA_Upgrade_Eligible={1},Temp_isEquipmentNoContract={0},Report_Year=,Year=,Flag={1},Is_Deleted={'N'}>}distinct if(Mod_EquipmentStartDate<=Today() and Mod_ContractLineEndDate >=Today() and Mod_ContractLineStartDate <= Today(), Equipment_Id))
/Rangesum(Above(Sum({<Equipment_isSMA_Upgrade_Eligible={1},Flag={2},Year=,MonthYear=>}EquipmentCount),0,Rowno())),0.0001)

[felipedl]

Whats the expected outcome? To order by the percentage you have on chart?
Can you share the app? The expression is quite large and without context, its hard to evaluate what's the best approach to do it.

[manu1512]

Hi ,

Yes i am trying to sort by the percentage

[felipedl]

Whats the expression your using to calculate the percentage?
That's the one you need to sort it out by the calculation, rather than the dimension itself.
Problem is, you can have multiple calculations being made by chart and can get quite confusing to sync all up.
Can you share the app?