Its not an advanced search, but if its a one time thing, SQL works:
select avg(length(Detailed_Decription)) from hpd_help_desk
note: yes the db name of the field is missing the 's' in description.
*sigh*
Thad Esser
Remedy Developer
"Now... Just where did I put that cheese...?"
|------------>
| From: |
|------------>
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|jham36 <[email protected]>
|
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|------------>
| To: |
|------------>
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|[email protected]
|
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|------------>
| Date: |
|------------>
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|10/07/2009 09:15 AM
|
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|------------>
| Subject: |
|------------>
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|Re: Advanced Search Question
|
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|------------>
| Sent by: |
|------------>
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|"Action Request System discussion list(ARSList)" <[email protected]>
|
>--------------------------------------------------------------------------------------------------------------------------------------------------|
The only thing I can think of would be to export the data from the
notes field into excel. Then you can use the LEN function to
calculate the number of characters in the notes field for each
record. Add them up and divide by the number of records.
James
On Oct 7, 11:54 am, John Kelley <[email protected]> wrote:
> Hi List
>
> Is there any way to find out what the Average character count of the
notes
> field in Incident Management tickets which have been submitted?
>
> What and can that be run in an Advanced search statement?
> Thanks
>
> ARS 7.1 patch 6
> Oracle 10g
>
> JK
>
> *************************************************************
> This e-mail message, including any attachments, is for the sole use of
the addressee(s) to whom it has been sent, and may contain information that
is confidential or legally protected. If you are not the intended
recipient or have received this message in error, you are not authorized to
copy, distribute, or otherwise use this message or its attachments. Please
notify the sender immediately by return e-mail and permanently delete this
message and any attachments. Dunkin' Brands Inc. makes no warranty that
this e-mail is error or virus free.
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
*IMPORTANT NOTICE: This communication, including any attachment, contains
information that may be confidential or privileged, and is intended solely for
the entity or individual to whom it is addressed. If you are not the intended
recipient, you should delete this message and are hereby notified that any
disclosure, copying, or distribution of this message is strictly prohibited.
Nothing in this email, including any attachment, is intended to be a legally
binding signature.
*
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
