Day wise break up of absences in OTBI

Content

Hi Team

We have a very basic requirement that absences for multiple days need to be broken down into individual days and be displayed on OTBI

When i ran the Absence details real time report, for an employee having 5 continuous days of absence, it shows the leave duration# as 1, but shows the start date as 9/21/20 and end date as 9/25/20

Ideally, i would have expected the # leave duration as 5 , or the absences broken down into single day absences. 

I even ran the Generate daily breakdown of absences, but that does nothing in the report.

 

Any idea on how to achieve either of the requirement?