[Bug Report] Running Totals should not result in empty cells when data is missing

posted on July 8th, 2020

Resolved

Projet Data asked on July 8, 2020

Version: Pivot Table for JSON data sources v2.8.10
Browser: Chrome Version 83.0.4103.116 on Windows 10
Link to reproduce: https://jsfiddle.net/48r9mx1c/
Steps to reproduce:
- Open attached JSFiddle
- See in the JSON data that:
  - There is no data for country "BE" on dates "07/05/2012" and "09/05/2012"
  - There is no data for country "FR" on date "08/05/2012"

Observed behavior:
- Cells 3:3; 3:5 and 4:4 are empty (see attached screencap)

Expected behavior:
- Cells 3:3; 3:5 and 4:4 should carry over the value of the left cell (or add 0, since there is no corresponding data) i.e. have the values 1, 2 and 2 respectively

More details:
- While this behavior may be fine for aggregations like "sum" or"count" (for which it can be circumvented by using a formula with "if(..., ..., 0)"), this isn't fitting for both "runningtotalsofrow" and "runningtotalsofcolumn"
- Also happens when "runningtotalsofrow" or "runningtotalsofcolumn" are used in a formula, whether or not the calculation is done to individual values, which makes the formula possibly wrong in some cases

Attachments:
report.png

5 answers

Public

Illia Yatsyshyn ⋅ Flexmonster ⋅ July 8, 2020

Hello,

Thank you for reporting the issue and for providing such a detailed explanation.

The fix is going to be provided with a minor update ETA Aug 11.
Our team will notify you as soon as the version with a fix is available to download.

Please let us know in case other questions appear.

Best regards,
Illia

Public

Illia Yatsyshyn ⋅ Flexmonster ⋅ August 11, 2020

Hello,

We are glad to inform you that the issue with calculating runningtotalsofrow and runningtotalsofcolumn aggregation with nonexistent values was fixed.
This is included in the 2.8.13 version of Flexmonster.

You are welcome to update the component.
Here is our updating to the latest version guide for assistance.

Please let us know if it helps.
Do not hesitate to contact us in case any questions arise.

Best regards,
Illia

Public

Illia Yatsyshyn ⋅ Flexmonster ⋅ August 19, 2020

Hello,

Please let us know whether the fix of runningtotalsofrow and runningtotalsofcolumn aggregations' behavior helped.

We are looking forward to your feedback.

Kind regards,
Illia

Public

Projet Data ⋅ September 17, 2020

Hello Illia,
The issue was fixed, thank you very much.
However I have a follow-up question: is there any plan to introduce a configuration on measures based on runningtotalsof* to allow cross-group calculation? i.e. keep calculating a running total across multiple nested hierarchies instead of resetting on each one?
I've read the workaround on https://www.flexmonster.com/question/running-totals-reset/ but it would be interesting to have the possibility to calculate the running total over multiple years for example, while giving the users the freedom to visualize nested values dynamically, in whichever way they want (else we have to create an artificial combinaison of Year-Month, Year-Quarter, Year-Quarter-Month, Month-Day, etc... that just pollute the list of fields)

Public

Illia Yatsyshyn ⋅ Flexmonster ⋅ September 18, 2020

Hello,

Thank you for your feedback and for sharing your ideas with us.

We agree that it would be useful to have the possibility to keep calculating a running total across multiple nested hierarchies.
However, our roadmap is full at the moment. We will add the described feature to our backlog. Our team will notify you if something is changed on this matter.

Do not hesitate to contact us in case any other questions arise.

Best regards,
Illia

[Bug Report] Running Totals should not result in empty cells when data is missing

5 answers

Please login or Register to Submit Answer