Hey there @twilliamsgsnetx.
The reason we are seeing duplicate rows in your example is because, for each
join_date, there are different values for the
is_girl field and the
is_new_member field per each individual date.
For example, this is what my explore looks like when I just select field
created_date from my view/table
We see each individual distinct date, i.e. no repeated dates. Let's look at what happens when I select a Yes/No dimension IsFemale (yes for users that are female):
We see that, in this table, the dates do get duplicated and this is because there are both male and female users created on the same days. So on 2018-01-28, for example, both male and female users were created. The same concept applies to your example. When I apply a similar table calculation, I get the same resulting behavior that you are seeing (displayed below) and that is because the calculation itself it not being grouped by the date or any other field, but rather generating that sum post query.
To achieve our goal here, we can filter the
is_girl field and
is_new_member field with front end filters without actually including them in the table. To do this, we would hover over the desired field and select
FILTER without selecting the fields themselves, then we would choose the conditions we want our results to satisfy. In your example, something like
is equal to
is equal to
Y. We can select
join_date to include in the table and also select the
count measure. This will group the counts by date for the results that satisfy the filter.
In my example, I am filtering
Yes and selecting
count. This is an example of how the explore should look:
To exclude the NULL values, we can select "Remove Filled in Dates" in the cog menu of the date dimension and run the query again. Or you can also include the other fields that you filtered by and just hide them from the visualization. This generally hides the records that correspond to the nulls that we initially see:
I hope this helps! Please let me know if there is anything I can clarify on my end!