So I have a set of data with multiple dates of the same value and different overdue status' associated with those due dates. Similar to the screenshot below:
What I want to do is just make one data point for each date that says if there is at least one report that is Overdue. For example, 1/1/19 would be considered Overdue since it has at least one report overdue whereas 1/2/19 has both reports submitted so it would not be overdue.
What would be the best way to go about creating this?
Thanks for your help!
Solved! Go to Solution.
Thanks jdunkerley79, this worked!