Allan Li
11/01/2022, 5:20 PMSrikanth Chekuri
11/01/2022, 5:21 PM{{SIGNOZ_START_TIME}}
and {{SIGNOZ_END_TIME}}
.Allan Li
11/01/2022, 5:22 PMSrikanth Chekuri
11/01/2022, 5:23 PMAllan Li
11/01/2022, 5:23 PMSrikanth Chekuri
11/01/2022, 5:25 PMcan I display a string in the value panel?What’s the use case? Where do you get the string from?
Allan Li
11/01/2022, 5:27 PMError: API responded with 400 - template: clickhouse-query:13: function "SIGNOZ_START_TIME" not defined
Srikanth Chekuri
11/01/2022, 5:46 PMAllan Li
11/01/2022, 6:00 PMWHERE
date_exec >= {{SIGNOZ_START_TIME}}
AND date_exec <= {{SIGNOZ_END_TIME}}
Srikanth Chekuri
11/01/2022, 6:01 PM{{.SIGNOZ_START_TIME}}
and {{.SIGNOZ_END_TIME}}
basically the go templating format.Allan Li
11/01/2022, 6:09 PMError: API responded with 400 - encountered multiple errors: error in query-A: code: 62, message: Syntax error: failed at position 359 ('<') (line 13, col 22): <no value> AND date_exec <= <no value>. Expected one of: ANY, ALL, BETWEEN expression, string concatenation expression, list, delimited by operator of variable arity, additive expression, list, delimited by binary operators, INTERVAL operator expression, INTERVAL, TIMESTAMP operator expression, TIMESTAMP, DATE operator expression, DATE, multiplicative expression, unary expression...
Srikanth Chekuri
11/01/2022, 6:19 PMAllan Li
11/01/2022, 6:20 PMSELECT
toStartOfMinute(date_exec) AS time,
avg(duration)
FROM
(
SELECT
toTimeZone(timestamp, 'America/Toronto') AS date_exec,
ROUND(durationNano / 1000000, 2) AS duration,
serviceName AS serviceName,
tagMap['graphql.operation.name'] AS op_name
FROM signoz_traces.durationSort ds
WHERE
date_exec >= {{.SIGNOZ_START_TIME}}
AND date_exec <= {{.SIGNOZ_END_TIME}}
AND name = 'graphql.execute'
AND op_name != ''
AND op_name != 'IntrospectionQuery'
AND serviceName = 'stage'
)
GROUP BY
time
ORDER BY time ASC WITH FILL STEP 60
Srikanth Chekuri
11/01/2022, 6:30 PMSIGNOZ_START_TIME
and SIGNOZ_END_TIME
?Allan Li
11/01/2022, 6:32 PMSrikanth Chekuri
11/01/2022, 6:34 PMAllan Li
11/01/2022, 6:34 PMSrikanth Chekuri
11/01/2022, 6:53 PMAllan Li
11/01/2022, 7:19 PMAnkit Nayan
11/02/2022, 3:46 AMAllan Li
11/02/2022, 3:08 PMAnkit Nayan
11/02/2022, 5:01 PMSrikanth Chekuri
11/02/2022, 5:11 PMAllan Li
11/02/2022, 5:26 PM