We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
I'm working on an alert rule to check a volume over time. In a dashboard, when I apply my query, I get this result
But when I use the same query in an alert, I get this result.
You can see that the timestamp is not interpreted correctly and the series names are repeating.
I applied the query using the official clickhouse plugin (panel and alert rule), and I didn't have any problem.
the request is : `SELECT $timeSeries as t, page_domain_name, sum(1) as ad_start FROM $table
WHERE $timeFilter AND event in ( 'ad_start') AND toDate($dateTimeCol) < toDate($to) GROUP BY t, page_domain_name `
And the Generated SQL is: `SELECT (intDiv(toUInt32(timestamp), 86400) * 86400) * 1000 as t, page_domain_name, sum(1) as ad_start FROM viously.event_ad
WHERE timestamp >= toDateTime(1684508508) AND timestamp <= toDateTime(1684767708) AND event in ( 'ad_start') GROUP BY t, group`
The text was updated successfully, but these errors were encountered:
According to #478 (comment) it looks like grafana related issue, doesn't reproduce on grafana/grafana:main (10.1.x) docker image grafana/grafana#69289
grafana/grafana:main
Sorry, something went wrong.
Slach
No branches or pull requests
I'm working on an alert rule to check a volume over time.
In a dashboard, when I apply my query, I get this result
But when I use the same query in an alert, I get this result.
You can see that the timestamp is not interpreted correctly and the series names are repeating.
I applied the query using the official clickhouse plugin (panel and alert rule), and I didn't have any problem.
the request is :
`SELECT
$timeSeries as t,
page_domain_name,
sum(1) as ad_start
FROM $table
WHERE $timeFilter
AND event in ( 'ad_start')
AND toDate($dateTimeCol) < toDate($to)
GROUP BY t, page_domain_name
`
And the Generated SQL is:
`SELECT
(intDiv(toUInt32(timestamp), 86400) * 86400) * 1000 as t,
page_domain_name,
sum(1) as ad_start
FROM viously.event_ad
WHERE timestamp >= toDateTime(1684508508) AND timestamp <= toDateTime(1684767708)
AND event in ( 'ad_start')
GROUP BY t, group`
The text was updated successfully, but these errors were encountered: