About Susan1

Susan1 · 02-17-2022

I am new to Looker.I have a table with a count of distinct values grouped by day.I’ve imported into Looker as a view and I want to average the daily count over a month, but all I’ve come up with so far is the total count over a month. SELECT Date(che...

Susan1 · 02-18-2022

I managed to get something by getting a count of ids by day in my derived table SQL. The simplified version is this:SELECT Date(checkinTime), count(distinct id) as daily_countFROM checkinsGROUP BY Date(checkinTime)Once I had that, in Looker I could a...

Susan1 · 02-18-2022

Yes, really what I am aiming for is an average of the daily bookings over a larger time period, but I cannot average the ids, because the id number is irrelevant. Average_distinct only averages the checkin id number so if I get two checkins one day, ...

My Stats

Susan1's Bio

Badges Susan1 Earned

Recent Activity

How do I average a daily count over week or month in looker where I need to join the data with other tables

Re: How do I average a daily count over week or month in looker where I need to join the data with other tables

Re: How do I average a daily count over week or month in looker where I need to join the data with other tables