Skip to main content

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 Sun, 04/16/2023 - 07:54

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 Tue, 08/08/2023 - 05:19

 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 

  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?

Anthony.Kariuki Fri, 10/13/2023 - 05:10

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 Fri, 10/13/2023 - 13:28

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.