COUNT condition

[sntentos]

You are right, I got sidetracked:

COUNT Condition: Data Format Discussion

Query: cbq> SELECT {SUBSTR(t, 0, 10) : { > did : { > "foull_entries" : COUNT(NULLIF(ARRAY_LENGTH(bcn), 0)), > "total_entries" : COUNT(*), > "nulld_entries" : COUNT(CASE WHEN ARRAY_LENGTH(bcn)==0 THEN 1 ELSE NULL END) > } > }} > FROM sync_gateway > WHERE type="bcn_scan" AND SUBSTR(t, 0, 10) BETWEEN "2016-11-01" AND "2016-12-15" > GROUP BY SUBSTR(t, 0, 10), did > ORDER BY SUBSTR(t, 0, 10) ASC, did ASC; R…