Trend analysis II

7 posts / 0 new
Last post
Anthony.Kariuki's picture
Anthony.Kariuki
Offline
Joined: 04/21/2017 - 05:14
Trend analysis II

I test exceptions where i get results on a daily basis. These exceptions vary on various days. For example ivoices that were not taxed
I get these results in IDEA  daily. 
Monday i have a list of 9 invoices
Tuesday  15 invoices
wednesday 70 invoices
 
How would i go about showing this trend analysis based on daily results? Trend also can be based on monthly.

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

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?

Anthony.Kariuki's picture
Anthony.Kariuki
Offline
Joined: 04/21/2017 - 05:14

 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?

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

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

Anthony.Kariuki's picture
Anthony.Kariuki
Offline
Joined: 04/21/2017 - 05:14

Yes this worked perfectly. Thanks Brian

Anthony.Kariuki's picture
Anthony.Kariuki
Offline
Joined: 04/21/2017 - 05:14

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.

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

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.