First dataset: Account
id, name, value
1, name1, value1
Second dataset: Account History (can think of this one as a snapshot of account table every day, for example based on sample data account id:1’s name changed from name1 to name2 at day2)
id, name, value, day
1, name1, value1, day1
1, name2, value1, day2
My question is, I have a dashboard where user selects an account and I show details of the selected account. I want to use both Account and Account History in this dashboard. I want users to select by account name (since id is just a number) but in the background I want to use account id as filter since account name is something can change.
By the way I know I can join datasets and solve this problem but I have many other datasets that has account-id field but not account name, so I do not want to join all of them with Account.
Also I created a cascading filter with parameter but could not make it work.
Account id control is working with a parameter and I used this parameter to filter Account History dataset but it does not work, I mean it works but I have to manually select Account Id from the second control, I want it to work automatically, ideally Account Id filter should be invisible.
Were you able to resolve this or was @ErikG’s comment helpful? If so could you either post your solution or mark one of the comments above as a solution to help the community?
