Thanks Axton, I will update the thread. This is not the first time I needed to see this in a table. There have been multiple times that I would have loved to get a Distinct table on my forms.
-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Axton Sent: Monday, April 02, 2007 6:56 PM To: [email protected] Subject: Re: Distinct Counts 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" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
