What if when a person's reset date was null (meaning they are PENDING), that we insert their Cutoff Date. The calculation I created was "Reset Date (w/Nulls as Cutoff Dt)":
IFNULL([Reset Date],[Cutoff Date])
Then you can create a view that includes all employees, and shows completed password resets as well as the final cutoff dates for anyone who is still pending. In my view, percentage complete is just a simple ratio of a running total and a total of all employees. See attached workbook for a potential view.
Hope this helps.
passwordResetSample - edit.twbx 135.9 KB
Thanks for the help Jacob! That definitely gets me a little closer to where I want to head. After banging my head for a while, I bit the bullet and restructured the data for better visualization. Definitely takes practice wrangling things into a workable format and I appreciate your help!