Character Field Statistics in IDEA V 10.3 - # of Blanks

 

IDEA V 10.3 now provides Character Field Statistics in addition to the existing Numeric, Date and Time Field Statistics.

 

Character Field Statistics auto reveal Blank character fields as well as the count of unique value categories in the character fields.

 

So let's say you have imported a 'Customer Complaint Resolution' database into IDEA. Now one of the fields in the database is 'Action Taken Comment'. You would like to look for blanks in comments on action taken.

 

If you go to Field Statistics and look at # of Blanks for the field 'Action Taken Comment', you can get a ready count display, drill down and file save of blank comments on action taken against complaints. This will reveal interesting insights for blank comments against closed / solved complaints, particulars users, specific locations and given complaint categories.

 

Character Field Statistics is another user friendly feature introduced by CaseWare Canada to make the IDEA usage experience fun. Till this time users would look for blank fields by writing conditions in the Equation Editor as Field Name = "" or @isblank(FieldName) through a Direct Extraction or Criteria. Character Field Statistics make the feature more accessible to a larger user audience through simple single click steps in IDEA which is non-code based and easy to apply by first time users of IDEA.

 

Regards

 

Group Administrator