Hi everyone,
I have a question regarding the creation of a model in LookML. Specifically, I’m trying to build a model that allows me to create a visualization where two tables, "Recibos de caja" and "Egresos," respond simultaneously to filters applied on "fecha" (date) and "cliente" (client).
(Example of the dashboard in power BI):
Desired model:
The goal is to achieve this within a single Explore using joins. However, I haven’t been able to make it work so far.
To summarize:
Any guidance or examples would be greatly appreciated!
Thank you in advance for your help!
Hi,
Yes, you can create a single explore based on a query, also you can define joins relationship in the model.
https://cloud.google.com/looker/docs/derived-tables
https://cloud.google.com/looker/docs/working-with-joins
Best regards.