Resolving Table Headings and Converting Durationnano to Seconds
TLDR Hannes asked how to change table headings and convert durationnano to seconds, Srikanth recommended using a formula for conversion and "Legend" for formatting. Later Hannes clarified the issue was resolved.
Srikanth
Wed, 06 Sep 2023 08:00:03 UTC> 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.
Hannes
Wed, 06 Sep 2023 10:40:49 UTCTrying to use a formula like `B/1000000` results in ```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```
Hannes
Wed, 06 Sep 2023 10:42:19 UTCI'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?
Srikanth
Wed, 06 Sep 2023 10:42:57 UTCJust use `{{messaging.sidekiq.job_class}}`
Srikanth
Wed, 06 Sep 2023 10:43:39 UTCSorry I don’t think I understand it properly. What heading do you want to see?
Srikanth
Wed, 06 Sep 2023 10:44:08 UTC> Trying to use a formula like `B/1000000` results in Can you share the full API response?
Hannes
Wed, 06 Sep 2023 10:45:59 UTC```{"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 \u003e= '1693993539000000000' AND timestamp \u003c= '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"}```
Hannes
Wed, 06 Sep 2023 10:47:14 UTCI'll start a new thread for the heading one :slightly_smiling_face:
Hannes
Wed, 06 Sep 2023 10:57:44 UTCheading issue resolved :slightly_smiling_face:
SigNoz Community
Indexed 1060 threads
Built with ClickHouse as datastore, SigNoz is an open-source APM to help you find issues in your deployed applications & solve them quickly | Knowledge Base powered by Struct.AI
View in App
Hannes
Tue, 05 Sep 2023 19:04:43 UTCIs there a simple way to change the headings in a table? Another question, how can I convert durationnano into seconds?