Hello! Ever since the update, I am unable to edit visualizations from a dashboard as I get an error message that no data is available (see screenshot below). This is preventing me from combining series on the dashboard. Guidance would be appreciated, thanks!
Is there data if you edit it as a question (click the card title)?
There is. However, this method does not let me combine series on my dashboard.
Have you tried:
- deleting and re-adding the card
- deleting and re-adding the data sources in the left-hand sidebar
- rebuilt the question
It seems like it's forgotten where the source columns came from. There should be a list of columns under the question name in the left-hand sidebar, with the columns that are loaded into the graph highlighted in blue.
I've seen this happen if I rewrote the question to use a new source table and all of the output columns changed. I might have triggered it by modifying table schema as well, I don't remember.
Also, the visualization editor does not apply filters, does your database engine reject the query or return 0 rows without them?
Finally, what Metabase version are you running? Can you post the diagnostic information?
I see, thanks so much for the thorough response. Yes, the issue is that this particular dashboard relies on filters, and the queries return no results without them. What's the recommendation to edit visualizations that require filters? Thanks!!
I just did this 5 minutes ago...
Edit the question (by clicking on the card title), make your changes, and save the question. You can apply some temporary filters to the question if you need to; remove them from the Editor tab before saving. Check if the card updates.
If not, then edit the dashboard. Hover over the card and select 'Replace' from the pop-up menu. Select the Questions tab in the dialog and the current question will highlight; click it again so you replace it with itself. The card will try to reload, but while it's doing that, click each filter and reattach them to the card. Save the dashboard and the card should have applied your changes and load with the selected filters.
If it glitches, try reloading the page.
If possible, put some backstop filters in the question so that it can run without any dashboard filters applied. For my problem case question, it's unlikely I'll ever set that dashboard to categorize 20 million rows by country...
Thanks so much!!