How to update column-list, without using "Reset to defaults" (New columns not listed in Dashboard > "Visualization options" > "Visible columns")

Get Help
1

Hi all

I can't find newly created columns in the "Visualization options" > "Columns" > "Visible columns".

image

Are there any way I can get a new column added to my existing question (within the dashboard), without having to press the "Reset to defaults"?

As is, I'm only aware of the option to press "Reset to defaults", but that's a pain, if multiple things are changed in the given table (formattings, naming, formatting, order and so on).

image
image1806×742 141 KB

Scenario:

  • Create a dashboard
  • Create a question
  • Add the question to the dashboard
  • Customize a few columns in the dashboard, and save it
  • Add a new column to the question and save it.
  • Notice that the newly added column are not shown in the "Visualization options" > "Columns" > "Visible columns"

My question sounds (just a bit) like this, also mentioned here - But I'm not 100% sure?

I have tried a browser with fresh cache and so on, with no luck. By pressing the "Reset to defaults", the newly added (and missing) column shows up.

Known workaround no. 1:

  • Navigate to the question, from the dasboard
  • Save it as a new question
  • Add it to the same dashboard
  • Remove the old question
  • Find the new column in the "Visible column" view

Metabase Information:

You're on version v0.40.5
Built on 2021-09-21
2

Hi @exetico
There's really no easy workaround beside what you have done already.
It is caused by this: https://github.com/metabase/metabase/pull/13968

3

That's sad news! But thank you, for the issue-reference.

It would be great to have a "Add/pull missing columns", or simular button (below the columns).

4

@exetico I'm going to create an issue about this, since I think we have other problems too. Will return with a reference link.

5

Hi there ! Sorry to dig up an old topic, but I couldn't find the issue created about this, and I'm facing the same issue as exetico.
Is there something open? And/or a workaround?
Thanks :slight_smile:
Clémence

6

@clemencegeffraymoka - the original issue appears to have been fixed. What version are you using?

7

Hi @zoltan, I'm using the latest one : 1.46.7
But still when I want to modify a card based on a question, the new columns added to that question didn't appear in the column list. I had to remove the card and add it back again to see the new columns, but I had to reapply manually the formatting that was done.

8

@clemencegeffraymoka - I couldn't reproduce the error on my end but I'd be happy to. Any chance of demonstrating it using the Sample Database?

9

Hi @zoltan, sorry I couldn't reproduce with the Sample Database, and it took me less time and energy to recreate the card from scratch. I guess it was due to some formatting on the specific card, because same question was used somewhere else in the dash and I saw the new columns there.