The "chain" of queries concept makes sense...I think that would be really useful. I definitely understand that it would be difficult from a technical perspective. I'm looking forward to the changes you're able to make. On the question of how to "switch" the logic I would suggest defaulting it to show results when the query is NOT true. So if their original query has LeBron and Wade on the court with Bosh off then the opposite would be all the minutes played by the Heat when that combination is not TRUE. So if the Heat play 25 out of 48 minutes with James/Wade on and Bosh off the other 23 minutes would give you the "switch" results. I'm not sure if that would even be possible from a technical perspective, but that would be my suggestion on the best way to set that up.
The "chain" of queries concept makes sense...I think that would be really useful. I definitely understand that it would be difficult from a technical perspective. I'm looking forward to the changes you're able to make. On the question of how to "switch" the logic I would suggest defaulting it to show results when the query is NOT true. So if their original query has LeBron and Wade on the court with Bosh off then the opposite would be all the minutes played by the Heat when that combination is not TRUE. So if the Heat play 25 out of 48 minutes with James/Wade on and Bosh off the other 23 minutes would give you the "switch" results. I'm not sure if that would even be possible from a technical perspective, but that would be my suggestion on the best way to set that up.