matomo-org/matomo

Add "local time - Day of the Month" as a possible dimension in Custom Report

Open

#20,950 opened on Jun 29, 2023

View on GitHub
 (12 comments) (0 reactions) (0 assignees)PHP (21,513 stars) (2,847 forks)batch import
EnhancementHelp wanted

Description

Summary

We previously encountered an issue that the same set of data would look different in Admin UI vs Custom Report

  1. 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)

  2. 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

Contributor guide

Tech stack
javascriptsql
Domain
analytics
Issue type
feature
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
3
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
1-2 days
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
active
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
clear
Prerequisites
Understanding of timezone conversionFamiliarity with Matomo's Dimension APIBasic web development knowledge
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
40
Research direction
The request is to add a 'local time Day of the Month' dimension to Custom Reports. Existing UTC dimension definitions in `plugins/CustomReports/Dimension/Date` or core dimension classes should be referenced. The 12 comments may contain maintainer guidance; review them for expected implementation approach and any constraints. Key files to examine include dimension registration files and report rendering logic that handles timezone conversion.
Add "local time - Day of the Month" as a possible dimension in Custom Report · matomo-org/matomo#20950 | Good First Issue