Skip to Content
Technical Articles
Author's profile photo Sharon Zhou

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

Assigned Tags

      2 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo ai bo zhang
      ai bo zhang

      hi,我在计算度量和计算维里面都没有看到“时间差异”,方便告诉我在哪里吗?

      Author's profile photo Sharon Zhou
      Sharon Zhou
      Blog Post Author

      您好,

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

      希望我的回答对您有帮助,

      Sharon