- Access exclusive content
- Connect with peers
- Share your expertise
- Find support resources
01-22-2025 09:55 PM
I need query about status of incidents. I have to all status count in same query. For example in april have 25 auto-resolved, 20 FP, 20 TP but I dont know how can i count in same query. Does anyone have any ideas on this topic?
01-27-2025 04:12 AM
Hi you could try this (amending timeframe to suit your needs):
config timeframe = 1mo
| dataset = incidents
| comp count() by status
01-27-2025 04:23 AM
Hi thanks for answer but I guess you misunderstand me. Actually I need it like below chart.For example the long one "auto resolve",the small one "fp.
01-27-2025 04:55 AM
You could modify the query to something like this:
config timeframe = 1mo
| dataset = incidents
| comp count() by status
| view graph type = column subtype = grouped xaxis = status yaxis = count_1
01-27-2025 05:15 AM
Thanks for answer. But This is not what I want.In the below I shared graph. Month 1st 178 FP,16 security testing ....I want to show same graph
Click Accept as Solution to acknowledge that the answer to your question has been provided.
The button appears next to the replies on topics you’ve started. The member who gave the solution and all future visitors to this topic will appreciate it!
These simple actions take just seconds of your time, but go a long way in showing appreciation for community members and the LIVEcommunity as a whole!
The LIVEcommunity thanks you for your participation!