Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to set the bars chart in ascending posintion , witouth using sort order
Hi John, you can also try the 'Y Value' ascending option in the sort tab, it uses the value of the first expression to sort the dimension.
Why can't you use a sort order?
Sort it in Load script using Order by and then use load order in chart unchecking any sorting option.
I hope it is helpful.
Ok so what are you expecting it to sort by?
If you're expecting it to sort as you have loaded, then you need to choose the load-order option on the sort tab
Please remember to mark this as helpful or the correct answer if I have helped you or answered your question.
Hi Adam
Actaully i 2 expressions and one dimensions .. so now i want to show the bar chart by ascending order ,
I hope i am clear , to achive this i can go for load order in this script
If iam trying to do it on the sort , its not makeing any effect
Hi John,
Copy your expression into the sort tab expression part and sort the dimension by that?
Hi John, you can also try the 'Y Value' ascending option in the sort tab, it uses the value of the first expression to sort the dimension.
perhaps, you need to give a sample to show what is your real problem
WHy you don't want to use Sort ORder. I can see you want to see by Ascending values. Or do you want by dimensions, Apart from what has been advised, you can also look at DUAL() function to defined your Dimension. Its lot helpful
What is your achievement, can you please share the screen shot which demonstrates the output