Get Free Trial
Get Free Trial

Count aggregation renders empty cells instead of zeros

posted on January 11th, 2019

Resolved
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 reproduce: http://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

Public
Tanya Gryshko Tanya Gryshko ⋅ Flexmonster ⋅ January 11, 2019

Hello,
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.
Regards,
Tanya

Public
Dmytro Zvazhii Dmytro Zvazhii ⋅ Flexmonster ⋅ February 12, 2019

Hello,
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.
Regards,
Dmytro

Please login or Register to Submit Answer