Cannot Sort

[Anonymous]

Hi

I need to get the PendCategory values to be sorted on the x axis , i have tried multiple ways for this but nothing seems to work , any help is greatly appreciated .

Ways i tried to sort.

1.Regular sort options did not work

2.Apended alphabets a,b,c .... , to the pend_category and gave the calculated dimension to avoid abc on the graph and gave sorting by expression using apended column

3.Created a new column pendcategory_rank and used that column as expression.

I have attached my working document , please help me in sorting properly ,let me know if code needs to changed.

Thanks you.

[#2]

Hi Ramya,

The other way you can try is have the pending category in an another table like

id pend_category

1 >0&<3sec

2 >3&<=5sec

3 >5sec

And sort it by id. I hope what you have done is working fine.

[#3]

Hi Ramya,

Also you can remove the appended alphabets and try text (feildname)

[llauses243 · Accepted solution]

Hi Ramya,

This is my offer ... pls see image & .rar

Good luck, Luis