Dear visitor, despite all the challenges, our team continues operating at full speed.

We are ready to help with any questions you may have. Please fill out this quick form and we'll get back to you.

Fill the form
Get Free Trial

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

Answered
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

1 answer

Public
Illia Yatsyshyn 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

Please login or Register to Submit Answer