Question Re: Date field as key figure in CRM and CX Q&A

Date field as key figure

spyros — Thu, 19 Dec 2019 09:52:52 GMT

Hello,

How can I create a Key Figure form a Date field in Cloud for Customer C4C?

I have a Date field in a Cloud Data source which shows up as attribute.

I want to perform calculations with this Field. Calculate the days form that date till today. Therefore I need this field to be a Key Figure. How can I configure this field as a Key figure or create a key figure from it?

Thanks,

Spyros

Re: Date field as key figure

former_member497128 — Fri, 17 Apr 2020 13:01:54 GMT

Dear Spyros,

Please find our analysis as below:

You can create calculated key figure only using the key figures available in the data source as they are quantifying values. Characteristics will not be seen in this tab calculated/restricted key figures since you cannot perform calculation on those fields.

And if the characteristics that you want to make use in creating calculated key figures are date fields then those fields can be created as key figure from Cloud Studio by partners. Then you can be utilize those date fields for creating calculated key figure.

Same has been mentioned in case document:2579377 - Cannot use Characteristic to Create Calculated Key Figure

blog on Use Date data type field as key figure in Analytics

https://blogs.sap.com/2016/04/22/use-date-data-type-field-as-key-figure-in-analytics/

Please check further and let us know in case of any further concerns.

Regards,

Saurav Kumar

Re: Date field as key figure

former_member775334 — Sun, 28 Nov 2021 10:29:54 GMT

This feature is a must for so long now....

It is disappointing the SAP didn't added it in one of their releases, or enhanced much further the functionality to create a calculated field.

Regards,

Daniel Fogel