MAD Monica Maldonado

Could you please share examples on how to use it?

Hi

Is there a way to count only tickets moved not a new group but solved in the previous group?

Hi there, 

I need to create an attribute that shows me something like:

- x requester emails  created [0-10] tickets 

- x requester emails created [10-20] tickets

....

any idea?

 i have tried a simple one like 

if (value(End-user submitted tickets)
>50) then ">50"
else "<=50"
Endif

but it does not provide proper results. 

Any idea?

Thanks very much!

Hey @... thanks very much. 

I am unable to see how the metric is built. Is including chatbot messages?

I am missing filters in this data set so I cant know how many unsolved specific kind of tickets i had in a past date as I dont have for instance the ticket form filter. This is a big missing for us.

Thanks bill cicchetti for the time and effort. 

Thanks for the answer Marco.

To be honest i am still not convinced. so i can see the created tickets at any point, but when talking about solved tickets in a past date, this number is not stable as it changes due to reopened tickets right? so if i want to see how many tickets outstanding i had on the 31/12/2021 i am not gonna get the same number I had if i was checking on the 31st dec. 

I am only finding numbers for live outstanding but nothing historical. Am I wrong?

Hi Mark Leci 

Did you get your answer?

I am running this query and i get 40k created tickets and 50k solved ones in one day, so I am assuming (maybe wrongly) that the solved ones are not only those created in that day. Am i wrong?

I am actually looking for the data that answer me how many unsolved Tickets i got in a specific day, and these calculations are the ones i need. So if i know how many tickets were created from the beggining until that specific date and how many tickets were solved from the beggining unitl that date i ll get the outstanding number of tickets on that specific date. 

So far, i have been unable to get that right number.

Let me know if you got any answer on your question please.

Thanks

Would it count the tickets that were reopened later? so the reopened count for them is bigger than 1?