LookML Model

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):

Screenshot 2025-01-31 10.15.30 AM.png

Desired model:

Aveonline_0-1738337161752.png

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:

  • Is it possible to create a LookML model in a single Explore using joins that enables this behavior?
  • How can I ensure that both tables respond to the same "fecha" and "cliente" filters at the same time?

Any guidance or examples would be greatly appreciated!

Thank you in advance for your help!

0 1 146
1 REPLY 1

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.

 

 

Top Labels in this Space
Top Solution Authors