Interactive Chart Selection
Demonstrated Features
- Chart
Required Skills
- Basic SQL Queries
Required License
- Premium
Your users can interactively change the settings of the chart by clicking the settings icon above it.
This chart also accepts URL (docs) and shortcode (docs) parameters. The chart result can be changed by passing the parameter dname to the URL, as shown in the query below. This link, for example, displays the chart results for the sales department.
The chart query can be edited in the App Manager (docs).
select dname as "Department"
, sum(ifnull(sal,0)) as "Total Salary"
, avg(ifnull(sal,0)) as "Average Salary"
from emp right join dept on emp.deptno = dept.deptno
where (dname like httpGet['dname'] or httpGet['dname'] is null)
and (dname like shortCodeParam['dname'] or shortCodeParam['dname'] is null)
group by dname
order by dname