Trying to get the differences between this data , hopefully in grafana

Hello! I am trying to find out how to use influx for queries that I do in mysql typically but I am not certain of the limitations exactly even after reading through a lot of the documentation.

I have data like this (uploaded pictures) and Ideally I want to be able to get the time different between

Created - > Response

Created-> Closed

The way our system worked is if it is closed it will send the response we have stored. My problem is this is not all in one place as we have it storing each differently I am not sure if we can change but if somebody has ideas for how I might blend this data together that would be great! I know how I would do it on mysql but I can’t seem to do the same functions here.

Thank you for any help you can give me.

1 Like