Trend analysis II

Hi Anthony, have you looked into the charting functions of IDEA or using the Visualize under the Analysis ribbon, this gives you options where you can chart different fields and make a visual representation of your output, is this what you are looking for?

 HI Brian,
 
 
I was looking into automating the process so that I can schedule this to get results. closely related to the above.
 
I want to create a report on the various trends that IDEA generates for me. For example, I analyse  unpaid invoices for three countries 
FOR EXAMPLE IN IDEA I HAVE THE BELOW DATABASE WITH RESULTS (.IMD) WITH THE NUMBER OF RECORDS IN THEM:

1. COUNTRY A - 9
2. COUNTRY B-23
3. COUNTRY C -45

These tests are done separately. I would want to store the count number in one database, so for me to do this was additional script would I need to add as I calculate the test for A, B and C?

Hi Anthony,

I am not sure exactly what you are looking for.  Are you looking for something like the code here that create a database with the filename and the number of records? http://ideascripting.com/forum/no-records-multiple-database

Yes this worked perfectly. Thanks Brian

Now I have a small challenge. how can I specify the databases I want with the number of records? I realized that in the new database i have unnecessary filenames and i want specific ones. ow would I go about it?
for Example if in my project I have employees and I run an extraction and get active employees. i would want my resultant database to only show the number of records in the resultant database (active employes with the number of reccords.

If you are using direct extraction then just exclude the filename field from the result:

Then you can create a field with the Create Fields option with the new filename:

or create a virtual field after the task has completed.