### Find the average value from the Top 5 of that value

That weird “UserToSubject” is a phrase and not a valid table name.  >> I have a requirement to find ...
| 5 Replies | 3431 Views | Created by Corby Nichols - Thursday, May 24, 2012 11:03 PM | Last reply by --CELKO-- - Saturday, May 26, 2012 3:37 AM

### Sort by top 5% for Top 5 largest values

trying to pull the Top 5 largest values from the Principal.  I need to do it for each year that is displaying.  Some may have up to 20 or 30 years.  ...
| 15 Replies | 1051 Views | Created by g_cat - Wednesday, July 17, 2019 10:23 PM | Last reply by Mitarai Queen - Wednesday, August 14, 2019 3:18 AM

### average values of per 5 rows

of each group of 5 rows (i.e. the third value in each group), you can modify the above like this:
| 13 Replies | 4167 Views | Created by mech3 - Thursday, January 1, 2009 9:36 PM | Last reply by Manivannan.D.Sekaran - Monday, January 5, 2009 8:34 AM

### Getting every other 5-minute average value...

] as float)))/5), 0), 108)        as Interval,        avg([value]) as [average ...
| 1 Replies | 5635 Views | Created by remedios_ - Friday, February 1, 2008 9:03 AM | Last reply by Kent Waldrop _ - Friday, February 1, 2008 12:31 PM

### Eliminating Top/Bottom 5% of values then averaging what's left

"hours".  I want to be able to exclude the top/bottom 5 % of the hours values in order to calculate the average of what's ...
| 5 Replies | 3907 Views | Created by N. Edmonds - Wednesday, July 22, 2009 6:07 PM | Last reply by N. Edmonds - Wednesday, July 29, 2009 5:29 PM

### Get top 5 column values

) , rnk as ( select *, row_number() over ( partition by MemberName order by val desc) as RowNum from bse ) select MemberName, Sum(Val) as ...
| 1 Replies | 269 Views | Created by nextwarren - Monday, June 6, 2016 4:01 PM | Last reply by Russ Loski - Monday, June 6, 2016 4:09 PM

### Average of Previous values

But I want to add some additional code in my procedure like AVERAGE of Previous 5 Price Values.
| 2 Replies | 4398 Views | Created by sameer18 - Friday, May 9, 2008 7:41 AM | Last reply by Pramono - Wednesday, May 14, 2008 5:02 AM

### How to find the Average in a Calculated Member with filtered Values?

Hi to you all, I currently trying to Implement a Calculated Member (SSRS or SSAS ) which would Show me the Average Values per Customer, i hereby Need to devide the ...
| 2 Replies | 1766 Views | Created by gbobj - Tuesday, July 23, 2013 12:31 PM | Last reply by Alan Koo - Tuesday, July 23, 2013 8:35 PM

### Question on finding top 5

Summary of Top 5 Status Control records linked to Problems. This set is throwing me
| 1 Replies | 2390 Views | Created by Satish Bobba - Thursday, July 28, 2011 3:49 PM | Last reply by Satish Bobba - Thursday, July 28, 2011 4:30 PM

### Finding the top 6 values in a column

The simplest way will be to give every result a number using row_number() function. This way youl easily can highlight top 6 results. For every expert
| 2 Replies | 2839 Views | Created by pauldevinedotnet - Monday, November 21, 2011 1:05 AM | Last reply by pauldevinedotnet - Monday, November 21, 2011 1:46 AM

### Calculate average daily value

month): Month | AvgValue 201001 22,5 201002 125 And againt when I look on year level, the value should also be calculated from ...
| 5 Replies | 8505 Views | Created by Matej Golob - Friday, May 28, 2010 7:55 AM | Last reply by Okshilato1 - Friday, May 28, 2010 5:47 PM

### getting an average but not including top and bottom 5%

of the 1 and 20 in our sample, leaving only the 7, 8, and 9.  And the average of those is 8. (However, if you average ALL 5 values, you get ...
| 18 Replies | 4273 Views | Created by c0pe - Friday, August 28, 2009 8:32 PM | Last reply by c0pe - Monday, August 31, 2009 7:04 PM

### How to Average a column of field values

In the formula for my y axis values in a graph of monthly counts, I set it to sum the values. However, in a graph of average numbers per month, shouldn't ...
| 0 Replies | 6338 Views | Created by MichaelMiller - Tuesday, February 21, 2006 9:33 PM

### get an average value with filters

a measure to get an average value of the backup_size column but with filters depending on the server name and maybe the database name i tried ...
| 4 Replies | 1553 Views | Created by Alen Teplitsky - Wednesday, July 17, 2013 2:21 PM | Last reply by Alen Teplitsky - Thursday, July 18, 2013 2:06 PM

### Average of values from different tables

Hi All, I want to take the average of 3 values from three different tables (M,C and T) that I'm joining together, this is a part from my ...
| 8 Replies | 2473 Views | Created by Mona Fathy - Sunday, May 20, 2012 2:21 PM | Last reply by Mona Fathy - Tuesday, May 22, 2012 12:43 PM

### Sum Average values

There is no change for your measure value, because scope for each attributes just like using measure expression and named column. It will try to calculated from the lowest ...
| 7 Replies | 4504 Views | Created by Qute - Friday, January 22, 2010 9:42 PM | Last reply by Raymond-Lee - Thursday, January 28, 2010 4:59 AM

### Rolling Averages of integer values

AS varchar(128)) RETURNS INT AS BEGIN DECLARE @AvgValue int; IF @FiledName = 'Value1' BEGIN SELECT @AvgValue = ...
| 18 Replies | 616 Views | Created by Abhinav530 - Monday, January 12, 2015 1:20 AM | Last reply by Guoxiong - Monday, January 12, 2015 5:39 PM

### Need conditional average of values

Hi, I have report table having one column EmployeeGrade which holds data on different questions. I wanted  conditional averaging the column ...
| 3 Replies | 3048 Views | Created by Sonu888 - Thursday, May 31, 2012 5:28 PM | Last reply by Syed Qazafi Anjum - Friday, June 1, 2012 4:27 AM