Adding text to a value expression

[Anonymous]

I have the following gauge in my dashboard:

I need to add text 'from last month' after the -23.1% in the chart and i tried the following expression:

=(Sum({$<$(vSetMTD)>} (Rx))/Sum({$<$(vSetPreviousMonth)>} (Rx))  - 1) & 'from last month'

This is not working as the expression is wrong.  Please assist with the right expression.

Regards.

[sunny_talwar · Accepted solution]

May be leave the expression as is and add Text in chart as this new expression above. So essentially this is what I mean

Expression: =(Sum({$<$(vSetMTD)>} (Rx))/Sum({$<$(vSetPreviousMonth)>} (Rx))  - 1)

Text in Chart (on presentation tab)

=(Sum({$<$(vSetMTD)>} (Rx))/Sum({$<$(vSetPreviousMonth)>} (Rx))  - 1) & 'from last month'

and then you can move text in chart by pressing (Ctrl + Shift) and place it at the same spot you have your current number and hide the value on data point for the expression.

Or try this as your expression without doing any of the things I mentioned above.

Dual((Sum({$<$(vSetMTD)>} (Rx))/Sum({$<$(vSetPreviousMonth)>} (Rx))  - 1) & 'from last month', (Sum({$<$(vSetMTD)>} (Rx))/Sum({$<$(vSetPreviousMonth)>} (Rx))  - 1))

[vikasmahajan]

Right Click Chart Properties - >  Text in Chart Option -> Type From Last Month  using shift + ctrl move this to desired place

HTH

Vikas

[Anonymous]

If it is fixed, then put a Text box with your required string on top just besides your expression value and set text box background transparency to 100%

[tamilarasu]

Hi Christopher,

Try your above expression like below,

[#6]

hey christopher ,

you can add a text object which will be visible on conditional.ie. it will be visible when -21.3 will be the value when your gauge will have

or you can go to presentation tab in that go to text in chart then select add. then add expression this way if((your expression which you added in gauge expression tab)>-23,'from last month'&(your expression)&'%')

[Anonymous]

Thanks Sunny, using the first option how do i hide the expression value?

[Anonymous]

Thanks Vikas

[Anonymous]

Thanks Balraj

[Anonymous]

Thanks Tamil