Character Field Statistics in IDEA V 10.3 - # of Blanks

6 posts / 0 new
Last post
Brian Element's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57
Character Field Statistics in IDEA V 10.3 - # of Blanks

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
Jiyajijp
Offline
Joined: 12/08/2016 - 06:34

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

Brian Element's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57

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

Jiyajijp
Offline
Joined: 12/08/2016 - 06:34

Brain,
Is it possible to copy this distinct coutry code into a dropdown or combo box, (here 52 rows).
How will get each unique value

Lois's picture
Lois
Offline
Joined: 02/14/2013 - 09:00

Brian,
In addition to Jiyajijp's request, could the dropdown list the unique numeric values in a field?
Lois

Jiyajijp
Offline
Joined: 12/08/2016 - 06:34

I summarized the data using the column coutry, and then filled this unique value to the dropdown.