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
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.
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)
Observed behavior also applies when grouping, on sub-totals by column or row
There are no trace in Chrome JS console
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).
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