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.
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.
- 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
您是否使用的是数据直连的方式连接 SAP Anlaytics Cloud呢？在数据直连的情况下，有些计算暂不受支持，所以您无法在产品选项中看到它。如果您在数据导入 SAP Anlaytics Cloud的情况下还是无法看到该选项，您可以向SAP 报告这一问题。