past
1 TopicDynamic sized table showing current /previous items
Help please. I want to show a list of the passengers for the selected taxi route/date, and a list of passengers for the same route the previous day. This list is not always the same length. I also want the table to be blank when no route is selected. Any help? Currently I have 2 visuals - First visual shows Table_journey_detail[RouteID] and Table_journey_detail[Date], - Second visual shows only Table_individual_details[PersonID] I have 2 problems with this 1) when no route/date is selected on the first visual, the second visual shows every possible PersonID, and 2) my previous passenger list is showing current passengers. NOTE: I cannot use concatenatex as I want selecting the PersonID to filter the first visual Data Available Table_journey_detail Date RouteID _#Passengers Cost OtherData 10/2/2020 A1 3 £6.00 True 10/2/2020 B2 2 £4.00 False 11/2/2020 A1 4 £7.00 False 11/2/2020 B2 2 £4.00 True 12/2/2020 A1 3 £6.00 True Table_individual_details Date RouteID PersonID OtherData 10/2/2020 A1 Ewan Dc 10/2/2020 A1 Niamh Rb 10/2/2020 A1 Cillian Tyej 10/2/2020 B2 Saiorse Etuk 10/2/2020 B2 Aodh Ril 11/2/2020 A1 Ewan Il 11/2/2020 A1 Aiofe Yil 11/2/2020 A1 Niamh Hng 11/2/2020 A1 Ciaran iov 11/2/2020 B2 Aisling Ag 11/2/2020 B2 Bronagh ARG 12/2/2020 A1 Brigid Y 12/2/2020 A1 Niamh RYIYL 12/2/2020 A1 Cillian TUI Expected Output: Journey selected – A1-10/2/2020 Most Recent Journey Previous Journey Ewan Niamh Cillian Journey selected – A1-11/2/2020 Most Recent Journey Previous Journey Ewan Ewan Aiofe Niamh Niamh Cillian Ciaran Journey selected – A1-12/2/2020 Most Recent Journey Previous Journey Brigid Ewan Niamh Aiofe Cillian Niamh Ciaran Journey selected – None (empty table) Most Recent Journey Previous JourneySolved3.9KViews0likes9Comments
