So, in an attempt to analyze data, I have a column of State that contains the two-letter abbreviation of US states.
I have a Group By node that is calculating the min/max values of this and many other fields, and my expectation was that the result would show ? when there was an instance of a missing value. However, it is not doing that.
Was my expectation wrong, or should checking the missing checkbox in the Manual Aggregation for the Maximum and Minimum produce a result that indicates missing values?
Thanks, I’ve tried it both ways, and it doesn’t appear to make a difference. I was expecting that having the box checked would include missing in the results. But it kind of appears that that may only be the case when doing an actual count or numeric function.