-- Pilot Daily Sign Ups
-- Description
-- FILTER: {
--   filter: "date",
--   column: "Sign_Up_Date",
--   params: {
--     "format": "m/d/y"
--   }
-- }

-- @dataset true
-- @title Sign Ups
SELECT
    DATE_TRUNC('day', create_date) AS Sign_Up_Date,
    COUNT(create_date) AS count
FROM simplebrsprod.business_location
where pilot like 'mikerowe'
GROUP BY DATE_TRUNC('day', create_date);

-- @dataset true
-- @title Incomplete Sign Ups
SELECT
    DATE_TRUNC('day', create_date) AS Sign_Up_Date,
    COUNT(create_date) AS count
FROM simplebrsprod.business_prospect
where pilot like 'mikerowe' and status <> 'registered'
GROUP BY DATE_TRUNC('day', create_date);