Data quality check summary

Question

I have a double metric which contains sales numbers. i want to show a summary of the data quality as there are some 0's and nulls which should not be there? is there a neat way of me showing this? I did a summary by grouping by sales and doing a count but there are too many sales numbers to do that.

Kurohits · Answer

Check out my solution. Hope this helps.

Let me know if it is not making you sense.

If yes, then please accept it as solution. Thanks !!

Data Quality Check.yxmd

Sammy22 · Answer

and a% of total would be good as well

group a  - count - % of tot

null        - 2         - 17%

0            - 3        - 25%

double  - 7         - 58%

mceleavey · Answer

@Sammy22 ,

I don't really understand what you're trying to do, but if you simply want to remove nulls and 0 values, or isolate them and count them you can simply use a filter:

You can then apply a count to those records:

I don't know what "double" is as that's not in your data.

If you want to count instances of values within each group you can simply apply a group in the sum tool, group by the letter field (1 in my example)

M