Technology Blogs by SAP
Learn how to extend and personalize SAP applications. Follow the SAP technology blog for insights into SAP BTP, ABAP, SAP Analytics Cloud, SAP HANA, and more.
cancel
Showing results for 
Search instead for 
Did you mean: 
sharonzhou
Product and Topic Expert
Product and Topic Expert
1,612
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
2 Comments