Talent Management Dashboard
I am working on a dasboard to count the number of employees have a performance document in the worker evaluation status. I have both a KPI and a drill down report. The drill down report I am able to accurately count the number of employees however, the KPI report the count isn't correct. I've attached a screenshot of the filters as well as the count sql I'm using which I think is incorrect.
COUNT("Workforce Performance - Performance Task Status Real Time"."Worker"."Person Number" by "Performance Document"."Performance Document Period Name")