Time series from Start and End Dates in a Table


I am using the infinity datasource plugin to pull data from a 3rd party API (that I have no control over the data format)

The data I get back from the API has a start_time and an end_time field for each record in the response that I have converted to Timestamps.

I want to be able to plot each record as a series in a time series panel between the values for the start and end time (and ultimately be able to aggregate these together to get a count across all records).

However I am not sure if this is possible, even when using transformations to try an manipulate the data. The only success I have had is using a plotly panel and writing some custom JavaScript to process the data but its really horrible.

Has anyone been able to solve this problem or anything similar?