Convert pre-defined Duration column in days

[m.ra...@uurla.it]

Hello,

i need to convert the values of the predefined column "Duration" (process duration) from seconds to days, display it in a web report in a form that permits me to export that column to csv.

If i use a calculated column in the web report then that column won't be exported, so i tried to define a measure that gets the duration in seconds and does the math to convert it in days, but i cannot find the process duration variable anywhere (the one associated with the defaul column "Duration"), if there is one.

Any help would be much appreciated.

Best Regards,
Manuel

[ab...@runmyprocess.com]

Hello Manuel,

Sorry for the delay.

Could you please provide the screenshots of the measure variable you have created, the configuration of timer, and the process report's computed parameters section.

Regards,
Amit A. Bais
RunMyProcess Support

[m.ra...@uurla.it]

Hi Amit,

thanks for the reply, in the screenshots you can see the column i'd like convert in days (Duration), and the computed parameters of the process, i don't know where to find the timer configuration, take note that i'm not the administrator of the platform, but i have designer rights for the project.

As i said before, i want to get the Duration in some way and then convert it in days and place it in a column i can export in a Web Report using the standard report widget.
To do this i thought of creating measure that takes that data (Duration column) and converts it in days via freemarker for example. I didn't create the measure just yet because i couldn't find the variable, or parameter, that stores the duration.

Regards,
Manuel

[Pankaj Kumar]

Hi Manuel,

To show the duration you need to create the measure for it to display in report. I am assuming you want to display the no. of days since when the request is submitted.

For this either you can use the "now" free-marker method in start parameter to save the request submitted timestamp or you can simply use a variable in web interface and and initializes it with java script. This way you can save the date-time details of the request submission in process variables.

Thank you,

Pankaj Kumar

Fujitsu RunMyProcess Support

--
Fujitsu - RunMyProcess
---
You received this message because you are subscribed to the Google Groups "Fujitsu RunMyProcess Developer Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to supportforum+unsubscribe@runmyprocess.com.
To post to this group, send email to suppor...@runmyprocess.com.
Visit this group at https://groups.google.com/a/runmyprocess.com/group/supportforum/.
To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/dc93282f-dccc-43a6-85e7-f3beeb5eaa48%40runmyprocess.com.

For more options, visit https://groups.google.com/a/runmyprocess.com/d/optout.

[Dipen Raval]

Hi Manuel ,

Awaiting for your feedback to update the case.

Thanks & Regards,

Dipen Raval

Fujitsu RunMyProcess Support

To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/CADHrCaxxMr2kKRa0Oe_rSd5Yf%3D17TJgsECSohWsunxzt%3DbbC_w%40mail.gmail.com.

[Gunjan Rajgure]

Hello Manuel ,

Are you tried the solution provided by Pankaj in last reply or still facing any issue?

Thanks & Regards,

Gunjan Rajgure

Fujitsu RunMyProcess Support

To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/CALU-Sgonr9x1o6ng_3Mnc6kvpyQoZfBBJ%2Ben-5fSTOOFQ6nNDg%40mail.gmail.com.

[Dipen Raval]

Hi Manuel,

Good Day.

Could you please confirm that issue has been clarified?

Please don't hesitate to contact us for any further query.

Thanks & Regards,

Dipen Raval

Fujitsu - RunMyProcess Support

To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/CA%2B3gzEhN3Y_4dAMHrNnBdXoKW0%3DVD_xoL7GgSWgW0%3DOE5NBaKQ%40mail.gmail.com.