result field in table panel of dashboard always named as count

[ankitnayan]

and if there is no result column, the table automatically adds a column called result filled with 0

[srikanthccv]

@vikrantgupta25 The legend format for the aggregation column is not respected. Please try this query and check.

SELECT now() as ts, 
stringTagMap['service.name'] AS `service.name`, 
toFloat64(avg(durationNano))/1000/1000 AS value
FROM signoz_traces.distributed_signoz_index_v2  
WHERE timestamp BETWEEN {{.start_datetime}} AND {{.end_datetime}}
GROUP BY (`service.name`, ts) order by (`service.name`, ts) ASC;

and if there is no result column, the table automatically adds a column called result filled with 0

@ankitnayan, the table column is usually viz for aggregation so it expects at least one aggregation result column. If there is no aggregation but just a plain list of values to read from somewhere, it should go in list panel type.

[ankitnayan]

It was this query

select traceID, round(sumIf(durationNano, stringTagMap['db.statement'] ilike '%test_api%')/1000/1000, 1) as db_time_ms, 
round(sumIf(durationNano, httpRoute ilike '%test_orders%')/1000/1000, 1) as route_time_ms
FROM signoz_traces.distributed_signoz_index_v2
WHERE (timestamp BETWEEN {{.start_datetime}} AND {{.end_datetime}})
AND (serviceName = 'sample-service')
GROUP BY traceID
HAVING route_time_ms != 0
ORDER BY db_time_ms DESC
LIMIT 10

[srikanthccv]

This is the case of supporting multiple aggregations. Here the db_time_ms and route_time_ms are interpreted as labels so the result by default is 0.

[ankitnayan]

changing one of them to result still make the result column as count column. I mean there won't be any column with name result and there will always be a column named count

[vikrantgupta25]

merged the frontend changes for the above issue