scatter chart

[deepakqlikview_123]

Hi All,

Please find my attached scatter chart.

there is a usage of calculated dimension.[Right(INDICATOR NAME,4)]

My requirement is only show four characters for CHSP and CLDT.Moreover after using this condition i got blank spaces and some unwanted letters.

For remaining indicators i need to show only last 3 characters.

Can you please suggest how shall i go ahead.

Thanks

[MK_QSL · Accepted solution]

Use below

MID(INDICATOR_NAME, INDEX(INDICATOR_NAME,' ',SubStringCount(INDICATOR_NAME,' '))+1)

[sunny_talwar]

In the attached file I just see AHP and AHT on the chart. Not sure where do you see extra spaces or letters? Please attach a sample which shows your problem.

Best,

Sunny

[deepakqlikview_123]

Hi Manish,

If name is AHT or AHP I need to show blue color otherwise need to show black color on chart please suggest.

Thanks