Hi, >I must be missing or misunderstanding something. I can use the sum function >to get a total cost and display the results. But I think I'm having trouble >understanding the purpose of the count function. Example: I have a database >with 100 records. In one field there are eight different values. I am >trying to count the number of occurrences for each value. When I use the >count function it returns 8 in the resultset.
Then you want to do a "Summary of Groups" search. Drag TWO columns into the search action's Select Columns list. One of the columns should be the column with the eight different values. Once that column is in the Select Columns list, drag it to the Group By list as well. Notice that the Function for that column in the Select Columns list will change to "None". Change the Function for the other column (it really doesn't matter too much which other column you choose) to "Count". Switch to the results HTML for the action and enter: <@VAR resultSet> If you check the Columns folder in the Snippets tab of the Workspace, you should see two column meta tags. They should be something like: <@COLUMN "COUNT(DISTINCT myTable.myOtherColumn)"> <@COLUMN "myTable.myGroupingColumn"> HTH. Eric >-----Original Message----- >From: Eric Weidl [mailto:[EMAIL PROTECTED]] >Sent: Tuesday, May 14, 2002 10:34 AM >To: Multiple recipients of list witango-talk >Subject: Re: Witango-Talk: Search Actions > > >Hi, > > >I have gone through the documentation and cannot find how to return the > >results after performing a search action with a select type of "Summaries >of > >Groups" or "Summary of All Rows". Will someone please point me in the >right > >direction. > >The same way you access the results from a "normal" search action. > ><@VAR resultSet> > >will show the entire results in an HTML table. > >You can also use the Snippets tab of the Workspace to access the specific >columns. The columns will be named something like: > > <@COLUMN "MAX(myTable.myColumn)"> > >Eric > > >________________________________________________________________________ >TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] > with unsubscribe witango-talk in the message body >________________________________________________________________________ >TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] > with unsubscribe witango-talk in the message body ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
