Columns and Total Chart in breakdown type widget show different values and not in sync


Description

Breakdown type widget with 'Columns and Total' visualization is showing different quarters on selecting time series "By fiscal quarter SUM". The values on total chart line are not matching with the columns under the line.

Steps to Reproduce

1. From Performance Analytics > Widgets > New create a new widget with the configuration below:
  Type: Breakdown
  Visualization: Columns and Total
  Sort on: Value
  Sort by: Descending
  Time series: By fiscal quarter SUM
  Indicator: Number of open incidents (Select any indicator with breakdowns)
  Breakdown: Priority
2. Set additional configuration: Date Settings 1year; Show date range selector enabled/checked.
3. Submit.
4. Add this widget to a dashboard.
5. Go to [PA Incident] Historic Data Collection job > Update the relative start interval to 60 months ago.
6. Execute the job.
7. Open the dashboard with the breakdown type widget. The values on total chart line and column are not matching. Total chart line shows Q3, where as columns below that point shows Q2 values. Total chart line is misleading as it shows until Q5.

Workaround

After carefully considering the severity and frequency of the issue, and the cost and risk of attempting a fix, it has been decided to not address this issue in any current or near future releases. We do not make this decision lightly, and we apologise for any inconvenience.


Related Problem: PRB1326671