Cisco Systems OL-24201-01 Camera Accessories User Manual


 
13-57
User Guide for Cisco Secure Access Control System 5.3
OL-24201-01
Chapter 13 Managing Reports
Organizing Report Data
MONTH(date, option) Displays the month of a specified date-and-time
value, in one of three optional formats:
1 - Displays the month number of 1 through 12.
2 - Displays the complete month name in the
user’s locale.
3 - Displays the abbreviated month name in the
user’s locale.
MONTH([Semester], 2)
MOVINGAVERAGE
(expr, window)
Displays an average value over a specified window,
such as an average price or volume over a number
of days.
MOVINGAVERAGE([Price],
[Days])
NOTNULL(value) For a specified column, displays True if a data value
is not empty. Displays False if a data value is empty.
NOTNULL([DepartmentID])
NOW( ) Displays the current time stamp.
NOW([PastDueDate])
OR The logical OR operator. This function is used to connect clauses in
an expression and does not take
arguments.
PERCENTILE(expr, pct) Displays a percentile value, a value on a scale of
100 that indicates the percent of a distribution that
is equal to or below the specified value.
Valid pct argument ranges are 0 to 1. 0 returns the
minimum value of the series. 1 returns the
maximum value of the series.
PERCENTILE([Rank], 1)
PERCENTILE(expr, pct,
groupLevel)
Displays a percentile value for the expression at the
specified group level.
Valid pct argument ranges are 0 to 1. 0 returns the
minimum value of the series. 1 returns the
maximum value of the series.
PERCENTILE([Income], 60, 1)
PERCENTRANK(expr) Displays the percentage rank of a value.
PERCENTRANK([TestScores])
PERCENTRANK(expr,
groupLevel)
Displays the percentage rank of a value at the
specified group level.
PERCENTRANK([TestScores], 2)
PERCENTSUM(expr) Displays a value as a percentage of a total.
PERCENTSUM([OrderTotals])
PERCENTSUM(expr,
groupLevel)
Displays a value as a percentage of a total at the
specified group level.
PERCENTSUM([OrderTotals], 3)
QUARTER(date) Displays the quarter number, from 1 through 4, of a
specified date-and-time value.
QUARTER([ForecastCloseDate])
QUARTILE(expr, quart) Displays the quartile value, where the quart
argument is an integer between 0 and 4.
QUARTILE([OrderTotal], 3)
QUARTILE(expr, quart,
groupLevel)
Displays the quartile value for the expression at the
specified group level, where the quart argument is
an integer between 0 and 4.
QUARTER([OrderTotal], 2, 3)
Table 13-11 Examples of Functions (continued)
Function Description Example of use