Advanced Chart Options
Demonstrated Features
- Chart
- URL Parameters
- Shortcode Parameters
Required Skills
- Basic SQL Queries
Required License
- Premium
Custom options were used to change the chart's background color and axis (docs).
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