I have a requirement like there are two tables from same DB and same schema.
From the dashboard, through a filter I should be able to switch the data source, i.e., from which table the data has to be fetched for the dashboard.
In other words,the same dashboard should be able to populate data from two different tables from same schema and same DB, based on a filter.
Any help regarding this will be greatly appreciated.
you can use any data to demonstrate as, my data is confidential and could not be given here.
(P.S: it can be a LIVE connection)