2 Replies Latest reply: Mar 15, 2017 12:52 AM by Nick Listerman RSS

    LEFT JOIN raising count due to one to many

    Nick Listerman

      I've added some data to my dashboard and the new LEFT JOIN has caused my counts to rise.  This is because it is a one to many relationship.  Is there anyway to tell count to look at a specific table and not consider the join?  I'm trying to avoid distinct because I use a cyclic group for time (month, week, day).