Dynamically name y-axis from value in the data

[ruairi]

I deal with different clients who deal in different currencies, but I want to deploy the same chart to both clients’ dashboards for scalability. Say it’s a simple column chart where the y-axis is Profit, but I want it to appear as Profit (EUR) and Profit (USD) respectively, without creating two different bespoke charts.

The data is stored like so:

Client 1:

Currency    Amount

EUR             1000

EUR             2000

Client 2:

Currency    Amount

USD             1500

USD             2500

Is it possible to parameterise the values in the axis field to make this possible? Even by joining another view to an explore, maybe? Any help at all would be great. Even being told “no, you can’t do that”. Thanks!

[Dawid]

What do you mean by parametrising the axis? If the value is in the same column from the data source, then I’m guessing you just want to make it explicit in what currency the data is presented, don’t you?

I would like to see some kind of an example of the end effect you want to get