Calculate non null, null, and completeness in the table

[deepakkrish]

Hi Team ,

Please help me to complete this task .. I got one new requirement , I have a filter called ID. When I select ID it will show the values in another table .

My table:

name	address	phone
a		87
b		88

Here we have 6 results and 2 null values , so I have to calculate overall results ,and null values and completeness based on the table ,, so my result would be

count : Overall values

null count: null value count

completeness : null values/overall count

name	address	phone	count	null	completeness
a		87	3	1
b		88	3	1
			overall 6	null 2	0.67

Thanks,

Deepak

[Arthur_Fong]

Do you have a sample app?

[deepakkrish]

I don't have a sample to share for this .. My requirement is If you have a table that how may overall values and how many nulls and completeness for the table ..

Thanks,

Deepak.

[Arthur_Fong · Accepted solution]

There you go:

I think you have mistakes in your completeness logic.

null=2

full=6

completeness = null/full = 0.333

But your result showing 0.67, so I did both.

Do check which logic suits you better.

Refer qvw attached as reference.

Thanks and regards,

Arthur Fong

[deepakkrish]

Thanks jkfong93 ..yes , Its working ..