Introduction
In SAP Analytics Cloud, you can create a calculation that shows the time interval between two dates.
Your model must have Date columns or date (time) hierarchies with Day level granularity.
What Is an Insight?
An insight is a saved table view created in Data Analyzer. It contains the table structure, applied filters, formatting, and prompts. Insights are stored as standalone files and can be reused or shared without creating a full story.
Procedure:
1
Select a chart. In the Builder panel on the right, click on Add Measure > Calculations > Create Calculation.
2
In the Calculation Editor dialog that appears, select Date Difference from the list.
3
Enter a name for the calculation.
Configure the Table Using the Builder Panel
4
In the Properties section, select values for Result Granularity, Time (A), and Time (B)
The Result Granularity values are determined by the data source. If the data source does not contain quarters or weeks, then you won’t see them in the list of values.
5
Click on OK and add dimensions to your chart.
Result
The date calculation is added to the chart.
