Time aggregating result of redis query

I have a redis query that looks like this:

I would like to create a time series that aggregates every 15 seconds number of jobs in active and completed states

After applying these transformations

I am able to get to this:

From here how do I reduce this further to aggregate by time windows like 15s, 1m etc.

I want number of jobs in active and completed states

Hi @shaunakv1,

Welcome to the :grafana: community support forums !!

We are excited that you joined our OSS community. Please read about some of the FAQs in the community :slight_smile:

Can you please maybe draw a raw/rough sketch/image as how exactly you want your data to look like?