Report on Variables not filled in frequently or filled in with 'n/a', '-', '*', 'N/A' ?

[JHughes62]

Hi,

I think this is a difficult requirement to achieve but just wanted to check with the community to see if someway it was possible. 

We have a requirement to configure some sort of report or visualisation that displays what variables are left empty, infrequently used or if the variables are inputted with information like : 'N/A', 'n/a', '-', '*', etc, by the end user on the employee center.

Any help would be greatly appreciated.

[Dr Atul G- LNG · Accepted solution]

Hi @JHughes62 

It depends on the variable type. If it is string, I think we can do , with operator contains

[JHughes62]

Hi @Dr Atul G- LNG - thank you for your reply. Your idea lead us to finding a solution for this.

To get empty variables we created a report on the question_answer table and grouped by question, Question.Catalog Item [Variable] and table name, then just set the filter to value is empty.

To get a report on the variables filled in with 'n/a', '-', '*', 'N/A', etc. We created a report on the question_answer table, and grouped by question, Question.Catalog Item [Variable] and table name. We then just set the filters with contains/starts with the unnecessary answers like 'n/a', '-', '*', 'N/A', etc.