Aggregating values for multiple records

bhargava74

Hello,<br />
I'm new so this might be a very fundamental question.<br />
<br />
I have a database which has a table with following entries:<br />
<br />
ServiceName Date ReqTm RespTm Latency FltRate TotalFlts<br />
Service1 **** 100 100 23 10 9<br />
Service2 **** 100 100 23 10 8<br />
Service3 **** 100 100 23 10 9<br />
Service2 **** 110 101 28 11 11<br />
Service2 **** 180 108 29 19 9<br />
Service1 **** 100 100 23 10 9<br />
<br />
I want to report out the average RequestTm, RespTm, Latency, FltRate for each service and also some sums of Total Flts(per service again) . something like<br />
<br />
ServiceName Ave.ReqTm Ave.RespTM Ave.Lat Ave.FltRate TotalFlts<br />
Service1<br />
Service2<br />
Service3.....etc<br />
<br />
<br />
is this doable? how easy is it?<br />
<br />
<br />
Regards<br />
<strong class='bbc'>B</strong>

mwilliams

Hi B,

All you have to do is use aggregations and groups to do what you're looking for. Take a look at the attached report design. Be sure to change the file path in the dataSource to where you saved the .txt file or it won't run. To get just the averages, you just need to delete the detail row of the table. Let me know if you have questions.