This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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?