Truncate currency data labels on dashboard widgets?

Jeff Jensen (LFS)

Hello everyone,

I have a dashboard where monthly financial and fundraising info is displayed in line charts. The time frame displayed is a calendar year, so for the first few months of the year the chart is fine. After a few months however, the data labels - some for 7- and 8- figure amounts - start overlapping one another. Based on what the audience wants to see, I cannot just show a rolling window of 3-4 months instead. Is there a way to set a line graph widget so that instead of showing the full dollar amount (ex. $3,123,456) it shows a truncated version (ex. $3.1M)? I'm doubting this exists, but I'd be happy to be proven wrong. 😊 Otherwise, my options appear to be to either (1) widen the line graph to accommodate long data labels, or (2) not display the data labels.

Thanks!

Jeff

Paul Newcome

You could adjust your metrics to divide by one million then indicate on the dashboard that all figures shown are millions.

Paul Newcome

You could adjust your metrics to divide by one million then indicate on the dashboard that all figures shown are millions.

Jeff Jensen (LFS)

That is true - great suggestion! SmartSheet C/S also suggested I submit this as a product enhancement, so I may do that as well. Thanks Paul!

Paul Newcome

Happy to help. 👍️