The number of rows in the dataset and the table widget is different

Question

Hi All,

I have a dataset of 170300 rows, when I implemented it in the table widget the number of rows was 170100. I haven't used any filters in the widget table. Any help Appreciated.

Comments

I have found the solution, so when I want to implement it in the table widget. You must add all columns in the dataset of type measure and change them to attribute types. So that the number of rows in the dataset can be the same as that applied to the table widget. it worked for me.

Answer 1

Your issue could be due to an incomplete aggregation at dataset level of the measures for all the attributes available. The table instead, aggregate automatically. This could be the reason why, changing measures in attributes worked: in this way there is no aggregation left to do.