Forum Discussion
Set date range limit on google analytics query
When you bring the Time attribute in your query, you have the ability to right click on the time field and specify the filter condition (Before, After, etc.) after the filter has been applied you can click on a gear box next to the Filtered Rows step in the Applied Steps section on the right and tweak it if you need to.
When you bring the Time attribute in your query, you have the ability to right click on the time field and specify the filter condition (Before, After, etc.) after the filter has been applied you can click on a gear box next to the Filtered Rows step in the Applied Steps section on the right and tweak it if you need to.
Here's the actual solution:
1) Build your query at a high granularity or just bring in the dates - forget your more detailed metrics for now.
2) Load that data and then filter using the dropdown filters.
3) At the top 'Cube Tools' > 'Manage' > 'Add Items' - now add your more granular metrics here and only the ones in the date frame will be brought in