Performance analytics - spm report - how to show string in a score

[Daniele B]

Hi all!

My question is quite simple: is it possible show a string instead of a number in a score? (of course the string has the corrispective number eg.: green=2)

In a nutshell, follow is what I need:

thank you 

[AndersBGS]

Hi @Daniele B ,

The short answer is no - it's not possible.

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders

[Tai Vu]

Hi @Daniele B 

The Value field store the score result is in Decimal type. And there's no aggregation to return a string result as well.

I think what you're looking for is the Direction or the Target. These configuration will give you the color Red and Green based on the score up or down.

Cheers,

Tai Vu

[Daniele B]

Hi Tai VU,

Yes of course I will fill it with a color by target and threesholds but for a best user experience I need also to modify the number with something different

[Daniele B]

Hi all, 

@Tai Vu @AndersBGS , thank you for your answers; anyway, I know how color the number but my goal is change the number

Regards