Recent Login Details of Particular Timespan

[Shri G]

Hi All,

I have to display most recent data of user which falls within 5 min of login of that particular user for specific access type.

For example, if the user A's first login is at 8:33:59 AM for access type Home and If the same User A login at 8:35:59 AM and 8:38:59 AM again for access type Home, then the data of most recent login need to be displayed if user has multiple login within 5 min of first login. So here need to display the recent login which is 8:38:59 AM

Example Data :

Expected Output:

Can somebody please help me with this?

Thanks,

Shri

[Heleen Snelting]

We have updated the topics to match the question.

[Heleen Snelting]

Hi @Shri G​ 

I am responding with an answer from Gaia Paolini, we are having some issues getting the script posted for you as well but will try in a separate answer.

"I cannot find a way of doing this with Spotfire calculated columns, as it seems to need a recursive approach.I could get the same results as you by producing a new table using a TERR data function. See e.g. this link for info on setting up data functions:

You will have to install the R data.table library:from top menu > Tools > TERR Tools > Package Management > Load the CRAN repository then type 'data.table' in available

packages,

select it from the results below, click Install.To create the data

function:from top menu > Data > Data Function properties > Register

new make sure the language is TERR

copy and paste the script below

set dt as input parameter of type Table

set dt1 as output parameter of type Table

click on Run on top/right and assign the input and output tables."

[Heleen Snelting]

Hi @Shri G​ here is the script - hopefully this format works for you.

Heleen