Sum of Count of timegroup SQL

Grafana MySQL
1

Hi all,
I am facing currently the issue, that I would have a Microsoft SQL table with

creation_time | closing_time | ID | …

I would like to get a delta of the COUNT of IDs per day. e.g. 23.10.23 -3, 24.10.23 +2 that I can create a bar chart connected with my currenty chart looking like this:

image
image897×179 20.9 KB

What I did so far:

SELECT 
  $__timeGroup(creation_time , '1d') as time_e,
  $__timeGroup(closing_time , '1d') as time_s,
  sum(COUNT(creation_time )- COUNT(closing_time )) as value1
 from 
      Database1
  Group BY ID, $__timeGroup(creation_time , '1d'), $__timeGroup(closing_time , '1d')

Someone having an idea, how to solve my case?

Thank you in advance.