sorting in line chart

[#1]

I am using a line chart in which I have dimensions D1, D2 and an expression E.

I want to sort D2 using a logic other than 'E'. I tried to write that logic in the the sort tab but still the dimension is getting sorted on value of 'E'.

Any other way of sorting the expression?

[#2]

I think sorting done first based on expression then based on your sorting criteria

Try to give the sorting condition is D2 in sorting tab

[#3]

arumamahesh‌ I gave sorting condition in sorting tab only. Still D2 is getting sorted on expression only.

[Anonymous]

Hi Paul,

I do think you can sort by D2 only. I think you can just try unchecking all the checkboxing and leaving the expression one checked. All the other dimensions should have all their checkboxes unchecked. Please see below

[jsingh71]

Use Promte/Demote option under Sort tab and make the dimension in first position (based on you want to sort)  and uncheck all the sorting checkbox for expression.

[#6]

I have done that only. Please check the attached screenshot.

[#7]

There is no option of Promote/ Demote in Sort Tab. I think that comes in straight table only.

[sasiparupudi1]

does it work if you change the sort order to say state /descending/ascending?

may be you have an error in your expression perhaps?

hth

Sas

[Anonymous]

To promote the dimension, you will have to promote in the dimensions tab.

[#10]

I converted the same chart to line chart and it was showing correct result. So I don't think there is any error in expression.