Table Of Contents

Symbols - A - B - C - D - E - F - G - H - I - L - M - N - O - P - Q - R - S - T - U - V - W - X - Y -

Index

Symbols

! formatting symbol 13-34

% operator 13-61

& formatting symbol 13-34

& operator 13-61

* operator 13-61

+ operator 13-61

/ operator 13-61

<= operator 13-61

<> operator 13-61

< formatting symbol 13-34

< operator 13-61

= operator 13-61

>= operator 13-61

> formatting symbol 13-34

> operator 13-61

@ formatting symbol 13-34

- operator 13-61

A

ABS function 13-53

absolute values 13-53

accessing

data 13-67

Interactive Viewer 13-21

table of contents entries 13-23

ACS distributed deployment 17-2

ADD_DAY function 13-53

ADD_HOUR function 13-53

ADD_MINUTE function 13-53

ADD_MONTH function 13-53

ADD_QUARTER function 13-53

ADD_SECOND function 13-53

ADD_WEEK function 13-53

ADD_YEAR function 13-53

Add Group command 13-50, 13-51

adding

aggregate rows 13-65, 13-66

data filters 13-69, 13-71, 13-72, 13-73

data groups 13-49, 13-50

formatting rules 13-37, 13-38

page breaks 13-41

addition operator 13-61

administrator access setting 16-13

administrator password policy 16-10

administrator password reset 16-22

administrator roles 16-2

Advanced Filter dialog 13-73, 13-74, 13-75

Advanced Sort command 13-47

aggregate functions 13-64, 13-65

aggregate rows

creating 13-65, 13-66

formatting data in 13-30

aggregate values 13-42

Aggregation dialog 13-65

alarms 12-1

syslog targets 12-35

system alarms 12-34

alarm schedules 12-9

aligning data 13-29

alignment options 13-29

AND operator 13-61, 13-75

Any Of condition 13-69

arguments 13-52

Arrange Columns dialog 13-42

ascending sort order 13-47

AVERAGE function 13-54

Average function 13-64

averages 13-54, 13-57, 13-60, 13-64

B

background colors 13-39

Between condition 13-69, 13-74

BETWEEN function 13-54

Between operator 13-38

blank characters 13-59

Boolean values 13-55, 13-59, 13-70

Bottom N condition 13-70

Bottom Percent condition 13-70

C

calculated columns

aggregating data and 13-63, 13-65, 13-66

creating 13-52, 13-61

placing values in 13-55

Calculation dialog 13-52, 13-62, 13-63

calculations 13-42

case conversions 13-34

case-insensitive searches 13-59

case-sensitive searches 13-55

category series 13-76

cautions

description ii-xxiv

CEILING function 13-54

changing

aggregate values 13-30

chart subtypes 13-78

column headers 13-24, 13-28

conditional formats 13-38

data filters 13-73

default formats 13-28

labels 13-27

reports 13-21

character patterns 13-59, 13-71

character placeholder 13-34

charts

overview 13-76

Chart Subtype command 13-78

Cisco CAT 6K 4-23

clearing data filters 13-73

closing Standard Viewer 13-21

collapsing data groups 13-50, 13-68, 13-69

colors 13-39

column headers 13-24

column names 13-72

Column Properties dialog 13-29

columns

aligning data in 13-29

changing order of 13-42

counting rows in 13-64

deleting 13-44

determining first value in 13-55, 13-64

determining last value in 13-56, 13-64

determining type 13-32

displaying data in 13-30

formatting data in 13-37, 13-38

grouping date and time values in 13-50

resizing 13-24, 13-29

sorting data in 13-47, 13-75

Column Width command 13-29

comma-separated values files. See CSV files

comparison filters 13-71

comparison operators 13-38, 13-71

comparisons 13-37, 13-38, 13-55

concatenation operator 13-61

Conditional Formatting dialog 13-37, 13-38, 13-40

conditional formatting rules 13-37, 13-38

conditions

filtering data and 13-69, 13-70, 13-73

formatting data and 13-37

context menus 13-21

conversions 13-34

COUNT_DISTINCT function 13-54

COUNT function 13-54

Count function 13-64

Count Value function 13-64

creating

aggregate rows 13-65, 13-66

calculated columns 13-52, 13-61

data filters 13-69, 13-71, 13-72, 13-73

data groups 13-49, 13-50

formatting rules 13-37, 13-38

