LinkedIn
Twitter
I have a set of data showing inscriptions to a site, and each registration is shown on date format (I had issues with date in Looker before, but I believe it was solved when I changed the format of the date to YYMMDD, no spaces or anything). I wanted to update the report I had by copying the new data over the old one, as I read that is the best way to update and not have to redo everything (unfortunately this is manual as I don't have a way of feeding this data directly into Looker studio).
In a bar chart, I wanted to display new registrations each month, so for each bar (which would represent each month) it shows the total inscriptions for that month in particular. The dimension is set to Year Month (so that it groups each month from different years differently).
This March, according to the source data, there were 157 new users, but in the chart it only says 64. It also seems to happen to the total users, as there should be at least 1500 and it only shows around 1300, no idea why (screenshots below).
Here's a screenshot of part of the data (covered the emails). The columns, in order, are: ranking ID (if they made no points, they don't have an ID), name, email, country, date of registration (the one that's giving me problems), university, year of major, and the two from the very end are points in two different categories.
Looker shows these total inscriptions (no filters):
And the total Excel count is this:
Any ideas? Anything I should try? Date format to try or something? Looker seems to work great for things like Google Analytics but the moment I input something different it has problems. Any help is appreciated!
