As far as I can see , for each visual containing a currency field, I need to define the currency symbol ($, €…) using the Format for the field. Is it possible to define a system currency in Quick Sight and have this code applying to all currency fields in the dashboard?
One reason for my question: we want to use the same generic dashboard for different customers and they use different currencies. If we could define the currency symbol as a variable, then the visuals would not be customer specific.
Hello @ptap !
To my knowledge there is no way make the currency selection dynamic according to a user.
That being said you could try to recreate that in your dataset. You could create a field in your dataset that has the correct currency symbol and have it according to a row with the correct region. For example:
Country|Sales|Currency
USA, 500, $
Japan, 600, ¥
France, 400, €
etc…
Then in quicksight you could create a field to concat the sales and currency fields. Then if you are applying RLS for your client they should only see their data. Note, if you do the concat step in Quick Sight you’ll need to use toString on your sales/integer field.
Or, you could create fields that are formatted for each of the currency types, and with dynamic default populate a parameter that would determine which field should be used:
ifelse(${param} = 'Japan', {yen}, ${param} = 'USA', {dollar}, ${param} = 'UK', {pound}, etc...)
1 Like
Thanks @duncan , I will look into your suggestions