Regarding Formatting

[Ns7703]

There is a field SFS_Rating and it has values 5-,5+,6-,6+ and so on . I am using this field in gauge chart. What is the correct expression for this so that it show the correct value. I am attaching the screenshot. I need to show this field in Gauge chart . What expression should I use for this?

[JandreKillianRIC · Accepted solution]

Hi @Ns7703 

This value is currently seen as a text field. I would change this to make it a number. See script below 

Load 
	No,
	SFS_Rating as SFS_Rating_Original,
    IF(Len(SFS_Rating) = 2, 
    	Left(SFS_Rating, 1) * (Right(SFS_Rating, 1)&1), 
        	SFS_Rating) as SFS_Rating;
Load * Inline [
SFS_Rating, No
5-, 1
4+, 2
3-, 3
5+, 4
8+, 5
6-, 6];

For the gauge - I would use a sum of the new rating field (Number field) but change the min and max levels. 

Result should be something like this. 

Regards Jandre

[Ns7703]

Thankyou!!

[JandreKillianRIC]

Hi @Ns7703 

Only a pleasure! Glad it was the solution to the issue you were facing!