Forum Discussion
Pulling selected rows from a table based on multiple criteria
Maprach You should be able to use a Merge tables query to merge that column in the table with the Tasks table to get all of the tasks for those projects.
Maprach Why not just use a Table visualization instead of an actual table to display these? You could simply use the Filters pane to filter out task statuses that you don't want to display.
Greg_Deckler Thank you, Greg. This table would be used in a Matrix Visual for a quick glance at where the project stands, with competed tasks shown in a different format than those not completed. As I need to show all task statuses, I am not able to use filters on the visual. But I need to be showing this just for the projects that are active, as described above.
Maprach You should be able to use a Merge tables query to merge that column in the table with the Tasks table to get all of the tasks for those projects.
Greg_Deckler Yes, you are right, Merging does it. Thank you very much! I also found that if I connect these two tables, in the matrix visual I can list Projects from the Active Projects table and then add tasks from the big table, with their statuses, it also does the trick. Not sure why I did not see that before. But you have helped greatly. Thank you.