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 > > ************************************************************* > 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:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
