Cisco Acs 5x User Guide

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,...

13-58
User Guide for Cisco Secure Access Control System 5.3
OL-24201-01
Chapter 13      Managing Reports
  Organizing Report Data
RANK(expr) Displays the rank of a number, string, or 
date-and-time value, starting at 1. Duplicate values 
receive identical rank but the duplication does not 
affect the ranking of subsequent values.RANK([AverageStartTime])
RANK(expr, ascending, 
groupLevel)Displays the rank of a number, string, or 
date-and-time value in either ascending or 
descending order, at the...

13-59
User Guide for Cisco Secure Access Control System 5.3
OL-24201-01
Chapter 13      Managing Reports
  Organizing Report Data
TRIM(str) Displays a string with all leading and trailing blank 
characters removed. Also removes all consecutive 
blank characters. Leading and trailing blanks can be 
spaces, tabs, and so on.TRIM([customerName])
TRIMLEFT(str) Displays a string with all leading blanks removed. 
Does not remove consecutive blank characters.TRIMLEFT([PortfolioName])
TRIMRIGHT(str) Displays a...

13-60
User Guide for Cisco Secure Access Control System 5.3
OL-24201-01
Chapter 13      Managing Reports
  Organizing Report Data
Understanding Supported Operators
Table 13-12 describes the mathematical and logical operators you can use in writing expressions that 
create calculated columns.
Using Numbers and Dates in an Expression
When you create an expression that contains a number, you must type the number according to the 
conventions of the US English locale. In other words, use a period (.), not a...

13-61
User Guide for Cisco Secure Access Control System 5.3
OL-24201-01
Chapter 13      Managing Reports
  Organizing Report Data
Using Multiply Values in Calculated Columns
To use multiply values in calculated columns:
Step 1Select a column. In the report, the new calculated column appears to the right of the column you select. 
Step 2Select Add Calculation. 
The Calculation dialog box appears.
Step 3In the Column Label field, type a header for the calculated column.
The header must start with a letter...

13-62
User Guide for Cisco Secure Access Control System 5.3
OL-24201-01
Chapter 13      Managing Reports
  Organizing Report Data
Step 7For the second argument, type the number of days to add. In this case, type 7.
Step 8Validate the expression, then click Apply.
The new calculated column appears in the report. For every value in the Order Date column, the 
calculated column displays a date seven days later than the order date.
Subtracting Date Values in a Calculated Column
You can display the difference...

13-63
User Guide for Cisco Secure Access Control System 5.3
OL-24201-01
Chapter 13      Managing Reports
  Organizing Report Data
Figure 13-39 Aggregate Row for a Group
Table 13-13 shows the aggregate functions that you can use.
Table 13-13 Aggregate Functions
Aggregate functions Description
Average Calculates the average value of a set of data values.
Count Counts the data rows in the column.
Count Value Counts distinct values in the column.
First Returns the first value in the column.
Last Returns the...

13-64
User Guide for Cisco Secure Access Control System 5.3
OL-24201-01
Chapter 13      Managing Reports
  Organizing Report Data
Creating an Aggregate Data Row
To create an aggregate data row:
Step 1Select a column, then select Aggregation.
The Aggregation dialog box appears. The name of the column you selected is listed in the Selected 
Column field.
Step 2From the Select Function menu, select the function you want to use.
The available functions depend on the type of data the column contains:
If the...

13-65
User Guide for Cisco Secure Access Control System 5.3
OL-24201-01
Chapter 13      Managing Reports
  Organizing Report Data
Adding Additional Aggregate Rows
After you create a single aggregate row for a column, you can add up to two more aggregate rows for the 
same column. For an item total column, for example, you can create a sum of all the values, count all the 
values, and get the average order total.
To add an aggregate row:
Step 1Select a calculated column that contains an aggregate row,...

13-66
User Guide for Cisco Secure Access Control System 5.3
OL-24201-01
Chapter 13      Managing Reports
  Hiding and Filtering Report Data
Deleting Aggregate Rows
To delete an aggregate row:
Step 1Select the calculated column that contains the aggregation you want to remove, then select Aggregation.
The Aggregation dialog box appears, displaying all the aggregations for the column. 
Step 2For the aggregation you want to remove, choose Delete Aggregation, then click Apply.
Hiding and Filtering Report...