Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I'm wondering if anybody has found a way to do one query that pulls in the page views by date with other attributes such as gender so it does not aggregate. I currently have two queries. One that has page views by date and one that has page views by date by gender. My totals are different so I'm assuming there are some responses that do not specify gender. Rather than have two queries I would rather have one query as I have over 50 web sites I am connecting to through Google Analytics.
hi, @angelakephart
You may try to pull date field with other attributes fields into one query, then the result will be aggregated by date and other attributes, not just by date or other attributes.
Best Regards,
Lin
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
117 | |
105 | |
69 | |
67 | |
43 |
User | Count |
---|---|
151 | |
103 | |
102 | |
87 | |
63 |