Re: Average New Users Per DOW

Поиск

Список

Период

Сортировка

От	David G. Johnston
Тема	Re: Average New Users Per DOW
Дата	6 июля 2015 г. 18:21:01
Msg-id	CAKFQuwa9N1-ciQw+Yao=-ZCiUpaoJYT=w-0b-++2XdD92qx47Q@mail.gmail.com обсуждение исходный текст
Ответ на	Re: Average New Users Per DOW (Robert DiFalco <robert.difalco@gmail.com>)
Список	pgsql-general

On Mon, Jul 6, 2015 at 2:04 PM, Robert DiFalco <robert.difalco@gmail.com> wrote:

Wouldn't I have to generate a series based on the date range (by day) and then group by DOW _after_ that?

You are correct.

WITH userdays (dow, user_count) AS ( existing_query, more or less )

, day_counts (dow, count_of_days) AS ( SELECT generate_series(user_earliest_created_date, user_most_recent_created_date) )

SELECT dow, coalesce(user_count, 0) / count_of_days

FROM day_counts

LEFT JOIN userdays USING (dow)

;

David J.

В списке pgsql-general по дате отправления: