2025 Mar 19 5:42 PM - edited 2025 Mar 19 5:47 PM
SAP Datasphere #TimeInterval
Hi All,
I have requirement to calculate the time interval between two Time Feilds in Graphical View using Calculated Column
There are 4 Dimension for a requirement with data in below format. I need to calculate time interval between Process Order Start Time and Finish Time in Hours. I have tried various function but it's not giving accurate results. Can anyone help me to calculate the expected results.
Process Order Actual Start Date | Process Order Actual Finish Date | Process Order Actual Start Time (HHMISS) | Process Order Actual Finish Time (HHMISS) | Time Interval between Process Order Start Time and Finish Time in hrs (Expected Result) |
20250106 | 20250107 | 164144 | 000000 | 8 |
20250107 | 20250122 | 063933 | 000000 | 18 |
20250117 | 20250117 | 000000 | 093135 | 9 |
Request clarification before answering.
You need to concatenate The Date and Time column to generate a timestamp, then calculate the interval:
Formula of the calculate column "IntervalDays": : DAYS_BETWEEN(TO_TIMESTAMP(CONCAT(START_DATE,START_TIME),'YYYYMMDDHHMISS'),TO_TIMESTAMP(CONCAT(END_DATE,END_TIME),'YYYYMMDDHHMISS'))
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
12 | |
9 | |
8 | |
8 | |
5 | |
4 | |
4 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.