How to create Advanced Calculated Column based on Date Input Control?

[karo_k]

Hi,

I am looking for a way to create Calculated Column/Calculated Dimension in SAC Story where I will be able to overwrite values from data source according business rules like:

when CreateDate between Date 1 (Date Input Control 1) and Date 2 (Date Input Control 2) then "New"

when SystemStatus for Date 1 (Date Input Control 1) != SystemStatus for Date 2 (Date Input Control 1) then "Change"

else SystemStatus

Is it even possible to do in SAP Analytics Cloud Story?

Thanks in advance,

Karo

[Subhasmit]

Hi ,

please go through with this link https://blogs.sap.com/2020/10/31/date-calculations-in-sap-analytics-cloud-using-custom-date/

It will be helpful for you.

Thank You

[karo_k]

Hi subhasmit121 , thank you for reply, but unfortunately the content of the provided link is not what I am looking for. I need to find a way to assign statuses (text vales) based on specific business rules which include selected Date Input Controls and detect if there were a change in text values between selected Date Input Controls. Any other hints or referrals?