Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Create charts from SQL query

I want to create a chart from a join sql query between 2 tables in superset.

for example , I go to SQL Lab and execute this query :

select film, count("film") from rental r, payment p where r.rental_id=p.rental_id group by("film") order by count("film") limit 20;

This returns me a result but how to insert in a chart?

How to create chart from SQL query ?

like image 433
Beto Avatar asked Dec 13 '22 10:12

Beto


1 Answers

In order to visualize the results from a query executed in SQL Lab, you first need to click on Explore (underneath the Results tab).
Once you are in exploration mode, you can change the "Visualization Type", under "Datasource & Chart Type".

like image 162
David Tobiano Avatar answered Feb 10 '23 01:02

David Tobiano