Draft: Adds total sessions cube query
What does this MR do and why?
This uses a new cube TotalSessions that groups same session to avoid unmerged sessions results in audience dashboard
MR acceptance checklist
Please evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.
Screenshots or screen recordings
Screenshots are required for UI changes, and strongly recommended for all other merge requests.
Before | After |
---|---|
How to set up and validate locally
- Setup product analytics devkit locally.
- Pull from gitlab-org/analytics-section/product-analytics/devkit!148 (merged)
- Update cube schema. If using devkit with docker, just restart cube.
- open audience dashboard for any PA onboarded project
- Total sessions count should be constant for a given date interval at any point of time.
Related to #443624