Stats: Add days/weeks/months/years picker for charts

[kean]

Description

• Close CMM-705: Add days/weeks/months/years granularity picker.
• Fix an issue with mapping of data points from the previous to the current period (wasn't working correctly for weekly granularity)

Note: I decided not to limit the available combinations. You can pick "Last 10 years" and select "Days" granularity. It likely will not load, but you can just not do that and it's unclear where to set the boundaries otherwise.

Testing instructions

Screen.Recording.2025-12-23.at.1.33.43.PM.mov

[wpmobilebot]

📲 You can test the changes from this Pull Request in WordPress by scanning the QR code below to install the corresponding build.

	App Name	WordPress
	Configuration	Release-Alpha
	Build Number	30415
	Version	PR #25093
	Bundle ID	org.wordpress.alpha
	Commit	96d1b92
	Installation URL	471dqqncut9h8

Automatticians: You can use our internal self-serve MC tool to give yourself access to those builds if needed.

[wpmobilebot]

📲 You can test the changes from this Pull Request in Jetpack by scanning the QR code below to install the corresponding build.

	App Name	Jetpack
	Configuration	Release-Alpha
	Build Number	30415
	Version	PR #25093
	Bundle ID	com.jetpack.alpha
	Commit	96d1b92
	Installation URL	6ku2s8i23kdgg

Automatticians: You can use our internal self-serve MC tool to give yourself access to those builds if needed.

[crazytonyli]

Should the available selections for granularity be limited to lower than the "interval" of the selected date range?

For example, if I'm viewing data within a week (2-8 Dec in the example below), there is no need to give the option to select "year" and "month" granularity, even "week", I think?

I'm not sure how to interpret the chart below, where I selected "months" granularity on a 7 days date period. What does the multiple "Dec" on x-axis mean?

[kean]

Thanks for the feedback. It does need some improvements, especially in terms of how labels are shown. The X axis labels in general are not well aligned with the data. I think we might need a different strategy for implementing it.

Should the available selections for granularity be limited to lower than the "interval" of the selected date range?

It works like the web, and I think it's an OK approach. Here's CC rationale:

[kean]

I fixed the width of the bars and also the duplicated x axis labels. I can't quite make it align with the bar though. I'll open a separate ticket for it.

[sonarqubecloud]

Quality Gate passed

Issues
0 New issues
0 Accepted issues

Measures
0 Security Hotspots
0.0% Coverage on New Code
0.0% Duplication on New Code

See analysis details on SonarQube Cloud

[wpmobilebot]

🤖 Build Failure Analysis

This build has failures. Claude has analyzed them - check the build annotations for details.