I created a Pivot Table that's supposed to count how many orders an employee can pack in a day, separated by size. Unfortunately, the PivotTable doesn't show the same data from the entity itself.
Using Count by Packer gives the correct data I was looking for. This approach never crossed my mind, Thank you.
I also find it strange that it doesn't count properly using the tracking number field. Could it be because I copied this field from a different entity?
I sometimes encounter weird behaviours when I use Copy Fields; like how it would also copy the Records Visibility rule from the original Entity into the Entity it was pasted on. But the rule will not appear on the pasted Entity so I can't delete it and had to copy the field manually to avoid those issues.