SQL Runner and Explore return different visualization

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? 

SQL Runner

a24f5475-795f-4d30-957b-022c186fcfd2.png

Explore

e03c43ea-9cda-46cd-b9ad-de6e4cf86cf0.png


 

0 3 323
3 REPLIES 3

Dawid
Participant V

I think for the funnel visualisation to work, you need to use measures

@Dawid but why does the sql runner correctly represent?

btw, I have tried using measures for the four values I wanted 😞

So the docs say the following:

A funnel chart comprises a single set of numbers and a single set of labels which can be oriented:

  • Vertically, using one or more dimensions (labels) and one measure (numbers)
  • Horizontally, using a single row with multiple measures (numbers) and column headers (labels)

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? 

Top Labels in this Space
Top Solution Authors