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).
Count(), or any other function, can not be limited to a specific table. The workaround is to maintain a separate table with the counter at the desired level of granularity.
Count(), or any other function, can not be limited to a specific table. The workaround is to maintain a separate table with the counter at the desired level of granularity.
