Customising currency display in single score charts on dashboards. ie. $28,500,000.00 becomes $28.5M

Michael255
Kilo Sage

Hi,

I am looking for a way to change the display of dollar values in single score charts that will end up in a dashboard for executives.

Specifically I'd like possible round/truncate the number to do something like the following:

  • What currently displays as $28,506,006.30 would display as $28.5M
  • What currently displays as $2,795.00 would display as $2.8K

Is anyone able to steer me in the best direction?

1 ACCEPTED SOLUTION

Adam Stout
ServiceNow Employee
ServiceNow Employee

While Report Single Scores show you the full value, Performance Analytics Single Scores do this formatting.  While it would be overkill just for this, do you have the option to use Performance Analytics for this?  That would allow you to show the trend over time as well to the executives.

View solution in original post

7 REPLIES 7

The only downside to this is interactive filters do not work with PA widgets.  I know we can do the breakdown filters, but we can't filter multiple breakdowns at once like we can with several interactive filter widgets.  Are there any other workarounds? 

Michael255
Kilo Sage

Thanks for your help

melissahill
Tera Contributor

Please vote on this idea to get it moved up in ServiceNow's idea hopper:

https://community.servicenow.com/community?id=view_idea&sysparm_idea_id=f08b5fcedbbbd0d07d3e02d5ca96198b&sysparm_idea_table=x_snc_com_ideation_idea&sysparm_module_id=enhancement_requests