Kind of off topic, but I had an rfe for this that was not considered (RFE0007086):
http://arswiki.org/bugs/show_bug.cgi?id=16 Summary: Ability to perform grouping and aggregates - table fields The gist of the enhancement request was the ability to perform aggregates inside table fields; being of two parts - (1) grouping and (2) aggregate column(s) (count, sum, max, min, stddev, avg, etc.). SQL-99 defines both grouping and aggregates as part of it's standard: http://www.cs.ualberta.ca/~yuan/logicsql/logicsql.html#SEC9 If you have a business/use case for such a capability, please state it in this thread or on the bugzilla entry. It can't hurt. Axton Grams On 4/2/07, Reiser, John J <[EMAIL PROTECTED]> wrote:
** Lisa, You can get counts ( distinct and totals) by sorting, grouping and using the statistics on the ARSystem report section of the user tool. To get a distinct list as a report do not select any fields. Go straight to the Sort tab and sort on your field of choice and select the Group checkbox. Next using the Statistics tab you can enter the operation, you want count. In the Label field you will need to type in the field name with $'s. You can find the field name in the Compute on dropdown. It will be the field name you used for the Sort operation. Also make sure you select that filed name in the Compute on dropdown. Add it to the report with the Add Before button and save your report. When run against your form you will get a distinct list of the sorted field. Example Form A has records ID Location 0001 North 0002 North 0003 East 0004 South 0005 West 0006 Giraffe Your report sort will be on Location and grouped The Statistics operation will be count and the Label will be $Location$ : (the space and colon : separates the count from your locations.) So your report will be East :1 Giraffe :1 North :2 South :1 West :1 HTH, John J. Reiser Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa Sent: Monday, April 02, 2007 12:45 PM To: [email protected] Subject: Distinct Counts ** A customer would like to run reports on his form that includes distinct counts. In SQL this is easy (Select Building, count(Area_Code) from PBX_COST_MASTER group by building). How can I get this data extracted from a Form in Remedy? We do not have Crystal Reports yet (would that help?) We are using Remedy 6.3 patch 21. __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
