I have a dataset that is pulling ALL data in our ecosystem. We are embedding a dashboard for anonymous users and utilizing tags such that the customer pulling up the dashboard only gets access to their data. The issue is I have some on visualization filters (where I added the filter to the sheet) and I want the options displayed in the drop down to be only applicable to the customer’s options. Right now the options available for our entire ecosystem.
I know that if I add a control to the top for the customer ID or some equivalent, I can use this control to filter the values in the drop down filter (select related values only) but I do not want to add controls on the dashboard.
Is there a way to pass the parameter value / tag value to the dataset custom query so that I am 100% sure the data being pulled for the dashboard is tied to the customer itself? Let me know if I am not making any sense!