Count number of employees submitted response in PERSON EFF (OTBI Count)
Hi All,
We have developed a Person EFF, and we require an OTBI report that can count the number of employees who submitted their response in the Person EFF (Self Identification as shown in Screen Shot 1).
We need data in two columns:
- Business Unit Name
- Number of employees submitted a response
We need to count the number of employees whose Effective Start date under Self Identification is not null, as shown in the Screen Shot 1
However, as seen in Screen Shot2, we are receiving the same number for each business unit.
Screen Shot1
Screen Shot2
XML Code:
<saw:report xmlns:saw="com.siebel.analytics.web/report/v1.1" xmlns:xsi="