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 <[email protected]> To: [email protected] 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 <[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 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
