I want to add “funnel” visualization to my dashboard. I tested the query and visualization under SQL Runner environment, but as I attempted to add this to my dashboard(or explore environment), the visualization here seems completely “broken”.
I have confirmed that these two are the EXACT same queries and visualization setup.
Can somebody help me explain what went wrong?
So the docs say the following:
So if you have the measures instead of the dimensions in explore, that should work
For SQL Runner - technically there are no dimensions or measures selected there as it is a pure SQL, so maybe your results were considered measures there?
btw, I have tried using measures for the four values I wanted :(
I think for the funnel visualisation to work, you need to use measures