crud operations 7-6

CSV files 13-24, 13-25

currency 13-32

Currency format option 13-31

currency formatting options 13-32

currency symbols 13-32

Custom format option 13-31

customizing

formats 13-33

D

data

accessing 13-67

aligning 13-29

displaying 13-30, 13-42, 13-67

hiding 13-44

plotting relationships for 13-76

data filters 13-69, 13-71, 13-72, 13-73

data points 13-76

data rows 13-67, 13-68

data sections 13-68, 13-69

data sets 13-42, 13-64, 13-67, 13-76

data sources 13-25, 13-32, 13-47, 13-67

data types 13-32

Date and Time Format dialog 13-35

date calculations 13-63

date data types 13-31

date expressions 13-61, 13-63

date formats 13-31, 13-35

Date or Time Column Format dialog 13-36

date values 13-35, 13-50, 13-54

DAY function 13-54

decimal values 13-32

default formats 13-28, 13-29

default network device 7-17

deleting

columns 13-44

conditional formats 13-40

data filters 13-73

filter conditions 13-75

page breaks 13-41

delimited text files 13-24, 13-25

descending sort order 13-47

designs

hiding data in 13-67

organizing data in 13-42

saving 13-26

DIFF_DAY function 13-54

DIFF_HOUR function 13-54

DIFF_MINUTE function 13-54

DIFF_MONTH function 13-54

DIFF_QUARTER function 13-54

DIFF_SECOND function 13-54

DIFF_WEEK function 13-54

DIFF_YEAR function 13-54

displaying

data 13-30, 13-42, 13-67

detail rows 13-68

reports 13-20

specific report pages 13-22, 13-23

table of contents 13-23

distinct values 13-54, 13-64

division 13-57, 13-61

division operator 13-61

downloads 18-40

duplicate values 13-67, 13-68

E

EAP-FAST

enabling B-27

identity protection B-21

logging B-20

master keys

definition B-22

PAC

automatic provisioning B-24

definition B-22

manual provisioning B-25

refresh B-27

phases B-20

EAP-FAST settings

configuring 18-3

EAP-TLS settings

configuring 18-2

equality 13-61, 13-74

equality operator 13-61

Equal to condition 13-70

Excel spreadsheets 13-24

expanding sections or groups 13-68

expanding table of contents entries 13-23

Export Data dialog 13-24

expressions

calculating data and 13-61

filtering data and 13-69, 13-70, 13-71, 13-73, 13-75

external identity server

RSA SecurID 8-57

external identity servers

RADIUS identity stores 8-63

external identity stores 8-2

LDAP 8-22

Microsoft AD 8-41

F

false function 13-55

fields 13-27

filter conditions 13-69, 13-70, 13-73, 13-75

Filter dialog 13-72, 13-73

Filter drop-down list 13-76

filters 13-69, 13-71, 13-72, 13-73

FIND function 13-55

finding text values 13-55, 13-59

FIRST function 13-55

First function 13-64

Fixed format option 13-31

fixed numeric values 13-32

Font dialog box 13-39

fonts 13-39, 13-78

footers 13-63

Format Chart page 13-78

Format command 13-78

format patterns 13-33, 13-34

formats

changing 13-28, 13-38

customizing 13-33

data types and 13-30

deleting conditional 13-40

exporting data and 13-24

previewing conditional 13-39

selecting 13-32

formatting

column headers 13-28

labels 13-27, 13-28

string data 13-33

formatting options 13-32, 13-33, 13-35

formatting rules 13-37, 13-38

formatting symbols 13-33, 13-34

functions 13-52, 13-53, 13-64, 13-65

G

General Date format option 13-31

General Number format option 13-31

Go to page pick list 13-22

Greater Than condition 13-70

greater than operator 13-61

Greater Than or Equal to condition 13-70

greater than or equal to operator 13-61

Group Detail dialog 13-51

grouping

filter conditions 13-75

grouping intervals 13-50

groups

adding 13-49, 13-50

aggregating data and 13-63

collapsing 13-50, 13-68, 13-69

counting rows for 13-54

displaying data and 13-42, 13-67

setting page breaks for 13-41

sorting data and 13-48

H

headers 13-24, 13-63

hidden items 13-45

Hide Column command 13-45

Hide Detail command 13-69

Hide or Show Items dialog 13-44

hiding

detail rows 13-68

