Cumulative variable

Hi, I’m new to Zammad and Grafana, and my boss has requested me to create some charts. I followed the official documentation on how to implement Zammad with Elasticsearch in Grafana to set it up. I’m currently working on a time chart and I need to set an acumulative variable that represents the quantity of tickets that still open. I got a Gauge chart that represents the total but they want me to make it in a time series chart.
An example could be: day 1 there are 3 open tickets and day 2 were creted 2 tickets and 1 was closed so we represent 4 tickets, the 3 of yesterday add 1 of today in a time chart so we can see if we are getting to much remaining tickets.

I apologize for my poor English, and thank you for taking the time to read this.