Advanced Search Question
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.
Re: Advanced Search Question
Hi, What you can do is to create a display-only-integer-field called 'NotesLength'. Then you create a filter that runs on GetEntry that assigns a value to this field. The value should be LENGTHC($Notes$) or some such thing. After this you create a basic AR System report that counts this field. The basic report capability in the AR System will use the API-call ARGetMultipleEntries() which makes sure that the filter is run. On the other hand, you may want to calculate this value on Submit/Modify instead, and store it in a Optional field. This will make sure that the calculation is not done when it is not needed. It is a very simple thing, so the time-difference will probably not be noticeable. Another way would be to create a View-form against your Regular form, and do the Get-entry-calculation there. This will make sure that it is not done when it is not needed. Note that in Crystal Reports you can not count on the Get Entry filter to run. The call used varies depending on the fields in the CR-report. Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia: * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. * RRR|Translator - Manage and automate your language translations. Find these products, and many free tools and utilities, at http://rrr.se. 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. -- This message was scanned by ESVA and is believed to be clean. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Advanced Search Question
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
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:| | --| |arslist@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 * 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 *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:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Advanced Search Question
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