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!