Hi I’m hoping someone can help me with a time series query using MSSQL as the data source.
I want to have a time-series graph that will display the total number of jobs that are open vs number closed from the point in time A to point in time B
the data is structured like this:
Column A: Job ID
Column B: Date and time open
Column C: Date and time closed
Column D: Status (Open / Closed)
Any help appreciated! thanks