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 231
1 REPLY 1
Top Labels in this Space
Top Solution Authors