Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey,
I think this should be a relatively easy question for someone to answer...
I've loaded data into a table which I'll call "myTable", which has the fields "Field1", "Field2" and "Field3". If I create a Stats Box and set the Field to calculate on "Field2", in the "Count" field, should I not get the number of instances of the field in the table? Which is essentially the number of records/rows?
I have a case where I'm viewing a table box with all the fields in the table, and I've cleared all selections, exported the table to Excel and it shows 25,636 records... but the Count in the stats box says Count = 543,218.
Any thoughts would be appreciated.
Man, depends on your datacloud. Look for syntetic tables and see if the association between them is correct. This kind of mistake generates this kind of "Cartesian Product". You can also have a case where excel dont get all rows because a table do not show repeated rows, though the stat box count considers this rows in the calculations!
Will check. Thanks for the feedback.