Nadav Golan

Thank you Salim Cheurfi but this only shows real time update status and i want to know what was the status yesterday per hour and now show me the current real-time status. Is that possible? 

Hi Jahn, Thanks for the support but it is not what i mean.

I want to calculate the total amount of tickets (not only created ones) that we had in each status (not the current status of the ticket), per hour. 

For example:

- a ticket was created at 2pm

- then at 3pm moved to open, 

- then solved at 4pm

So i would like to see:

2pm: New (1), Open (0), Solved (0)

3pm: New (0), Open (1), Solved (0)

4pm: New (0), Open (0), Solved (1)

Could you help me build a recipe to calculate the number of tickets, per ticket status, per hour? For example:

Column A: Time of The day, Column B: ticket status, Column C: count

2PM: New - 5 tickets, Open - 10 tickets, On hold - 2 tickets

3PM: New - 2 tickets, Open 12 tickets, On hold - 2 tickets