Hi
I currently has 2 tables with Revenue and Value. Both the tables contain different dimensions
Table1:
Region,
City,
Date,
Revenue
Table2:
Region,
City,
Date,
Signal Type
Value
I'm trying to either concatenate or use link table.
When i try creating a combo chart with Primary axis as Revenue and Secondary as Value based on Date, it works fine with also Region selected
The issue is if user selects from Signal Type value dimension, Revenue disappears and only displays Value. This is how the data is as we do not have signal type for Revenue.
Any thoughts to still display both Revenue and Value on Signal Type selection
Note: Layover the charts on top do not suffice my requirement.
Attaching sample data and app
