How to convert seconds to the date format (DD-MM-YYYY)?Also what could be the reason for having the same 'PU_median time' value for all the cases in the data set?

Question

Hallo Team,

I have been using the P2P dataset provided by the academy.

Had used the following statement to calculate the PU_median according to each case - PU_Median("LFA1", "_CEL_P2P_ACTIVITIES_EN"."EVENTTIME").

I have diffculties understanding the outcome (in pic attached) -

Why do I get the PU_Median time calculated in seconds format?
How can I convert the O/P format in seconds to DD-MM-YYYY ? - Had tried using {t } function, but it was an failure
Even though there are different time stamps for each case wrt to activity - why do I get the same median time (1245079800000) for all the cases?

Can any I detail it .

Thanks in advance.

dennis.van.d · Answer

Hi Abhinav,A possible fix for your PU_MEDIAN function is to make sure that the KPI definition uses the date format. It looks like it is currently set to a string or integer. You can set the format in the screen where you make the KPI.The median time might change once the KPI is set to a different format.Good luck!Dennis

Reply

ANY QUESTION?

MORE CELONIS

CHECK US IN

Reply

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded

ANY QUESTION?

MORE CELONIS

CHECK US IN