Add "local time - Day of the Month" as a possible dimension in Custom Report
#20,950 opened on Jun 29, 2023
Repository metrics
- Stars
- (21,513 stars)
- PR merge metrics
- (Avg merge 8d 11h) (106 merged PRs in 30d)
Description
Summary
We previously encountered an issue that the same set of data would look different in Admin UI vs Custom Report
-
In Admin UI, we can do a segment by website time, let's say a week worth of data, then the we would see 7 different data points (CORRECT)
-
In Custom Reports, we can do a segment by website time, but since "Day of the Month" is only available in UTC time, we would get a week worth of data spread across 8 different data points (INCORRECT)
We've mitigated this issue temporarily by changing our website time to be UTC to avoid the whole 7-vs-8-data-point problem. However, since our client still assumes the data we're providing data in American time, we're technically providing incorrect data to them.
Therefore, I would like to request to have "local time - Day of the Month" as a possible dimension in Custom Report