🍉 Meet Flexmonster Pivot Table & Charts 2.9.Check out all hot features!
Get Free Trial

Count aggregation renders empty cells instead of zeros

Projet TCD asked on January 11, 2019
  • Version: Pivot Table for JSON data sources 2.6.11 (Jan 02, 2019)
  • Browser: Chrome 71.0.3578.98 on MacOS 10.14.1
  • Link to reproducehttp://jsfiddle.net/rj53sv0e/
  • Steps to reproduce:
    • Display pivot table
    • Check that cell (2-4) in “Distinct Count of Group” is 0
    • Double click cell (2-4) and check that in the Details there are no results and “Distinct Count of Group” is 0
    • Check that cell (3-4) in “Count of Group” is empty
    • Double click cell (3-4) and check that in the Details there are no results and “Count of Group” is empty
  • Observed behavior:
    • Aggregations “Distinct Count” and “Count” return different values when there are no matching results in the dataset (0 and empty respectively), both on the pivot table and the Details view.
  • Expected behavior:
    • Aggregations “Distinct Count” and “Count “should return the same value (0) when there are no matching results in the dataset, both on the pivot table and the Details view.
      • 0 (zero) should be the proper value to keep the cell type consistent (numeric, also in Excel export)
  • Notes:
    • Observed behavior also applies when grouping, on sub-totals by column or row
    • There are no trace in Chrome JS console
  • Workaround:
    • Creating a new cell format with “Null value” set to 0 for that Measure can prevent the issue visually. However data type consistency is broken, since the “Null value” “0” is considered a string (hence, the Excel export is also inconsistent, as those cells could have a wrong type alert). 

2 answers

Tanya Gryshko Tanya Gryshko Flexmonster January 11, 2019

Thank you for reporting this issue. We were able to reproduce it on our side.
Our development team will fix it and release the update on February the 11th.
Please let us know in case of other questions.

Dmytro Zvazhii Dmytro Zvazhii Flexmonster February 12, 2019

We are glad to inform you that the latest version of the component has already been released.
It also includes a bug fix.
You are welcome to update the component and try it.

Please login or Register to Submit Answer