Customer Relationship Management Blogs by SAP
Stay up-to-date on the latest developments and product news about intelligent customer experience and CRM technologies through blog posts from SAP experts.
cancel
Showing results for 
Search instead for 
Did you mean: 
JerryWang
Employee
Employee
I am a newbie to analytics topic in Cloud for Customer and I write down some small stuff which I have learned today into this blog. Suppose I need to build a report which shows a list of all visits whose end date are later than today. The screenshot in this blog are made in my system with version 1708 ( HTML5 UI ).

Below is what could be achieved by this report:



1. Create a new Key Figure zkf_overdue. Choose "Visit Header"(technical ID: CODAPAVISITHB) as data source.



For Key Figure type, choose "Calculated Key Figure":



2. Specify calculation logic as "End Date" > "Today". Just double click "KF_END_DATE" and "KF_DATE" and both will appear in calculation editor automatically.



Review created key figure and click Finish button.



3. Create a new report and in key figure configuration step,



choose "Show Customer Created Key Figure" from drop down list, and select zkf_overdue created from step 1.



Finish the left creation steps as usual.

4. Now preview the report and the calculated key figure could already work as expected: for those visits whose end date is later than today, it will show 1 and otherwise 0.











The final step is to filter out those visits whose zkf_overdue equal to 0. Mark Key Figure option and click "Conditions" from drop down list:




Create a new condition:




In condition rules, make the following settings:



Once done, only those visits with zkf_overdue = 1 will appear in the report list.