Dynamic Currency Symbol Formatting

brycec · 2023-09-14T21:08:24+00:00

There was an error rendering this rich post.

Currently in Analyzer, number columns can be formatted as currency, allowing you to append one of 4 currency symbols to the beginning of the number in the chart. It would be incredibly useful to add a dynamic currency column option. Rather than having to select 1 currency symbol for the whole column, you could select "Dynamic", select a column in the DataSet that represents your ISO 4217 alpha formatted currency code, then the currency symbol on that row would change depending on the currency code in the selected currency column in the same row. Below is an example of how the data would look, using a VLOOKUP function in Excel. The Currency column on the right is what you would select and be in the DataSet. The symbol column is something Domo would map on the backend to the ISO codes.

Find more posts tagged with

Analyzer

Dataset

Formatting

In Review

Status: In Review

Comments

JerryZ

There are only 4 currency symbols available on Domo cards. If Domo could add more symbols, like Korean won ₩, it would be epic. There are so many currency symbols in the world, and I would like to hand-pick them in my Domo instance. Also, there are quite a few other dollars aside from USD, like A$ (AUD), C$ (CAD), and S$ (SGD).

Matt Tannyhill

@brycec thanks for sharing this idea and for walking me through it at Domopalooza! Definitely something we'll consider for the future.

brycec

For those finding this post and looking for a work around, see below.

Beast Mode 1:

(CASE `Currency`

  WHEN 'USD' THEN '$'

  WHEN 'GBP' THEN '£'

  WHEN 'SGD' THEN '$'

  WHEN 'EUR' THEN '€'

  WHEN 'INR' THEN '₹'

  WHEN 'AUD' THEN '$'

  WHEN 'CAD' THEN '$'

  -- Add more currencies as needed. 
  -- This can also be a column in your DataSet if you have a lot and want to easily use elsewhere. Just join on ISO 3-letter currency codes. 

   ELSE '$'

END)

Beast Mode 2:

CONCAT(MAX(`Beast Mode 1`), FORMAT(SUM(SUM(`Amount`) FIXED (BY `Column`)), 2))

If using as a single number chart, use the "Textbox" chart type. Then use Beast mode 2 as your "Optional value" and then use the below Beast Mode 3 as your Text. To use color rules, you must first use Beast Mode 3 on a "Single value" chart. Set your color rules there and save the card. Then, switch to a Textbox chart and as long as you use the same column, your color rules will remain in effect, despite the color options disappearing.
Beast Mode 3:

SUM(SUM(`Amount`) FIXED (BY `Column`))

Note: The FORMAT function will cause the Beast Mode editor to say your formula is invalid. Ignore it. Save the Beast Mode. Then, before using it anywhere, save the card. Then you can use the Beast Mode as you please. So, to create Beast Mode 2, you need to do those steps first, but then before adding it to the card, create Beast Mode 2 using Beast Mode 1, save the Beast Mode, then save the card again, and now you can use Beast Mode 2.