Hi,
I would like to create a table with the percentage of empty, out of ranges, and "Invalid format" records for all fields.
For example, on the the following table I would like to create a chart with the Dimension fields (just 2 values - Age and Children), and the value of the expresions should be:
- Empty = Age 20% // Children 20%
- Out of ranges = Age 20% (considering averything less than 10 and over 100) // Children 10% considering over 20
- Invalid format = Age 10% (considering everyhing is not numeric) // Children 10% (considering everyhing is not numeric)
Thanks in advance.
Employee | Age | Children |
Emp1 | 48 | |
Emp2 | 25 | 2 |
Emp3 | | 3 |
Emp4 | 59 | T |
Emp5 | 37 | 2 |
Emp6 | | 2 |
Emp7 | 22 | 3 |
Emp8 | £$ | 55 |
Emp9 | 48 | 2 |
Emp10 | 1991 | 1 |