Looking for an expression in a slice. I've go...

[Grant_Stead]

Looking for an expression in a slice. I’ve got a table, and every time an employee goes up to an asset they scan it. I would like to show a map of every asset’s most recently scanned record.

person_id asset_id track_datetime track_location

So, some sort of select, and max? So, that asset may have 10 records, I want the most recently scanned record, but there might be 40 different assets in that table.

[Grant_Stead]

The best I’ve came up with is to have a virtual column throw a flag… Then slice on that vc…

[MultiTech]

Yup.

My thought too.

[Grant_Stead]

@MultiTech_Visions

Well then, that’s what’s going to go down… (Thanks for checking in on me!)

[RezaRaoofi]

Assuming the table that has above four columns is called Tracking, go to Assets table and add a VC called LastScan with this formula:

MAXROW(Tracking, track_datetime, [asset_id]=[_THISROW].[asset_id])

Then you can grab other related columns like this: [LastScan].[person_id], or [LastScan].[track_location], etc.

[Grant_Stead]

I’ll play with this in a bit, thanks reza