Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
I'd suggest you something like this:
FirstSortedValue (Stop,-Aggr (Time,[Group ID]))
Make sure Time field is on right format.
PSA.