I am trying to create a Bar Chart that shows the number of videos created by users within a given month.
Here is my data set:
Here is my x-Axis formula because I need a dynamic monthly range for the chart:
And finally, my series formula to match a user:
The problem is that from my data set you can see that I have 2 identical dates so the Lookup function is only returning the first match and I am getting less results than I should for July in this case.
I know that the group and groupby functions are also doing this and I changed the lookup function to only use selects with the same results.
I've been at this for 2 days and I feel like I'm so close yet so far away.