Forum Discussion
Visuals for SQL job schedule
Hi Anonymous
You may try to add a column to get the count number.Then filter the column not equal 1 like below to get the overlap rows.
Column = CALCULATE(COUNTROWS(Table1))
Regards,
The problem I have is that I need to get the count for each job, and a few of the jobs run every 1minute, 2minutes, 3minutes, 5minutes, etc. but not at the same start time. Two jobs can run every 5 minutes but one job runs on the 00:30 second mark and the other job will run at the 00:45 second mark. these two jobs won't overlap, but other jobs will share the same start times and those are the ones i need to be able to count.
I need to create a visual with an x-axis as the duration of 1 day (using 0-24 hours) and a line that shows the count of overlap of the jobs running per minute of that day.
Here is the formula i have been using to count overlap so far.
Hi Anonymous
It seems you may use don't summarize for the column in the visual.
Or you may create a measure.If it is not your case,please follow this article How to Get Your Question Answered Quickly to share some simplified sample data and show your expected output.
Regards,
The count is definitely more accurate, but it still doesn't count overlap at each interval after the start time.
Do I need to make a new table through the criteria of the measure shown in your example for each moment the jobs are run?