How to avoid trunc date in explore joins

Hi,

When exploring multiple columns views are joined based on the joins defined in model. But I am running into issues when join happening on the date column. Looker by default using trunc( date ), which is causing duplicates when there are multiple entries on same day.

Eg : Instead of     A.date = B.date   its becoming Trunc(A.date) = Trunc(B.date)

0 3 368
3 REPLIES 3
Top Labels in this Space