I'm building a simple reporting dashboard for Google Analytics using historical data, and I've hit a snag
The setup:
- I'm filtering out entries where a user visited a domain that contains either "/app/" or "/custom/" in its URL path.
- The data I’m using is from about five months ago.
The problem:
- When I apply the filter to exclude these paths, the sum of the individual rows are larger than the Grand Total row or the scorecard for Sessions (both currently resulting in the same number).
- This behavior appears across multiple tables and dimensions.
What I've tried:
- Applied the filter at different levels:
- Report level
- Page level
- Chart level
- Combined these approaches, but regardless of where I place the filter, the result remains the same.
Has anyone experienced a similar issue or have any insights into why excluding sessions with "/app/" or "/custom/" might lead to inflated view counts? Any suggestions for troubleshooting this would be greatly appreciated!
Screenshots
The table

The setup


The filter

Thank you for your time!