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.
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:
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.