SELECT
UNIX_TIMESTAMP(time) as time,
convert(action,CHAR(20)) as metric ,
SUM(hits_count) as “Action Count”
FROM scm_host_op_sp_service_action_channel_errorcode_wise_tps_hourly
WHERE
$__timeFilter(time)
Group by time,action
Also make sure the fornat of the query is Time Series and not Table.
Also check that you do not have some Transformation that might having an effect on visualization