Date field as key figure

[spyros]

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

[former_member497128]

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

[former_member775334]

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