Streamlining Postgresql Query

Hi Team,
We have a requirement of streamlining the query used in multiple panels.
Say we have 3 different panels - A,B and C which uses individual query and our plan is to bring the fourth panel -D using a single query bringing in all the metrics used in A, B and C (which will be a union of all the 3 panels [A,B and C]).
So our idea is to make use of the combined output data in the panel -D and distribute to other 3 panels - A,B and C.
We found the below links to be useful for bringing in the output of a panel to another, but the problem we are observing is that resulting panel query is non-editable. The final panel will show the complete set of values from the first query.

This is really a good scenario.
Can you please see if the transformation helps?

1 Like