Hi I have a chart shown as following, I would like to
1. change the dimention of grade from 'A.xpb' to 'A'. How could I do it either in script or directly in the chart?
2.I would like to label each grade in their area, such as lable 'E' in the green area.
Thanks so much!
Thx, but it seems to change the name of the label not each exact value of the label. In my sample if I choose the label box and it just change the show of 'Grade' not the 'A.xpb' to 'A'.
In the script I don't know how to change it seam it is the value of one variable, I could only load the [Grade] field....
Do you have another method?
Oh.. I see.
So you need to add into the script
,Pick(WildMatch(Grade, 'A*','B*','C*','D*','E*'), 'A','B','C','D','E') AS NewGrade
Reload script and use NewGrade as dimension
1. You can use Pick(WildMatch(Grade, 'A*','B*','C*','D*','E*'), 'A','B','C','D','E') as @ Sergey Makushinsky Or else write a if condition.
2. I am not sure. But you can re-arrange the position of the labels by holding shift+cntrl keys and move the label panel to desired location.
The second question..
I don't think that it's a good idea, because you don't know where you able to put it because of weight...
But I need to think it over.