duplicate values 13-67, 13-68

report items 13-44

HTML files 13-26

I

identity store sequences 8-77

If...Then...Else statement 13-55

IF function 13-55

import and export

creating import files 5-21

supported objects 5-18

information objects 13-30

IN function 13-55

Interactive Viewer 13-21

internal identity stores 8-1

ISBOTTOMN function 13-56

ISBOTTOMNPERCENT function 13-56

Is False condition 13-70

Is False operator 13-38

Is Not Null condition 13-70

Is Not Null operator 13-38

Is Null condition 13-70

ISNULL function 13-56

Is Null operator 13-38

ISTOPN function 13-56

ISTOPNPERCENT function 13-56

Is True condition 13-70

Is True operator 13-38

L

labels 13-27, 13-28

formatting 13-28

LAST function 13-56

Last function 13-64

leading characters 13-59

LEFT function 13-56

LEN function 13-56

Less Than condition 13-70

less than operator 13-61

Less Than or Equal to condition 13-70

less than or equal to operator 13-61

licensing 18-34

Like condition 13-70

LIKE function 13-57

literal values 13-74

locales

creating charts and 13-78

customizing formats for 13-30, 13-32, 13-35

locating text values 13-55, 13-59

logical operators 13-61

Long Date format option 13-31

Long Time format option 13-31

lowercase characters 13-57

Lowercase format option 13-31

LOWER function 13-57

M

Management Hierarchy 8-19

master key

definition B-22

matching character patterns 13-71

mathematical functions 13-52, 13-53

mathematical operators 13-61

MAX function 13-57

Max function 13-64

MEDIAN function 13-57

Median function 13-64

median values 13-57, 13-64

Medium Date format option 13-31

Medium Time format option 13-31

membership filters 13-71

menus 13-21

migration

common scenarios 2-7

considerations 2-3

downloads 2-3

requirements 2-2

supported versions 2-2

MIN function 13-57

Min function 13-64

Mode function 13-64

MOD function 13-57

monitoring and report viewer

configuring remote database 15-18

dashboard 11-2

data backup and purge 15-3

data upgrade status 15-15

restore 15-7

viewing process status 15-14

viewing scheduled jobs 15-12

MONTH function 13-57

Move to Group Header command 13-43

Move to Group Header dialog 13-43

MOVINGAVERAGE function 13-57

moving columns 13-42

moving through reports 13-22

multipage reports 13-68

multiplication 13-62

multiplication operator 13-61

N

naming

calculated columns 13-62

navigating through reports 13-22

navigational tools 13-22

negative numbers 13-32

non-null values 13-56, 13-57, 13-70

Not Between condition 13-70

Not Between operator 13-38

note, description of ii-xxiv

Not Equal to condition 13-70

not equal to operator 13-61

Not Like condition 13-70

NOTNULL function 13-57

NOT operator 13-61, 13-75

NOW function 13-57

null value filters 13-71

null values 13-56, 13-57, 13-70, 13-71

Number Column Format dialog 13-32

Number column format dialog 13-33

number formats 13-31, 13-32, 13-33

numeric data types 13-31

numeric expressions 13-61, 13-62

numeric values 13-24, 13-33

O

opening

exported data files 13-25

Interactive Viewer 13-21

operators 13-38, 13-61

OR operator 13-61, 13-75

P

PAC

automatic provisioning B-24

definition B-22

manual provisioning B-25

refresh B-27

Page Break on Group dialog 13-41

page breaks 13-41

paging toolbar 13-22

pattern-matching filters 13-71

PDF files 13-26

PEAP

identity protection B-15

phases B-15

PEAP settings

configuring 18-3

percentage operator 13-61

percentages 13-32, 13-56, 13-58

Percent format option 13-31

PERCENTILE function 13-58

PERCENTRANK function 13-58

PERCENTSUM function 13-58

previewing conditional formats 13-39

primary sorting column 13-48

Print dialog 13-26

printing 13-26

printing options 13-26

Q

QUARTER function 13-58

QUARTILE function 13-58

Quartile function 13-64

R

RADIUS proxy 4-29

configuring proxy service 4-32

supported protocols 4-30

supported RADIUS attributes 4-31

range filters 13-71

range of values 13-37, 13-38, 13-69, 13-71

RANK function 13-58

relationships 13-76

Reorder Columns command 13-42

report designs

hiding data in 13-67

