Does the plugin support "Series overrides"? about clickhouse-grafana HOT 6 CLOSED

Hi @fr05t1k
Series Overrides in Grafana allows to change only visual aspects, but not time range. I guess, there is misleading value for alias or regex in example.

If you are looking for time shifting - plz take a look on time range tab

from clickhouse-grafana.

Hi @hagen1778
As I understand Time range allow to shift all metrics. I'm trying to do smth like this

from clickhouse-grafana.

I got it. Seems like he has 2 metrics which are shifted manually

from clickhouse-grafana.

But when I do smth like this

SELECT
    $timeSeries as t,
    count() as users
FROM $table
WHERE 
  registeredDate BETWEEN toDate($from - 3600 * 24 * 30) and toDate($to - 3600 * 24 * 30) and 
  registeredAt BETWEEN toDateTime($from - 3600 * 24 * 30) and toDateTime($to - 3600 * 24 * 30) 
GROUP BY t
ORDER BY t

The data becomes outside of time range.

from clickhouse-grafana.

You will also need to override $timeSeries as following:

SELECT
   (intDiv(toUInt32(registeredAt + 3600 * 24 * 30), 3600) * 3600) * 1000 as t,
    count() as users
....

When Grafana provides $from and $to values, it also adjusts the panel for that timerange. So when you querying the data with timestamps that are outside of Grafana's timerange it would be impossible to display them. So you need to fake those timestamps.

Another option is Grafana's time shifting where it will be done automatically

from clickhouse-grafana.

Yes. That's what I need. Thanks ;)

from clickhouse-grafana.