Recently, we needed to gather information from two tables (or the same table) where the result of the first filter was used as input for a second filter to obtain the desired outcome. This reminded me of a “SELECT FROM SELECT” type of query. Is there something similar in Tulip?
Hey @ChirristopherOficial -
Have you seen this post Using Values In One Single Select Menu to Dynamically Populate Values in a Second Single Select Menu (Part 1) / is this what you are looking to achieve?
Thanks, Beth, but that’s not what we’re looking for. It’s more related to analytics. I can somewhat achieve this in a Tulip app using queries, aggregations, and the “is in” filter on Tulip tables, but this approach requires interaction with multiple elements instead of a single query where I can simply adjust the date range as a filter. However, our key stakeholders already have their dashboards with specific analytics they regularly consult. Instead of searching for information in different places, we aim to have all the data available in a single location
Gotcha! That makes sense.
I found this older request that seems to be asking for something similar as well: Do join/Union/CTE statement over multiple table for advanced analytics
And this question Need suggestion in analyzing data from multiple tables that would be solved by your request too.
Grouping to help gather all the relevant information 
1 Like