3770242 - Line chart shows breaks with no data in Optimized stories in SAP Analytics Cloud

• A line chart in a story created with the Optimized experience becomes discontinuous (breaks) when certain months have no data, resulting in a discontinuous trend.
• The chart displays data by month based on a selected dimension.
• No issue when using "Classic" stories.

SAP Analytics Cloud

1. Log into SAC System
2. Create an ODE story,
3. Add a line chart with a time dimension on the x-axis (for example, month) and a measure on the y-axis.
4. Add a dimension to the Color binding of the chart:
   >> View the chart and observe that the Line Chart has been discontinued where months have no data.

In optimized stories, when a dimension is bound to Color, the default "ungrouped” color axis can return null entries and cause line breaks for months without data.

1. Log into SAC System
2. Open the ODE story.
3. Select the affected line chart.
4. Click on the (°°°) -> "More Options" 
5. Select "Group Color Axis": to emulate the behavior in their classic charts.
6. Save and re-view the chart:
   >> The line remains continuous across months with no data.

Note: 

• When the behavior is ungrouped, additional null datapoints are returned in the result set, which causes the line to render in a disconnected form.
  In the ungrouped case, the data can be:

=> Which will cause the line to be interrupted at 2025.07.

• In the grouped case, the data will be:

=> Which will not interrupt the line between 2025.06 to 2025.08.

• Main Action/Context Menu Options (Optimized Story Experience)
• KBA: 2984649 - Chart Legends not displaying items in sorted order in SAP Analytics Cloud (SAC) - SAP for Me 

Sac, ODE, Optimized story experience, Line, Chart, Discontinuous, Missing, Date, Data, Months, Null, Values, Zero, Color, Settings, Binding, Group, Axis, Ungrouped, Time, Series, Gaps, Option, Detail, Configuration, Styling, Panel, Builder. , KBA , LOD-ANA-DES-CHART , SAP Analytics Cloud core charting , LOD-ANA-DES , Story Design & Visualizations , Problem