Hi all I'm struggling to make my chart how I want it. Basically what I currently have, is a graph with a lot of logs received from certain services. And that from the past 3 months. - I don't understand why my months are ordered like this: 2022 December, 2023 February, 2023 January Where January should be in the middle. - Aside from this, my main struggle is to filter the top services with the highes
t logs. These are a lot higher than the other ones. So I'll have to make a 2nd graph with the smaller ones. How can I filter the the top (say 4) out? (AND srv!=*** is not the proper way to do it in this case) |dbxquery query="select to_char(received_ts,'YYYY Month') as Month,srv,sum(log_Count) as Total_Log_Count from gmssp.esm.esm_audit_day where client_id = **** AND received_ts>= DATE_TRUNC('month', current_date) - '3 month'::interval AND received_ts< DATE_TRUNC('month', current_date) AND SRV!='ignor' AND SRV!='UNK' group by srv, month" connection="******" | chart max(total_log_count) by srv month Thanks a lot for your help!
... View more
