This is wrong: WITH DISTINCT channel.name AS channelName, channel.date AS date, programDiscoveryByDevice.device AS device, discoveryByDevice.count AS count, sum(discoveryByDevice.count) AS *total*
*you can't do distinct on an aggregated row* *and if you return the individual *discoveryByDevice.count, you can't aggregate at the same time also you group by channel.name and date !! and device in the WITH On Tue, Nov 25, 2014 at 9:54 AM, Sukaant Chaudhary < [email protected]> wrote: > Hi, > In the following query I'm getting the correct result for device and count > but for *total* I'm getting the sum of duplicate relations also, but I > want to avoid the sum of duplicates, I only want the sum of unique > relations. Please help me to correct the query. > > MATCH > (genre:Genre)-[:HAS_CHANNEL]->(channel:Channel)-[:HAS_PROGRAM]->(program:Program)-[:HAS_GENDER]->(gender:Gender)-[discoveryByDevice:HAS_PROGRAM_DISCOVERY_BY_DEVICE]->(programDiscoveryByDevice:ProgramDiscoveryByDevice) > > WITH DISTINCT channel.name AS channelName, channel.date AS date, > programDiscoveryByDevice.device AS device, discoveryByDevice.count AS > count, sum(discoveryByDevice.count) AS *total * > WHERE channelName IN ["chowtime on","music","bollywood on","hollywood > on","primetime on"] > AND (date >= "2013-11-08" AND date <= "2014-11-08") > RETURN device, sum(count) AS count, sum(total) AS *total*; > > +-----------------------------------------+ > | device | count | *total* | > +-----------------------------------------+ > | "ANDROID" | 2 | 14784 | > +-----------------------------------------+ > 1 row > 488 ms > > -Sukaant Chaudhary > <http://in.linkedin.com/pub/sukaant-chaudhary/33/ba8/479> > > -- > You received this message because you are subscribed to the Google Groups > "Neo4j" 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/d/optout. > -- You received this message because you are subscribed to the Google Groups "Neo4j" 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/d/optout.
