Hello everyone,
I'm experiencing an issue with a dashboard in Metabase (v0.49.13) and would appreciate any insights or solutions you might have.
Dashboard Setup:
- Dashboard Structure:
- The dashboard contains 5 tabs:
- Report (Weekly)
- Report
- Points of Interest
- Events
- Versions
- The dashboard contains 5 tabs:
- Common Filter:
- All tabs share a single filter named "Device".
- Data Models and Tables:
- Tables Used:
- Event table
- Device table
- Data Models Used:
- Report Data Model (built from the Event table)
- Version Data Model (also built from the Event table)
- Tables Used:
Details:
- Event Table:
- Contains a column named
device_id
.
- Contains a column named
- Device Table:
- Contains an
id
column, which is the primary key. - The
id
in the Device table corresponds todevice_id
in the Event table.
- Contains an
- Data Model Metadata:
- In both data models,
device_id
is set as a foreign key pointing to the Device table.
- In both data models,
- Filter Configuration:
- The "Device" filter is linked to the
device_id
column. - Intended to display device names alongside their IDs.
- The "Device" filter is linked to the
Issue Description:
- When I first open the dashboard and go to the Report (Weekly) tab, the "Device" filter dropdown only displays device IDs (e.g.,
123
,456
), without the associated device names. - If I navigate to the Versions tab and then return to the Report (Weekly) tab, the "Device" filter starts displaying device names along with their IDs (e.g.,
Device A (123)
,Device B (456)
). - This issue seems to occur only on the initial load of the dashboard.
What I've Tried:
- Verified that
device_id
is correctly set as a foreign key in both data models. - Confirmed that the filter is properly linked to the
device_id
column. - Checked for any discrepancies in the setup between the Report (Weekly) and Versions tabs.
Questions:
- Why does the "Device" filter only show IDs upon the initial load and not the device names?
- Why does navigating to the Versions tab and back resolve the issue temporarily?
- How can I make the filter display device names consistently without needing to switch tabs?
Additional Information:
- Metabase Version: v0.49.13
- Both data models are based on the Event table and have the foreign key relationship to the Device table defined in their metadata.
- The issue affects all tabs that use the Report Data Model but not the tab that uses the Version Data Model.
Any insights or suggestions on how to resolve this issue would be greatly appreciated!
Thank you in advance for your help.