search

metabase / metabase

The simplest, fastest way to get business intelligence and analytics to everyone in your company :yum:
https://metabase.com
Other
37.38k stars 4.96k forks source link

Waterfall visualization does not work after removing join & summarize steps and saving the question #36027

Open kamilmielnik opened 7 months ago

kamilmielnik commented 7 months ago

Describe the bug

https://github.com/metabase/metabase/assets/6830683/fd8c17b2-830a-4816-b975-2c147f67605d

To Reproduce

  1. Create a new question: "Orders", summarize "Count" by "Created At: Month"
  2. Save it
  3. Add a join step and join the newly created question to itself on "Created At: Month" <= "Created At: Month"
  4. Add summarize step: "Sum of Count" by " - Created At: Month"
  5. Visualize it
  6. Change visualization type to "Waterfall" - notice that this works
  7. Save the question as a new question
  8. Open GUI editor
  9. Remove last Summarize step
  10. Remove Join step
  11. Visualize it

There is no visualization, even though the question is now in the same state as in step 7, where it could be visualized.

Expected behavior

Waterfall visualization should work

Information about your Metabase installation

master, v47

Severity

P2

kamilmielnik commented 7 months ago

The difference between step 7 and step 11 is that in step 7 visualization_settings will have "graph.metrics": ["count"], and in step 11: "graph.metrics": [].