Data quality check summary

[Sammy22]

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.

[mceleavey]

Hi @Sammy22 ,

Can you share some data (mock data is fine) to show what you have and what you're trying to achieve?

M.

[Sammy22]

it's like the below but i need to summarise in a simple way.

group Sales
a 0
a 0
b 0
c 0
a 2
b 3
c 5
a 2
b 5
c 5
a 6
a null
b null
b 5
b 3
a 25
c 3
d 2

[Sammy22]

For each group i would want a simple view like this

group a  - count

null        - 2

0            - 3

double  - 7

[mceleavey]

@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

[Sammy22]

and a% of total would be good as well

group a  - count - % of tot

null        - 2         - 17%

0            - 3        - 25%

double  - 7         - 58%

[Kurohits]

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 !!