当我试图在grafana中将clickhouse中的数据视为一个图形时…我尝试了很多查询处理，但无法在grafana上获得点…我的表看起来像

CREATE TABLE m_psutilinfo (timestamp String, namespace String, data Float, unit String, plugin_running_on String, version UInt64, last_advertised_time String) ENGINE = Kafka('10.224.54.99:9092', 'psutilout', 'group3', 'JSONEachRow');

CREATE TABLE m_psutilinfo_t (timestamp DateTime,namespace String,data Float,unit String,plugin_running_on String,version UInt64,last_advertised_time String,DAY Date)ENGINE = MergeTree PARTITION BY DAY ORDER BY (DAY, timestamp) SETTINGS index_granularity = 8192;

CREATE MATERIALIZED VIEW m_psutilinfo_view TO m_psutilinfo_t AS SELECT toDateTime(substring(timestamp, 1, 19)) AS timestamp, namespace, data, unit, plugin_running_on, version, last_advertised_time, toDate(timestamp) AS DAY FROM m_psutilinfo;

这些是我在clickhouse中创建的表…我在grafana中的查询应该是什么来获取图形数据？

SELECT
    $timeSeries as t,
    count()
FROM $table
WHERE $timeFilter
GROUP BY t
ORDER BY t

我用了tabix，但想用grafana