SAP Story Analytics Timesheet report

[skusulja]

Hello everyone,

I'm currently working on creating a timesheet table report in SAP Report Center, and I need some help resolving a data-related issue.

The report I'm building includes the following details:

• Employee Name
• Date
• Category (e.g., Absence or Attendance)
• Time Type (e.g., Working Time, Vacation, Sick Leave, etc.)
• Number of Hours

The issue lies in how the data is presented:

1. For attendance types, the data is recorded on a daily basis, which works perfectly for my needs.
2. However, for absence types, the total number of hours is recorded as a single sum on the first day of the absence, instead of being distributed across the relevant days.

For example, as shown in the attached picture, if an employee requests a vacation for December 23rd and 24th, the report shows 14 hours on December 23rd but no data for December 24th
Has anyone encountered a similar issue, and if so, how did you handle it?

Any guidance or best practices would be greatly appreciated. Thank you in advance for your help!

[AbrahamAbad]

Have you thought about converting the balance for the other leave types into hours through a calculated column?
Option 2: Use the template: story report for timesheet 2.0