Skip to content

Non-extensive measures e.g. COUNT DISTINCT #31

@danfrankj

Description

@danfrankj

Given an input "transaction fact" containing one row per transaction, compute "transacting users by day".

In SQL this might accomplished via

SELECT 
  COUNT(DISTINCT user_id)
  , ts::DAY
FROM transaction_fct
GROUP BY 
  ts::DAY  

In particular to compute this we need not join any table containing all users as this may be quite expensive.

Potentially related to #30

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions