I am fairly new to Looker but my skills in SQL are advanced. I want to achieve a Look that will give me a daily average (the average of row counts per day). The SQL query goes like this.
avg(num_ids) as avg_daily_num_ids,
DATE(date) AS date,
COUNT(DISTINCT id) AS num_ids
GROUP BY 1,2,3
GROUP BY 1,2```
Is it possible to build this in Looker Development Mode? How would I build a custom measure to achieve this?