I have a query that produces a lovely table
base search |chart values(Number) as State over Date by description
Date | act1 | act2 | act3
M05 | 1 _ .... | -1_ .... | 3....
M06 | 5 _ .... | -1_ .... | 3....
M07 | 5 _ .... | -1_ .... | 4....
M08 | 5 _ .... | -1_ .... | 4....
Each of the numbers under the actions relate to a state of play (not started, in progress etc).
I can create all sorts of graphs off this data but I have been asked to change the number scale to description of the action
I can change Numbers to Description to get the following data but I can only create tables from it (stats and chart needing numeric values)
Date | act1 | act2 | act3
M05 | NS_ | NA_ | IP_
M06 | Co_ | NA_ | IP_
M07 | Co_ | NA_ | IP_
M08 | Co_ | NA_ | Re_
Is there a way to change number value to a string on the axis once the chart has been completed.
Happy to go with css if can't be done in xml.
Many thanks
