Say you would like to show a graphical indication of a KPI movement on a dashboard.
There are couple ways in Cluvio to do this:
1. Use a Number chart with delta indicators:
SELECT 1, SUM(metric) WHERE {timestamp_column=timerange}
UNION ALL
SELECT 2, SUM(metrics) WHERE {timestamp_column=timerange_previous}
ORDER BY 1
This automatically shows a delta up/down as red/green (or reverse with the option "Down is good" - like on the delays above)
The timerange_previous helps in case you want to compare a user-selected timerange period with the same duration before.
The first column in the query (1/2) above is there only to guarantee the sorting as UNION in SQL would not guarantee the order.
2. Use a conditional in SQL query and render unicode characters / emoji
SELECT CASE WHEN COUNT(1) > 5000 THEN '👍' ELSE '👎' END
FROM airports
3. Use a conditional in SQL query and render as image with HTML format
The Number and Table charts support HTML rendering, and this can be used to display images:
SELECT CASE WHEN COUNT(1) > 5000
THEN '<img src="https://www.iconsdb.com/icons/preview/guacamole-green/arrow-145-xxl.png"></img>'
ELSE '<img src="https://www.iconsdb.com/icons/preview/soylent-red/arrow-207-xxl.png"></img>'
END
FROM airports
