Wrangler completion percentage is wrong
See attached sample data. Apply these directives:
parse-as-csv :body ',' false
at this stage, the column body_4 has 5 empty values. This can be verified by using the directive:
filter-rows-on condition-false Zip == null || Zip == ""
However, the completion percentage is still 100%, despite these 5 empty records.
the single decimal might resolve the issue. Thank you
Here’s a screenshot, showing a couple different completion percentages:
I think couple of decimal places are fine. How would it look?
Currently, we apply ceiling or round for the completion percentage. We can remove that, but then we will show decimal completion values.
Would you like to:
Show decimal values
Use floor (always round down) so the above example would show 99%