AZA: Split Absence Entries
Does anyone know how can we split the absence entries.
Example: If employee applies for a 3 days sick absence from 01-May-2022 to 03-May-2022 (single entry with absence start date May1 and end date May3). When we query the data in the BI we will get a single record but how can we split the absence into 3 rows with like below
Any pointers much appreciated
Thanks in advance