I am doing process based tempo report and fetching all display data form process report.

vikrams290 over 8 years ago

hi guys, I am doing process based tempo report and fetching all display data form process report.
I am not able to display exact data of portal report into tempo.
like:-
----------------------------
portal report:-
--------------------------------------------------------------------------------------------------
Resource Avg lag time Avg Work Time
----------------- -------------------- --------------------------
vikram 52 days 20 hrs 5 min 25.270 secs
Aman 37 days 23 hrs 23 min 56.366 secs
Jenna 20 days 13 hrs 52 min 29.791secs
Alena 6 mins 29 secs 4days 22hrs 50 min
Denial 4 days 21hrs 20 min 15.413 secs
------------------------------------------------------------------------------------------------------------------

Tempo report:-
-------------------------...

Discussion posts and replies are publicly visible

0 vikrams290 over 8 years ago

...-----------
Resource Avg lag time Avg Work Time
----------------- -------------------- --------------------------
vikram 52.82575 0.0002976852
Aman 37.96292 0.0006523881
Jenna 20.56655 0.0003447975
Alena 0.004506075 4.940068
Denial 4.878537 0.0001783912
------------------------------------------------------------------------------------------------------------------
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 aayusha
Certified Senior Developer
over 8 years ago

Hi Vikram,
What is the configuration for the fields Avg. Work time, Avg. lag time and Avg. completion time in the portal report ?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 aayusha
Certified Senior Developer
over 8 years ago

It is calculating all the time according to the number seconds in a day for the Avg Work time. For example 25.270/86400 days
And similarly it changes hours to days.
Now, to have similar to portal report, I guess one has to create rules manipulating the display value
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 brettf over 8 years ago

As earlier mentioned, I would create an expression rule that will take in an individual number and format it as you want. Then, in the data input of the paging grid, apply over that rule, passing in the data for that particular column.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 sikhivahans over 8 years ago

@vikrams Hi, please find attached the text document that might give you leads and aid you in the conversion thereby. Please do let us know in-case if you have any followup questions or concerns.
AT_getDurationDisplay.txt
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel