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

user006099
user006099 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
Up
4 votes

In Review · Last Updated

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

Comments

  • G_Grey
    G_Grey 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


  • user006099
    user006099 Member

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

Categories