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"