Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a basic set of data whereby I am looking at vehicle turn around time.
I need to compare the 'NAME' field where selected and display the previous 5 'TurnAround' times for that selection.
Data looks like:
ID NAME VALUE YEAR TurnAround
001 | AA12 ABC | YES | 2014 | 21.5 |
002 | AA12 ABC | YES | 2014 | 18.7 |
003 | AA12 ABC | NO | 2014 | 20.1 |
004 | BB10 AAY | NO | 2015 | 34.3 |
005 | CA11 MEE | NO | 2015 | 18.1 |
006 | BB08 KKH | NO | 2015 | 19.5 |
If I select 'AA12 ABC' I want to display: '21.5, 18.7, 20.1'
Can this be achieved with Set Analysis?
Please explain further.
i dont understand the challenge going by what you mention.
if you create a table like above and the name is selected the table will get filtered by that name.
@c_latham wrote:
If I select 'AA12 ABC' I want to display: '21.5, 18.7, 20.1' -- How do you want to display this?
If you need to display in a textbox, give it a try with
CONCAT(DISTINCT Turnaround, ', ')
This should deliver all possible Turnaround-entries for the current selection, separated by a comma (and - in case of multiple entries - give each value only once)
HTH Peter