SUMMARY

This PR fixes incorrect time shift behavior in the ECharts Timeseries path used by the Bar chart.
Fixes#36966.

Previously, when a time shift (e.g., 1 month, 5 months) was applied, the shifted series was not properly aligned during series construction insidetransformProps.ts. This caused incorrect rendering and misalignment of shifted data along the x-axis.

This update corrects the time shift handling logic to ensure proper timestamp alignment and consistent rendering across different shift values and dimension combinations.

BEFORE/AFTER SCREENSHOTS OR ANIMATED GIF

Before (Time Shift Not Functioning Correctly)

• Time shift not reflected properly on x-axis

After (Time Shift Working as Expected)

• Shifted series aligns correctly with timestamps
• Multiple shift values render properly
• Behavior consistent with expected time shift semantics

TESTING INSTRUCTIONS

1. Create aBar Chart
2. SelectTimeseries mode
3. Add a metric
4. Apply aTime Shift (e.g.,1 month,5 months)
5. Optionally add one or moreDimensions
6. Verify:
   • Shifted series renders correctly
   • X-axis alignment is accurate
   • No duplicated or broken series
   • Chart behaves consistently across different shift values

Tested locally using Docker environment.

ADDITIONAL INFORMATION

• Has associated issue:FixesCertain Annotation Options Have No Effect in Time Series Annotations #36966
• Required feature flags
• Changes UI
• Includes DB Migration (follow approval process in SIP-59)
  • Migration is atomic, supports rollback & is backwards-compatible
  • Confirm DB migration upgrade and downgrade tested
  • Runtime estimates and downtime expectations provided
• Introduces new feature or API
• Removes existing feature or API