query to compare Last year month ticket count Vs. This year month ticket count

[Jessica Munoz Valerio]

I have been reading articles about queries and although are very useful. I do not seem to find a way to pull examples of this month's count of tickets and last year's same month's count of tickets. Similar to creating a comparison Last year vs. This year. 

Any ideas?

[Trudy Claspill]

Hello @Jessica Munoz Valerio 

What is the criteria for saying that a ticket is included in a given month's count? Is that based on created date, resolution date, last updated date, ...?

For example if you want to get the list of issues created in the current month you can use

created >= startOfMonth() and created =< endOfMonth()

And to get the same for this month last year you would use:

created >= startOfMonth(-12) and created =< endOfMonth(-12)

If you want just a count, you could use an Automation Rule

1. triggered on a schedule

2. use a Lookup Issues action to get the issues matching the first query

3. store the count of issues returned {{lookupIssues.size}} in a variable

4. use a Lookup Issues action to get the issues matching the second query

5. store the count of issues returned {{lookupIssues.size}} in another variable

6. Send an email with that information to whomever you want.

[Danut M _StonikByte_]

Hi @Jessica Munoz Valerio,

You can have these counts calculated in real-time and displayed on your dashboard by using the Advanced Issue Filter Formula Gadget offered by our Great Gadgets app.

 

All you have to do is to create filters similar with the ones mentioned by @Trudy Claspill above, and to configure the gadget to calculate the count on each of them and to display the results.

You can also extend the gadget to display the year count.

Please note that this app offers many other gadgets that you will find useful. Take a look here to see how many things you can track with this app.

I hope this helps. If you have any questions, please don't hesitate to contact us at support@stonikbyte.com.

Thank you,

Danut Manda