Create Column in Script

[ankur_abhishek]

Hi ,

I want to create the below Time column at script level instead of a pivot table in UI.

I have use this formula to calculate Time (:

If(Dimensionality() > 2,

Interval(

If(RowNo()=1,0,If(RangeSum(page_viewed_datetime,-Above(page_viewed_datetime))> 0,

RangeSum(page_viewed_datetime,-PTime))),'mm'),

Interval (Max({<page_viewed={'Logout Page'}>} page_viewed_datetime)-

Min({<page_viewed={'Login Page'}>} page_viewed_datetime),'mm')

)

It calculating the time an user stay on a Page

Kindly help me in creating calculated column (Time) .

[ahaahaaha]

Hi,

May be like this for [Time] field

Time(Timestamp#(page_viewed_datetime, 'MM/DD/YYYY hh:mm'))

Regards,

Andrey

[ankur_abhishek]

HI Andrey ,

My requirement is different i want to know how much time user stay (browser) the page. for that i have used expression as mentioned above.

Can you help me in creating a column in script.

Thanks

Ankur

[antoniotiman · Accepted solution]

Hi Ankur,

See Attachment.

Field is PTime1.

Regards,

Antonio

[ahaahaaha]

May be like at attached file

[ankur_abhishek]

Thanks Antonio