SAP Analytics Cloud In-story Calculation Series – Blog5: Calculate Time-to-Delivery

This is the fifth blog post of a blog series with the intention to guide you towards success with In-Story Calculation. If you are interested in learning more about In-story Calculation, please check out our blog series here.

Scenario:

Your logistic department has the information about the order date and the delivery date. They want to calculate the time-to-delivery and analyze it by shipment vendor and customer.

In-story Calculations:

• Date Difference

This requirement can be easily fulfilled by the Date Difference calculation in SAP Analytics Cloud. To perform this calculation, two Time Dimensions are required. You also have the option to decide how to aggregate the result. In this scenario, we select “AVERAGE” from the drop-down list.

This calculation is simple and straightforward, isn’t it? Now you know what a Date Difference Calculation is and the steps for creating your own Date Difference Calculation, you can create your desired analysis provided with greater flexibility for time-based data in SAP Analytics Cloud. Here is my analysis – Average Time To Delivery(days) per Shipment Vendor and Customer.

Did you find this blog post helpful? In the subsequent blog, we will learn how to use In-story Calculation to group the customers by the average time-to-delivery. If you enjoyed this blog post, don’t hesitate to share it with your friend and follow our blog series!

*The product interface may vary depending on the product version