(Sorry in my first sentence I meant start with unique user/ color combinations)--chad
On Fri, Dec 27, 2013 at 11:05 AM, Thomas <[email protected]> wrote: > Hi, > I was googling around for a solution of a map/reduce where I will be able > to perform a distinct/unique count of user ids, but I wasn't able to find a > concrete solution/answer to this topic. My case is to count the unique > users per day for example as well as other criteria. > I have for example the following JSON documents of events: > {"user":"user1", "color":"blue"} > {"user":"user1", "color":"blue"} > {"user":"user1", "color":"red"} > {"user":"user2", "color":"blue"} > And with my map/reduce view I want to do the following > * number of distinct users per color > { color: blue, count: 2} > { color: red, count: 1} > in SQL terms > select color, count(distinct user) as users from test group by color > Thanks > -- > You received this message because you are subscribed to the Google Groups > "Couchbase" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/groups/opt_out. -- You received this message because you are subscribed to the Google Groups "Couchbase" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
