I am wondering why AVG would be a better statistics as opposed to MAX which 
would be more useful for sizing purposes..

Joe



________________________________
From: Thad K Esser <tkes...@regence.com>
To: arslist@ARSLIST.ORG
Sent: Wed, October 7, 2009 12:27:44 PM
Subject: Re: Advanced Search Question

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 <jha...@gmail.com>                                                    
                                                                    |
  
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|------------>
| To:        |
|------------>
  
>--------------------------------------------------------------------------------------------------------------------------------------------------|
  |arsl...@arslist.org                                                          
                                                                    |
  
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|------------>
| Date:      |
|------------>
  
>--------------------------------------------------------------------------------------------------------------------------------------------------|
  |10/07/2009 09:15 AM                                                          
                                                                    |
  
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|------------>
| Subject:  |
|------------>
  
>--------------------------------------------------------------------------------------------------------------------------------------------------|
  |Re: Advanced Search Question                                                 
                                                                     |
  
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|------------>
| Sent by:  |
|------------>
  
>--------------------------------------------------------------------------------------------------------------------------------------------------|
  |"Action Request System discussion list(ARSList)" <arslist@ARSLIST.ORG>       
                                                                     |
  
>--------------------------------------------------------------------------------------------------------------------------------------------------|





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 <john.kel...@dunkinbrands.com> 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


     
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
 

Reply via email to