How to get Employee, Leave and Unauthorized Absence Count Datewise in given Period in OTBI Analysis

SurendraPB

Dear Team,

I tried with subject Areas Reported Time Card Details and Absence Real Time.
But not getting correctly.

Need date-wise counts in a given date range.

Tried Accrual Real time subject Area, it is giving duration as null.

Following Columns Required (HCM):

Person Number

Total Employee Count

Employee Present Count

Leave Applied Count

Unauthorized Absence Count

Please advise on the requirement.

SurendraPB

Dear Team,

Please suggest how to achieve this requirement.

Thanks in Advance