Hi. How do I use a ClickHouse query in a Value pan...
# support
r
Hi. How do I use a ClickHouse query in a Value panel on a dashboard? Does the column need a special name? e.g.
select 1;
displays
0
s
Hi Richard, The value type ClickHouse syntax is a little convoluted right now. There should be a timestamp column even though it won't be used and the name of the result column should be
value
. Example
Copy code
SELECT 1 as value, now() as ts;