|
AVImark Forum :: Shared Information Searches |
|
|
|
|
|
Subject :More Search Requests..
02-09-2012 01:44:15
|
|
|
| Terina |
|
| Advanced User |
 |
Joined: 06-09-2009 04:32:31
Posts: 238
Location: Poland, Maine |
|
|
|
I'm sorry, but I am horrible at creating new searches! Are any of these available searches that I could run? Thank you!
Average number of annual visits per pet
Average number of pets per active clients
Number of active clients (current)
Average number of pets seen by Dr (daily) |
IP Logged
|
|
|
|
|
|
|
Subject :Avg Number of Annual Visits per Pet..
02-13-2012 02:51:43
|
|
|
| Information Search Ideas |
|
| Advanced User |
|
Joined: 10-11-2010 09:14:32
Posts: 72
Location: |
|
|
|
Terina
Avg Number of Annual Visits per Pet – This search will find and report how many patients were in the clinic for the time period that is listed; and it will also report how many visits each patient had.
(The visits are calculated by how many days the patient had medical history during the time frame)
To find the Average:
• Preview print the report
• Go to the last page
• Divide the number listed below the “Number of Visits” column by the number listed below the “Counting” column.
search [Client] code 'M$BB0752' name 'Avg Number of Annual Visits per Pet'
category 'MSS Searches' (
[Client-Codes] does not contain 'i' and
[Patient-Codes] does not contain 'd,m,h,i' and
[History-Date] is between '01-01-11' '12-31-11'
) report (
[Patient-Record Number] caption 'Patient Record Number' width 17,
[Patient-Name],
[History-Date] caption 'Number of Visits' width 15 summary (distinct),
[Patient-Record Number] caption 'Counting Column' width 15 summary (distinct)
) sort by (0 ascending) summarize by sort order |
|
IP Logged
|
|
|
|
|
|
|
Subject :Average Number of Pets per Active Client..
02-13-2012 03:20:43
|
|
|
| Information Search Ideas |
|
|
| Advanced User |
|
Joined: 10-11-2010 09:14:32
Posts: 72
Location: |
|
|
|
The following search will report the Average Number of Pets per Active Client.
After running the search:
- Preview print the report
- Go to the last page
- Under the Patient Count column the average number of pets per active client will be listed.
search [Client] code 'M$BB0753' name 'Avg Number of Pets per Active Client'
category 'MSS Searches' (
[Client-Codes] does not contain 'i' and
[Client-Patient Count] is greater than '1'
) report (
[Client-Account],
[Client-Patient Count] width 15 summary (average)
) sort by (0 ascending) |
|
IP Logged
|
|
|
|
|
|
|
Subject :Number of Active Clients (per Company)..
02-13-2012 03:35:29
|
|
|
| Information Search Ideas |
|
|
| Advanced User |
|
Joined: 10-11-2010 09:14:32
Posts: 72
Location: |
|
|
|
The following search will display the number of active clients per company.
To determine active status, it reviews client action codes, and only counts clients who have at least one active patient.
search [Client] code 'M$BB0754' name 'Number of Active Clients'
category 'MSS Searches' (
[Client-Codes] does not contain 'i' and
[Client-Patient Count] is greater than '1'
) report (
[Client-Company] caption 'Company Number' width 15,
[Client-Account] caption 'Active Clients' width 15 summary (distinct)
) sort by (0 ascending) summarize by sort order |
|
IP Logged
|
|
|
|
|
|
|
Subject :Re:More Search Requests..
02-13-2012 06:29:10
|
|
|
| Terina |
|
|
| Advanced User |
|
Joined: 06-09-2009 04:32:31
Posts: 238
Location: Poland, Maine |
|
|
|
|
Thank you so much! |
|
IP Logged
|
|
|
|
|
|
|
Subject :Re:More Search Requests..
02-13-2012 06:53:35
|
|
|
| Information Search Ideas |
|
|
| Advanced User |
|
Joined: 10-11-2010 09:14:32
Posts: 72
Location: |
|
|
|
|
Your Welcome |
|
IP Logged
|
|
|
|
|
|
|
Subject :Average Number of Pets Seen by Doctor Daily..
02-13-2012 07:02:12
|
|
|
| Information Search Ideas |
|
|
| Advanced User |
|
Joined: 10-11-2010 09:14:32
Posts: 72
Location: |
|
|
|
Average Number of Pets Seen by Doctor Daily:
The following report is run per doctor.
Enter Dr ID on the search criteria tab.
Once the search is ran, do the following to arrive at the average number:
- Results, Print, then Preview
- Go to the last page
- Divide the number listed under the "Patient Count" column by the number listed under the "Day Count" column.
search [Client] code 'M$BB0755' name 'Avg Number of Pets Seen by Doctor Daily'
category 'MSS Searches' (
[History-Doctor ID] equals 'ENTER DR ID HERE' and
[History-Date] is between '01-01-11' '01-07-11'
) report (
[History-Date],
[Patient-Record Number] caption 'Patient Count' width 15 summary (distinct),
[History-Date] caption 'Day Count' width 15 summary (distinct)
) sort by (0 ascending) summarize by sort order |
|
IP Logged
|
|
|
|
|
AVImark Forum 
