Character Field Statistics in IDEA V 10.3 - # of Blanks
Brian Element
Hello Group Members,
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
Hi Jiyajijp,
Hi Jiyajijp,
The character stats will show you the number of blanks and cattegories in for character fields, such as:
You can then click on the # of Categories number, such as the 52 to get a list of unique values for the field and then further drill down to the transactions. The # of Categories is much like the summary task.
Hope this helps.
Brian
Hi Brain,
Hi Brain,
How can we find the unique row value using this Character Field Statistic option. Do we get only count or row value..
Thanks