Troubleshooting Data Selection within Table Object

Anonymous — Mon, 30 Apr 2018 18:59:45 GMT

Hi all - quick question on data selection within a Table object.

My data is structured as:

Group ID	Area	Stop	Time
1234	A	A1	4:55
1234	A	A2	5:10
1234	A	A3	5:15
5678	B	B1	7:10
5678	B	B2	7:15

Where the first [Stop] record in each [Group ID] (e.g. A1, B1) represents origin and the last (e.g. A3, B2) represents destination.

I need to display a Table object that shows origin for each [Group ID] e.g.:

Group ID	Area	Stop	Time
1234	A	A1	4:55
5678	B	B1	7:10

Unfortunately using First([Stop]) or FirstSortedValue([Stop],[Time]) as a measure column in the table returns a blank value.

Any ideas? Thank you.

Re: Troubleshooting Data Selection within Table Object

Thiago_Justen_ — Tue, 01 May 2018 13:01:20 GMT

I'd suggest you something like this:

FirstSortedValue (Stop,-Aggr (Time,[Group ID]))

Make sure Time field is on right format.

Qrishna — Tue, 01 May 2018 15:01:17 GMT

PSA.