Hello All,
I have a set of data that has 6 main columns: Location, System, Device, Adequate, Inadequate, and Completion Date. Some background information, all devices become complete when the system is complete. There is never a time where only one device within a system is complete.
What I'm shooting for is a way to pull how many systems are complete? How many systems are Adequate / Inadequate? On the second tab is the way I figured out how to make it work to get the results I want.
Any help/advice is greatly appreciated.
Bookmarks