if GroupA is your dimension in bar chart you can replace with a calculated dimension
=pick(match(GroupA,1,4,9,16,25), 'Highly disagree', 'disagree', 'no opinion', 'agree', 'highly agree')
or if you prefer you can do the same thing in the script
// make some test data with 1, 2, 9, 16, 25
rowno() as id,
Pick(Ceil(5*Rand1),1,4,9,16,25) as GroupA;
Rand() as Rand1
While Rand()<=0.5 or IterNo()=1;
// replace 1,4,9.... with Highly......
pick(match(GroupA,1,4,9,16,25), 'Highly disagree', 'disagree', 'no opinion', 'agree', 'highly agree') as NewGroupA,
drop table sqlserver;
Thanks Buddy, that works like a charm.
i like to see the dimension in a order i want. how to sort them? i know i can go to the sort tab and i should write an Expression beside Expression check box.
but what Expression?
Something like :
SortInThisWay('Highly Disagree','Disagree','No Opinion','Agree','Highly Agree')
I need to tell you that i created a cyclic group including 12 Expressions one for each column.
the name of this Cyclic group is QST, i tried this for sorting:
Match(QST,'Highly Disagree','Disagree','No Opinion','Agree','Highly Agree')
but it says bad field name : QST because QST is not actually a field