organizing data in 13-42

saving 13-26

report items 13-44

reports 13-1

catalog 13-7

changing 13-21

displaying 13-20

dynamic change of authorization 13-2

favorites 13-3

navigating through 13-22

printing 13-26

setting page breaks for 13-41

shared 13-6

viewing specific pages in 13-22, 13-23

report sections 13-68, 13-69

report templates 13-28, 13-78

report viewers 13-21

resizing columns 13-24, 13-29

RIGHT function 13-58

ROUNDDOWN function 13-59

ROUND function 13-58

rounding 13-54, 13-58

ROUNDUP function 13-59

row-by-row comparisons 13-55

rows 13-67, 13-68

RUNNINGSUM function 13-59

running totals 13-59

S

Save As dialog 13-25

saving

exported data 13-25

report designs 13-26

Scientific format option 13-31

scientific numbers 13-32

SEARCH function 13-59

searching 13-55, 13-59, 13-72

sections 13-68, 13-69

Security Access Group 4-23

Select data item dialog 13-72

Short Date format option 13-31

Short Time format option 13-31

Show Columns command 13-45

Show Columns dialog 13-45

Show Detail command 13-69

sorting multiple columns 13-48

sort order 13-47

spreadsheet reports 13-24

SQRT function 13-59

square roots 13-59

standard deviation 13-59, 13-64

Standard Deviation function 13-64

Standard Viewer 13-21

STDEV function 13-59

String Column Format dialog 13-34

String column format dialog 13-33

string conversions 13-34

string data types 13-31

string fields 13-71

string patterns 13-59

strings 13-33, 13-56, 13-70

substrings 13-56, 13-58, 13-70

subtraction operator 13-61

subtypes (charts) 13-78

SUM function 13-59

Sum function 13-64

summary values 13-59, 13-64

T

tables

aggregating data and 13-63, 13-65, 13-66

counting rows in 13-54, 13-64

TACACS+ settings

configuring 18-1

templates 13-28, 13-78

testing

character patterns 13-71

for non-null values 13-57

for null values 13-56, 13-71

range of values 13-71

sets of values 13-71

text

aggregating values for 13-65

changing label 13-27

converting case 13-34

searching for 13-55, 13-59

text files 13-24, 13-25

text formats 13-31

text patterns 13-71

text styles 13-39

themes 13-78

thousands separators 13-32

time data types 13-31

time formats 13-31, 13-35

timesaver, description of ii-xxiv

time stamps 13-57, 13-59

time values 13-35, 13-50

TODAY function 13-59

Top N condition 13-70

Top Percent condition 13-70

totals 13-37, 13-59, 13-64

trailing characters 13-59

TRIM function 13-59

TRIMLEFT function 13-59

TRIMRIGHT function 13-59

troubleshooting

connectivity 14-1

expert troubleshooter 14-2

support bundles 14-1

true function 13-59

U

Unformatted format option 13-31

uppercase characters 13-59

Uppercase format option 13-31

UPPER function 13-59

V

values

averaging 13-54, 13-57, 13-60, 13-64

calculating 13-42

comparing 13-37, 13-38, 13-71

counting number of distinct 13-54, 13-64

determining rank 13-58

displaying frequently occurring 13-64

hiding duplicate 13-67, 13-68

returning highest 13-57, 13-64

returning last 13-56, 13-64

returning lowest 13-57, 13-64, 13-70

returning null 13-70

returning specified 13-70

rounding 13-54, 13-58

searching for 13-72

sorting highest or lowest 13-75

testing for non-null 13-57

testing for null 13-56, 13-71

testing for specified 13-55

testing range of 13-71

testing sets of 13-71

value series 13-76

VAR function 13-59

variance 13-59, 13-64

Variance function 13-64

viewers 13-21

viewing

data 13-30, 13-42, 13-67

detail rows 13-68

reports 13-20

specific report pages 13-22, 13-23

table of contents 13-23

viewing environments 13-20

vpn remote access 4-20

configuring access service 4-22

supported clients 4-22

supported identity stores 4-21

supported network access servers 4-22

supported protocols 4-21

W

WEEKDAY function 13-60

WEEK function 13-59

WEIGHTEDAVERAGE function 13-60

Weighted average function 13-64

wildcard characters 13-59

X

x-axis values 13-76

Y

y-axis values 13-76

YEAR function 13-60