llooker / pendo_usage Goto Github PK

In the events.view.lkml file, I'm getting some unexpected results in the days_active_last60 column.

The field is calculated by
sum(case when TO_DATE(DAY) >= DATEADD(day,-60,CURRENT_DATE()) then 1 else 0 end) over (partition by VISITORID, ACCOUNTID) as days_active_last60

I think this is supposed to answer the question in the last 60 days, how many days was this Visitor active? If I understand correctly, the output should be between 0 and 60.

I think the results I'm getting are actually answering the question In the last 60 days, how many events did this Visitor log?

Shouldn't it be counting distinct dates, rather than summing 1's where an event's date was in the last 60?

Thanks!