Date grouping across multiple tables and measures

[guest1566]

I have LookML definition that has 3 views, and explore model that joins all these views.

Each view has some measures and the date column. Measures are not related to each other so there is no a single date value under any of views that relates to all measures.

Table1:

• Date1
• M1 (measure)

Table2:

• Date2
• M2 (measure)

Table3:

• Date3
• M3 (measure)

I’m trying to create a pivot table e.g.:

| Month1           | Month2           | ...

| M1 | M2 | M3 | M1 | M2 | M3  |

where Month1/Month2 are last 2 months, and all M1-M3 measures are calculated based on Date1-Date3 belonging to Month1/Month2

Ideally, the user to be able to choose the date range (monthly, weekly, last 3-6-12 months)

Ideally, I don’t want to create a separate precalculated denormalized single view