any way to have multiple counts within same xql query

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

any way to have multiple counts within same xql query

L1 Bithead

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?

4 REPLIES 4

L1 Bithead

Hi you could try this (amending timeframe to suit your needs):

 

config timeframe = 1mo 
| dataset = incidents
| comp count() by status

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.

 

kadirerol_0-1737980603946.png

 

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

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

 

kadirerol_0-1737983437089.png

 

kadirerol_2-1737983692355.png

 

 

 

  • 243 Views
  • 4 replies
  • 0 Likes
Like what you see?

Show your appreciation!

Click Like if a post is helpful to you or if you just want to show your support.

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!