Skip to main content
Question

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?

  • Aug 10, 2023 7:49 PM UTC
  • 2 replies
  • 150 views

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?

 

image 

Can any I detail it .

 

Thanks in advance.

2 replies

  • Aug 11, 2023 9:45 AM UTC

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


  • Aug 14, 2023 8:15 PM UTC

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

HI @dennis.van.d ,

 

Thank you for the reply.

 

I tried it over Data Explorer. So facing difficulty in converting the Timestamp in STRING to DATE format. As said, I had tried using {t } function, but it was a failure.