Good morning community!

We would like to make a report that contains the number of tickets that were open+on hold for every single day from one date to another. 

For example, now we can have the report for every single day but separate, so if we need to make it from 2019 until today, we need to do it manually, is there a way to make one report with all these amounts together?

This is the report that we have now:

So there we get for example, if I execute that query with the dates from 2019 until today, we get the information that we have for example 100 open tickets and 90 on hold, so 190 are tickets that are not resolved at the moment. But then I need to change the date from 2019 until yesterday to get what tickets were not resolved at that moment. What we would like is to put range of dates, and get this amount from every single day separate, like if we execute all of these querys but together and all that one with one table as a result that contains this amount.

Hope this information is enough to understand this issue.

Best regards and thanks!!

Lucas.