Analytics charts: support an optional secondary time dimension

Add support for an optional secondary time dimension in Analytics Charts.

Currently, users can group chart data by one primary dimension, but there is no convenient way to build a report where one axis contains business categories and the second axis contains time periods.

This creates difficulties when users need to analyze a large number of categories over time.

For example, if there are more than 100 Topics, manually creating a separate row or filter for each Topic is time-consuming and increases the risk of configuration errors.

Required Behavior

Users should be able to create a Chart where:

• one dimension represents a business entity, for example Topic;

• the second dimension represents time, for example Month.

Example structure:

• Rows: Topics

• Columns: Months

or vice versa:

• Rows: Months

• Columns: Topics

The time dimension should support the existing available time grouping options, such as:

• Day

• Week

• Month

• other supported time periods

The secondary time dimension should be optional and should not affect existing Charts that use only one grouping dimension.

Example Use Case

A user wants to analyze the structure of customer requests over a long period.

Expected report:

• Rows: Topics

• Columns: Months

• Values: Number of conversations

This should allow the user to compare Topic activity month by month without manually configuring each Topic separately.

Expected Behavior

• Users can select a primary grouping dimension.

• Users can optionally add a secondary time dimension.

• The Chart automatically generates the required time buckets.

• Existing filters and date range settings continue to apply.

• The result can be viewed using the existing Chart reporting functionality.

Acceptance Criteria

1. A secondary time dimension can be added to supported Analytics Charts.

2. Users can combine a business dimension, such as Topic, with a time grouping, such as Month.

3. The time dimension is generated automatically based on the selected date range.

4. Existing Charts without a secondary dimension continue to work without changes.

5. Existing filters and export functionality continue to work with the new grouping.