Hello guys! I am facing a problem and I don't know how to solve. I have a dashboard that is embedded in my react application with Laravel. I have a filter on the dashboard called USER_ID, it's hidden for the user but the value is used in graphics and queries. My application is passing the user_id to the dashboard and it's working. But I want a second filter called "Patients" based on the USER_ID that is the id of the logged in user. How can I create this filter, based on user_id?
1 Like
The answer appears to be yes however, I too am struggling to get this working on my dashboard (I'm using regional spatial data (i. e. Company -> County -> Facility) and trying to limit the selections as I move through each step.
I found this below but not having much luck yet:
https://www.metabase.com/docs/latest/troubleshooting-guide/linked-filters
"Root cause: In order for a linked filter widget to display the correct subset of values as a dropdown, an explicit foreign key definition must be set up—linking the filters does not by itself tell Metabase about the relationship."
I believe my issue is this but I don't know how to resolve as my underlying data is a series of joined data (no FK) so I'm still trying to resolve this as well.
I read this article too but unfortunately I still haven't been able to make it work. I think I will have to make the filters outside the dashboard and let the application control the filters, passing the parameters to metabase.