Use this as expression: match(column_name,'value1','value2','value3','value4'). The expression will return 1 if the value of column_name is value1, returns 2 for value2 etc. It transforms the string values in numbers. You can set the segment borders at 1,2,3 and 4.
That trick seems to be working. I wrote the match condition based on my condition and changed the gauge setting in the 'Presentation' tab. I have set up the segments I need, I have different colors for different segment.
When I see in the 'Style' tab, I am able to see the gauge needle raised to the segment based on the data but for some reason, the actual gauge needle (sheet object) is not raised based on the value in data.
Not sure why is that, I have the right coloumn in the 'Dimensions' tab, I have defined the condition in the 'Expressions' tab..
Okie, I just found out that what ever changes that is happening in charts in the 'Style' tab is based on the settings we give in the 'Presentation' tab.
So the actual object in the sheet is the one that reflects the data. But that is not seems to be working.
I think the expression that you provided will work when loading the script. I will try that once.
But if anybody has any comments or suggestions please let me know.
