Currency filter on Dashboard

Hello,

In my dataset, I have created new columns to get specific information in Euro, Dollar or Japanese Yen

I would like to know if it's possible to build a filter card, listing all possible currencies we have in our Data set: Euro, Dollar, Japanese Yen

When the user click on it, all cards should be impacted by this selection. Getting all sales in the selected currency.

Do you know if it' possible of if there is another way to build this kind of Dashboard.

Otherwise, I'll have to duplicate this dashboard and select the currency manually

Many thanks,

Julien

Comments

  • jaeW_at_Onyx
    jaeW_at_Onyx Budapest / Portland, OR 🟤

    @user047019 , to be able to select your currency from a filter, you'd have to structure your data so that you have one row per transaction PER CURRENCY TYPE. Then you can just add a filter for "currency type"


    In other words, instead of having Amount_dollar, Amount_Yet, Amout_Euro, you'd just have one column, Amount, and another column "currency type"


    side note, it'd be really nice if you updated your handle! so we can at_mention you more easily

  • user047019
    user047019 Paris ⚪️

    hi @jaeW_at_Onyx ,

    Thanks for that quick answer. I was thinking about that solution but I would have to multiply all the existing line by the number of currency I want to track . It's a cumbersome solution.

    But thanks anyway.

  • GrantSmith
    GrantSmith Indiana 🔴

    Hi @user047019

    What you'd need to do is "stack" your data into a single dataset where you'd have the amounts calculated and then depending on the filter you have selected it will then select the appropriate records.


    Date | Currency | Amount

    1/1/2021 | ¥ | 10000

    1/2/2021 | ¥ | 5000

    1/3/2021 | ¥ | 250000

    1/1/2021 | $ | 10

    1/2/2021 | $| 50

    1/3/2021 | $ | 250

    1/1/2021 | € | 7

    1/2/2021 | € | 40

    1/3/2021 | € | 200


    You'll need to be aware that if no currency is selected then all of the currencies will be used to calculate everything. You could have a separate card atop your dashboard to display a text message if you detect more than one currency in your dashboard filters.

  • We are working on an approach in product to swap variables in this manner. Not positive in timing. But stacking is a good option for now. You could probably do this virtually with dataset views as well if you did not want an extra ETL step.

  • jaeW_at_Onyx
    jaeW_at_Onyx Budapest / Portland, OR 🟤

    @user047019 , it's a common design pattern in Domo for features like this.

    CROSS apply is relatively easy in Magic to do a CROSS APPLY just add a fixed constant of 1 on the left and right side of the dataset and JOIN on 1 = 1

    https://youtu.be/Xb4QgKYgaqg?t=295

  • user047019
    user047019 Paris ⚪️

    Thanks all