I have the following data sets:
|task 2||2/1/2021||system 2|
|task 3||3/1/2021||system 1|
|System 1||Test 1||1/2/2021|
|System 1||Test 2||1/3/2021|
|System 2||Test 3||2/1/2021|
I am looking for a way to display the count of tasks from Task Details as lines graphed over time and display the Date from the System Dates as a vertical bar for each occurance. I would like to be able to filter on Task Name and toggle the System Dates on and off.
As you can see there is a many to many relationship between system from Task Details and System Dates.