When I have a set of data where there is a create date and a ticket number. Then I created a master calendar so I can create a bar chart where the dimension is the month name of the master calendar.
When I use count(if(month_master = mont_create, id)) i'm getting duplicate information and my count is wrong. However, when I use count(distinct(if (month_master = mont_create, id))), the count is correct.
I verified my data doesn't have duplicates by doing a count(id) and count(distinct(id)).
When I created a simple test file, it seems to work also. I'm at a lost how I can continue to troushoot this error.
