Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have two queries pulling similar data from Google analytics. One gets Users and the date and the other one Sessions and the date.
With one I can create a date hierarchy but not with the other. The dates have the same formatting and properties. What gives?
Make sure that in your query that they are both flagged as Date or Date/Time in the query.
Yup, I definitely did that.
User | Count |
---|---|
128 | |
108 | |
100 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |