Hi,
I have a table panel with multiple SQL queries.
As you see, I can select different query in the drop-down menu.
My question is how can I use a custom “name” to distinguish different queries?
I tried with override “display name” by “Fields returned by query”, after that, every fields have been changed, it’s not the result I need
To use a custom name to distinguish different queries, set an alias for each query in the SQL panel using the AS
keyword. This will allow you to define a unique display name for each query without affecting the field names.
Hi @tglinkhub ,
This is my query
SELECT
YEAR(date) AS “Year”,
MONTH(date) AS “Month”,
technical_name AS “Cluster”,
AVG(available_percentage) AS “Service Availability Percentage”,
CONCAT((ROUND((100 - AVG(available_percentage)), 2)), ‘% (’, SUM(unavailability_minutes), ’ mins)') AS “Service Unavailability”,
SUM(infrastructure_unavailability_minutes) AS “Service Unavailability Local Infrastructure Minutes”
FROM service_availability_monitoring.kfk001AS kfk001
WHERE YEAR(date)=2024
GROUP BY MONTH(date)
ORDER BY MONTH(date) DESC
As you can see, I use “AS” for each every fields, I don’t how can I set a alias for the whole query