Analyzer Ideas

Analyzer Ideas

Domo should give an option to manage abbrevation of Billions, Millions,,K

Member
edited December 2023 in Analyzer Ideas

The below logic should be default handled by domo for every no field.

Case 

WHEN `Choose Metric` = '$ Sales' and LENGTH(Round(Sum(`sales_12w`)))>=9 THEN Concat (Round(Sum(`sales_12w`)/1000000000,2),'B')

  WHEN `Choose Metric` = '$ Sales' and LENGTH(Round(Sum(`sales_12w`)))>=6 THEN Concat (Round(Sum(`sales_12w`)/1000000,2),'M')

  WHEN `Choose Metric` = '$ Sales' and LENGTH(Round(Sum(`sales_12w`)))>=3 THEN Concat (Round(Sum(`sales_12w`)/1000,2),'K')

  ELSE 

  Round(Sum(`sales_12w`),2)

END

4
4 votes

In Review · Last Updated

Thanks for sharing your idea! We're currently reviewing it for future enhancements. Stay tuned for updates! 👍

Comments

  • Contributor

    You might know about this already but in several visualizations there's a 'scale abbreviation' option that does what you're describing. It's not always available for all numbers in all visuals all the time, but it might help you in a pinch.

    image.png


  • Thankyou! Might be great if we implement this for all Grids and Visuals consistently or help configure this at column level

Welcome!

It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign In