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-33

% operator 13-60

& formatting symbol 13-33

& operator 13-60

* operator 13-60

+ operator 13-60

/ operator 13-60

<= operator 13-60

<> operator 13-60

< formatting symbol 13-33

< operator 13-60

= operator 13-60

>= operator 13-60

> formatting symbol 13-33

> operator 13-60

@ formatting symbol 13-33

- operator 13-60

A

ABS function 13-53

absolute values 13-53

accessing

data 13-66

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

adding

aggregate rows 13-64, 13-65

data filters 13-68, 13-70, 13-71, 13-72

data groups 13-49, 13-50

formatting rules 13-36, 13-37

page breaks 13-40

addition operator 13-60

administrator access setting 16-11

administrator password policy 16-9

administrator password reset 16-12

administrator roles 16-2

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

Advanced Sort command 13-47

aggregate functions 13-63, 13-64

aggregate rows

creating 13-64, 13-65

formatting data in 13-29

aggregate values 13-41

Aggregation dialog 13-64

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-60, 13-74

Any Of condition 13-68

arguments 13-52

Arrange Columns dialog 13-42

ascending sort order 13-47

AVERAGE function 13-53

Average function 13-63

averages 13-53, 13-57, 13-59, 13-63

B

background colors 13-39

Between condition 13-68, 13-73

BETWEEN function 13-53

Between operator 13-38

blank characters 13-59

Boolean values 13-54, 13-59, 13-69

Bottom N condition 13-69

Bottom Percent condition 13-69

C

calculated columns

aggregating data and 13-62, 13-64, 13-65

creating 13-51, 13-60

placing values in 13-54

Calculation dialog 13-52, 13-61, 13-62

calculations 13-41

case conversions 13-33

case-insensitive searches 13-58

case-sensitive searches 13-54

category series 13-75

cautions

description ii-xxiv

CEILING function 13-53

changing

aggregate values 13-29

chart subtypes 13-77

column headers 13-24, 13-27

conditional formats 13-37

data filters 13-72

default formats 13-28

labels 13-27

reports 13-21

character patterns 13-58, 13-70

character placeholder 13-33

charts

overview 13-75

Chart Subtype command 13-77

Cisco CAT 6K 4-23

clearing data filters 13-72

closing Standard Viewer 13-21

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

colors 13-39

column headers 13-24

column names 13-71

Column Properties dialog 13-28

columns

aligning data in 13-29

changing order of 13-42

counting rows in 13-63

deleting 13-43

determining first value in 13-55, 13-63

determining last value in 13-56, 13-63

determining type 13-31

displaying data in 13-30

formatting data in 13-36, 13-37

grouping date and time values in 13-50

resizing 13-25, 13-28

sorting data in 13-47, 13-74

Column Width command 13-28

comma-separated values files. See CSV files

comparison filters 13-70

comparison operators 13-38, 13-70

comparisons 13-37, 13-38, 13-54

concatenation operator 13-60

Conditional Formatting dialog 13-36, 13-37, 13-39

conditional formatting rules 13-36, 13-37

conditions

filtering data and 13-68, 13-69, 13-72

formatting data and 13-36

context menus 13-21

conversions 13-33

COUNT_DISTINCT function 13-54

COUNT function 13-54

Count function 13-63

Count Value function 13-63

creating

aggregate rows 13-64, 13-65

calculated columns 13-51, 13-60

data filters 13-68, 13-70, 13-71, 13-72

data groups 13-49, 13-50

formatting rules 13-36, 13-37

crud operations 7-6

CSV files 13-24, 13-25

currency 13-31

Currency format option 13-30

currency formatting options 13-31

currency symbols 13-31

Custom format option 13-30, 13-31

customizing

formats 13-32, 13-33

D

data

accessing 13-66

aligning 13-29

displaying 13-30, 13-41, 13-66

hiding 13-44

plotting relationships for 13-75

data filters 13-68, 13-70, 13-71, 13-72

data points 13-75

data rows 13-66, 13-67

data sections 13-67, 13-68

data sets 13-41, 13-63, 13-66, 13-75

data sources 13-25, 13-31, 13-47, 13-66

data types 13-31

Date and Time Format dialog 13-35

date calculations 13-62

date data types 13-30

date expressions 13-60, 13-62

date formats 13-30, 13-34, 13-35

Date or Time Column Format dialog 13-35

date values 13-34, 13-50, 13-54

DAY function 13-54

decimal values 13-31

default formats 13-28, 13-29

default network device 7-17

deleting

columns 13-43

conditional formats 13-39

data filters 13-72

filter conditions 13-74

page breaks 13-41

delimited text files 13-24, 13-25

descending sort order 13-47

designs

hiding data in 13-66

organizing data in 13-41

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-41, 13-66

detail rows 13-67

reports 13-21

specific report pages 13-23, 13-24

table of contents 13-23

distinct values 13-54, 13-63

division 13-56, 13-60

division operator 13-60

downloads 18-40

duplicate values 13-66, 13-67

E

EAP-FAST

enabling B-26

identity protection B-20

logging B-19

master keys

definition B-21

PAC

automatic provisioning B-23

definition B-21

manual provisioning B-24

refresh B-26

phases B-19

EAP-FAST settings

configuring 18-3

EAP-TLS settings

configuring 18-2

equality 13-60, 13-73

equality operator 13-60

Equal to condition 13-69

Excel spreadsheets 13-24

expanding sections or groups 13-67

expanding table of contents entries 13-23

Export Data dialog 13-25

expressions

calculating data and 13-60

filtering data and 13-68, 13-69, 13-70, 13-72, 13-74

external identity server

RSA SecurID 8-51

external identity servers

RADIUS identity stores 8-57

external identity stores 8-2

LDAP 8-19

Microsoft AD 8-38

F

false function 13-54

fields 13-27

filter conditions 13-68, 13-69, 13-72, 13-74

Filter dialog 13-71, 13-72

Filter drop-down list 13-75

filters 13-68, 13-70, 13-71, 13-72

FIND function 13-54

finding text values 13-54, 13-58

FIRST function 13-54

First function 13-63

Fixed format option 13-30

fixed numeric values 13-32

Font dialog box 13-39

fonts 13-39, 13-77

footers 13-62

Format Chart page 13-77

Format command 13-77

format patterns 13-32, 13-33

formats

changing 13-28, 13-37

customizing 13-32, 13-33

data types and 13-30

deleting conditional 13-39

exporting data and 13-24

previewing conditional 13-39

selecting 13-31

formatting

column headers 13-27

labels 13-27, 13-28

string data 13-33

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

formatting rules 13-36, 13-37

formatting symbols 13-32, 13-33

functions 13-52, 13-53, 13-63, 13-64

G

General Date format option 13-30

General Number format option 13-30

Go to page pick list 13-23

Greater Than condition 13-69

greater than operator 13-60

Greater Than or Equal to condition 13-69

greater than or equal to operator 13-60

Group Detail dialog 13-50

grouping

filter conditions 13-74

grouping intervals 13-50

groups

adding 13-49, 13-50

aggregating data and 13-62

collapsing 13-50, 13-67, 13-68

counting rows for 13-54

displaying data and 13-41, 13-66

setting page breaks for 13-40, 13-41

sorting data and 13-48

H

headers 13-24, 13-62

hidden items 13-44

Hide Column command 13-44

Hide Detail command 13-68

Hide or Show Items dialog 13-44

hiding

detail rows 13-67

duplicate values 13-66, 13-67

report items 13-44

HTML files 13-26

I

identity store sequences 8-71

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

IF function 13-55

import and export

creating import files 5-20

supported objects 5-18

information objects 13-30

IN function 13-55

Interactive Viewer 13-21

internal identity stores 8-1

ISBOTTOMN function 13-55

ISBOTTOMNPERCENT function 13-55

Is False condition 13-69

Is False operator 13-38

Is Not Null condition 13-69

Is Not Null operator 13-38

Is Null condition 13-69

ISNULL function 13-55

Is Null operator 13-38

ISTOPN function 13-55

ISTOPNPERCENT function 13-55

Is True condition 13-69

Is True operator 13-38

L

labels 13-27, 13-28

formatting 13-28

LAST function 13-56

Last function 13-63

leading characters 13-59

LEFT function 13-56

LEN function 13-56

Less Than condition 13-69

less than operator 13-60

Less Than or Equal to condition 13-69

less than or equal to operator 13-60

licensing 18-34

Like condition 13-69

LIKE function 13-56

literal values 13-73

locales

creating charts and 13-77

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

locating text values 13-54, 13-58

logical operators 13-60

Long Date format option 13-30

Long Time format option 13-30

lowercase characters 13-56

Lowercase format option 13-31

LOWER function 13-56

M

master key

definition B-21

matching character patterns 13-70

mathematical functions 13-52, 13-53

mathematical operators 13-60

MAX function 13-56

Max function 13-63

MEDIAN function 13-56

Median function 13-63

median values 13-56, 13-63

Medium Date format option 13-30

Medium Time format option 13-30

membership filters 13-70

menus 13-21

migration

common scenarios 2-7

considerations 2-3

downloads 2-3

requirements 2-2

supported versions 2-2

MIN function 13-56

Min function 13-63

Mode function 13-63

MOD function 13-56

monitoring & report viewer

configuring remote database 15-17

data backup and purge 15-3

data upgrade status 15-14

restore 15-7

viewing process status 15-13

viewing scheduled jobs 15-11

monitoring and report viewer

dashboard 11-2

MONTH function 13-56, 13-57

Move to Group Header command 13-42

Move to Group Header dialog 13-42

MOVINGAVERAGE function 13-57

moving columns 13-42

moving through reports 13-23

multipage reports 13-67

multiplication 13-61

multiplication operator 13-60

N

naming

calculated columns 13-61

navigating through reports 13-23

navigational tools 13-23

negative numbers 13-32

non-null values 13-55, 13-57, 13-69

Not Between condition 13-69

Not Between operator 13-38

note, description of ii-xxiv

Not Equal to condition 13-69

not equal to operator 13-60

Not Like condition 13-69

NOTNULL function 13-57

NOT operator 13-60, 13-74

NOW function 13-57

null value filters 13-70

null values 13-55, 13-57, 13-69, 13-70

Number Column Format dialog 13-31, 13-32

Number column format dialog 13-32

number formats 13-30, 13-31, 13-32

numeric data types 13-30

numeric expressions 13-60, 13-61

numeric values 13-24, 13-32

O

opening

exported data files 13-25

Interactive Viewer 13-21

operators 13-38, 13-60

OR operator 13-60, 13-74

P

PAC

automatic provisioning B-23

definition B-21

manual provisioning B-24

refresh B-26

Page Break on Group dialog 13-40

page breaks 13-40, 13-41

paging toolbar 13-23

pattern-matching filters 13-70

PDF files 13-26

PEAP

identity protection B-15

phases B-15

PEAP settings

configuring 18-3

percentage operator 13-60

percentages 13-31, 13-32, 13-55, 13-57

Percent format option 13-30

PERCENTILE function 13-57

PERCENTRANK function 13-57

PERCENTSUM function 13-57

previewing conditional formats 13-39

primary sorting column 13-47

Print dialog 13-26

printing 13-26

printing options 13-26

Q

QUARTER function 13-57

QUARTILE function 13-57

Quartile function 13-63

R

RADIUS proxy 4-29

configuring proxy service 4-32

supported protocols 4-30

supported RADIUS attributes 4-31

range filters 13-70

range of values 13-37, 13-38, 13-68, 13-70

RANK function 13-58

relationships 13-75

Reorder Columns command 13-42

report designs

hiding data in 13-66

organizing data in 13-41

saving 13-26

report items 13-44

reports 13-1

catalog 13-7

changing 13-21

displaying 13-21

dynamic change of authorization 13-2

favorites 13-3

navigating through 13-23

printing 13-26

setting page breaks for 13-40

shared 13-6

viewing specific pages in 13-23, 13-24

report sections 13-67, 13-68

report templates 13-27, 13-77

report viewers 13-21

resizing columns 13-25, 13-28

RIGHT function 13-58

ROUNDDOWN function 13-58

ROUND function 13-58

rounding 13-53, 13-58

ROUNDUP function 13-58

row-by-row comparisons 13-54

rows 13-66, 13-67

RUNNINGSUM function 13-58

running totals 13-58

S

Save As dialog 13-25

saving

exported data 13-25

report designs 13-26

Scientific format option 13-30

scientific numbers 13-32

SEARCH function 13-58

searching 13-54, 13-58, 13-71

sections 13-67, 13-68

Security Access Group 4-23

Select data item dialog 13-71

Short Date format option 13-30

Short Time format option 13-30

Show Columns command 13-45

Show Columns dialog 13-45

Show Detail command 13-68

sorting multiple columns 13-47

sort order 13-47

spreadsheet reports 13-24

SQRT function 13-58

square roots 13-58

standard deviation 13-58, 13-63

Standard Deviation function 13-63

Standard Viewer 13-21

STDEV function 13-58

String Column Format dialog 13-34

String column format dialog 13-33

string conversions 13-33

string data types 13-31

string fields 13-70

string patterns 13-58

strings 13-33, 13-56, 13-69

substrings 13-56, 13-58, 13-69

subtraction operator 13-60

subtypes (charts) 13-77

SUM function 13-58

Sum function 13-63

summary values 13-58, 13-63

T

tables

aggregating data and 13-62, 13-64, 13-65

counting rows in 13-54, 13-63

TACACS+ settings

configuring 18-1

templates 13-27, 13-77

testing

character patterns 13-70

for non-null values 13-57

for null values 13-55, 13-70

range of values 13-70

sets of values 13-70

text

aggregating values for 13-64

changing label 13-27

converting case 13-33

searching for 13-54, 13-58

text files 13-24, 13-25

text formats 13-31

text patterns 13-70

text styles 13-39

themes 13-77

thousands separators 13-31

time data types 13-30

time formats 13-30, 13-34

timesaver, description of ii-xxiv

time stamps 13-57, 13-58

time values 13-34, 13-50

TODAY function 13-58

Top N condition 13-69

Top Percent condition 13-69

totals 13-37, 13-58, 13-63

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-30, 13-31

uppercase characters 13-59

Uppercase format option 13-31

UPPER function 13-59

V

values

averaging 13-53, 13-57, 13-59, 13-63

calculating 13-41

comparing 13-37, 13-38, 13-70

counting number of distinct 13-54, 13-63

determining rank 13-58

displaying frequently occurring 13-63

hiding duplicate 13-66, 13-67

returning highest 13-56, 13-63

returning last 13-56, 13-63

returning lowest 13-56, 13-63, 13-69

returning null 13-69

returning specified 13-69

rounding 13-53, 13-58

searching for 13-71

sorting highest or lowest 13-74

testing for non-null 13-57

testing for null 13-55, 13-70

testing for specified 13-55

testing range of 13-70

testing sets of 13-70

value series 13-75

VAR function 13-59

variance 13-59, 13-63

Variance function 13-63

viewers 13-21

viewing

data 13-30, 13-41, 13-66

detail rows 13-67

reports 13-21

specific report pages 13-23, 13-24

table of contents 13-23

viewing environments 13-21

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-59

WEEK function 13-59

WEIGHTEDAVERAGE function 13-59

Weighted average function 13-63

wildcard characters 13-58

X

x-axis values 13-75

Y

y-axis values 13-75

YEAR function 13-59