Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi....
does anyone know how I can give a personalized order to columns in a chart?
I found only other ordering criteria such as alphabetic order, numbers....
In this case I need to order the second dimension of a chart.
the order should be "rete"-"prodotto"-"servizi"-"marchio"...
Any idea?
Thank you very much in advance for your help!
Bye
Silvia
Hi Silvia,
if you got a individuel sort order for a field, you can create an additional table containing the according field and a order-field to use it for sorting in your charts.
Check out the second chart in my little example app. The Column Name is sorted by expression --> Field Sortorder
HtH
Roland
unfortunately with the free edition I cannot open the file you attached to your message....
anyway, I try to follow your instructions.
Thank you so much!
Bye Silvia
Hi again,
here is the load-script snippet.
DimTable:
LOAD * Inline [
Name, Prename, Val
marchio, Reste, 100
rete, Alfonso, 200
prodotto, Amalia, 300
servizi, Guiseppe, 400
];
SortTable:
LOAD * Inline [
Name, SortOrder
rete, 1
prodotto,2
servizi,3
marchio,4
];
After loading build for ex. a straight table chart with Dims = Name and Prename and
a simple expression like sum(Val).
In sort tab check "Sort By Expression" for Name and put in "SortOrder" into expression editor.
If you got problems with it, post your app. People with an fully licenced version can open it
RR