Measures from separate Views

actt
New Member

Hi there,

Suppose I have two tables, Revenue and Expenses, where Revenue has a measure named rev, and Expenses has measure named exp.

If, in a Looker Revenue view, I want to create a Profit measure (rev - exp = profit), is there way to reference the Expenses view from the Revenue view, assuming a join path is defined in a model? Or is the only way to either do it via a derived table, database view, or as a calculation in a Look?

Thanks,
Allan

0 2 1,108
2 REPLIES 2
Top Labels in this Space
Top Solution Authors