Is there a simple way to change the headings in a ...
# support
h
Is there a simple way to change the headings in a table? Another question, how can I convert durationnano into seconds?
s
Is there a simple way to change the headings in a table
Use the Legend formatting option
how can I convert durationnano into seconds
Cumbersome but you can use formula.
h
Trying to use a formula like
B/1000000
results in
Copy code
API responded with 400 - encountered multiple errors: error in query-F1: code: 62, message: Syntax error: failed at position 50 ('.'): .sidekiq.job_class, B.ts as ts, B.value / 1000000 as value FROM (SELECT now() as ts, stringTagMap['messaging.sidekiq.job_class'] as `messaging.sidekiq.job_class. Expected one of: token, Comma, FROM, PREWHERE, WHERE, GROUP BY, WITH, HAVING, WINDOW, ORDER BY, LIMIT, OFFSET, SETTINGS, UNION, EXCEPT, INTERSECT, INTO OUTFILE, FORMAT, end of query
I've tried
{{tag_messaging.sidekiq.job_class}}
,
{{sidekiq.job_class}}
&
{{job_class}}
none of which resulted in the class name to be used. What should I be using?
s
Just use
{{messaging.sidekiq.job_class}}
Sorry I don’t think I understand it properly. What heading do you want to see?
Trying to use a formula like
B/1000000
results in
Can you share the full API response?
h
Copy code
{
  "status": "error",
  "data": {
    "F1": "SELECT B.messaging.sidekiq.job_class as messaging.sidekiq.job_class, B.ts as ts, B.value / 1000000 as value FROM (SELECT now() as ts, stringTagMap['messaging.sidekiq.job_class'] as `messaging.sidekiq.job_class`, quantile(0.99)(durationNano) as value from signoz_traces.distributed_signoz_index_v2 where (timestamp >= '1693993539000000000' AND timestamp <= '1693997100000000000') AND has(stringTagMap, 'messaging.sidekiq.job_class') group by `messaging.sidekiq.job_class` LIMIT 100) as B "
  },
  "errorType": "bad_data",
  "error": "encountered multiple errors: error in query-F1: code: 62, message: Syntax error: failed at position 50 ('.'): .sidekiq.job_class, B.ts as ts, B.value / 1000000 as value FROM (SELECT now() as ts, stringTagMap['messaging.sidekiq.job_class'] as `messaging.sidekiq.job_class. Expected one of: token, Comma, FROM, PREWHERE, WHERE, GROUP BY, WITH, HAVING, WINDOW, ORDER BY, LIMIT, OFFSET, SETTINGS, UNION, EXCEPT, INTERSECT, INTO OUTFILE, FORMAT, end of query"
}
I'll start a new thread for the heading one 🙂
heading issue resolved 🙂