Skip to content

[Admin Analytics] fix admin analytics timezone issue

Warren Gifford requested to merge naman/admin-analytics-fix-tz into main

Created by: thenamankumar

Fix admin analytics charts timezone issue.

For the last 3 months, the loop to populate missing nodes starts from from date i.e 3 months back from now and adds 7 days in each iteration. The DB aggregates data and returns Monday of the week as the date for the node, but the from date may not be Monday as it is just the current date minus 3 months.

The fix is the start from to date which will be Monday of the current week and go back 7 days in each iteration to match the date value of nodes returned by the DB.

The last fix didn't work because it was built, tested and deployed on Monday so at that time it worked correctly.

Test plan

Check PR.

Merge request reports