Issue Summary

Space Analytics in confluence showing incorrect number of page views when the date range is set to more than 3 months and when we try to sort the number of views (or any other activity column) in ascending order. The page views shows correct number if leave the default date range (3 months) and not sorting any activity column.

Once we sort to ascending order, many pages shows the number of views as 1 where  the actual number is more than 100+

Case Reported :CES-46549

Communication with cc-insights-data: https://atlassian.slack.com/archives/CJ1V0DADC/p1723811815467639

Anand Kamaleshbhai Naik confirmed that this is a bug

This is reproducible on Data Center: Yes

Steps to Reproduce

1. Navigate to Apps> Space Analytics
2. Change the date to more than 3 months , for example Jan 1 2024
3. choose the space any space
4. Navigate to Pages, Change the date range in the page analytics screen as well
5. filtered the views column in ascending order 
6. Open any of the pages that shows number of views like 1 or 2 and change the group by filter to Month for easy analysis and view the number of views showing in the page analytics. In space analytics the views showing as 1 but in page its 100+

Expected Results

The number of views under space analytics and Page analytics should show the exact same numbers

Actual Results

In space analytics once we sort ascending order the the number of views showing as 1 most of the time for many pages while the page analytics showing the actual number of views

Workaround

There is no promising workaround, but we could suggest the users's to avoid filtering in ascending orders in any activity column.