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

% operator 13-59

& formatting symbol 13-32

& operator 13-59

* operator 13-59

+ operator 13-59

/ operator 13-59

<= operator 13-59

<> operator 13-59

< formatting symbol 13-32

< operator 13-59

= operator 13-59

>= operator 13-59

> formatting symbol 13-32

> operator 13-59

@ formatting symbol 13-32

- operator 13-59

A

ABS function 13-52

absolute values 13-52

accessing

data 13-65

Interactive Viewer 13-20

table of contents entries 13-22

acs distributed deployment 17-2

ADD_DAY function 13-52

ADD_HOUR function 13-52

ADD_MINUTE function 13-52

ADD_MONTH function 13-52

ADD_QUARTER function 13-52

ADD_SECOND function 13-52

ADD_WEEK function 13-52

ADD_YEAR function 13-52

Add Group command 13-49

adding

aggregate rows 13-63, 13-64

data filters 13-67, 13-69, 13-70, 13-71

data groups 13-48, 13-49

formatting rules 13-35, 13-36

page breaks 13-39

addition operator 13-59

administrator access setting 16-11

administrator password policy 16-9

administrator password reset 16-12

administrator roles 16-2

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

Advanced Sort command 13-46

aggregate functions 13-62, 13-63

aggregate rows

creating 13-63, 13-64

formatting data in 13-28

aggregate values 13-40

Aggregation dialog 13-63

alarms 12-1

syslog targets 12-34

system alarms 12-33

alarm schedules 12-8

aligning data 13-28

alignment options 13-28

AND operator 13-59, 13-73

Any Of condition 13-67

arguments 13-51

Arrange Columns dialog 13-41

ascending sort order 13-46

AVERAGE function 13-52

Average function 13-62

averages 13-52, 13-56, 13-58, 13-62

B

background colors 13-38

Between condition 13-67, 13-72

BETWEEN function 13-52

Between operator 13-37

blank characters 13-58

Boolean values 13-53, 13-58, 13-68

Bottom N condition 13-68

Bottom Percent condition 13-68

C

calculated columns

aggregating data and 13-61, 13-63, 13-64

creating 13-50, 13-59

placing values in 13-53

Calculation dialog 13-51, 13-60, 13-61

calculations 13-40

case conversions 13-32

case-insensitive searches 13-57

case-sensitive searches 13-53

category series 13-74

cautions

description ii-xxiv

CEILING function 13-52

changing

aggregate values 13-28

chart subtypes 13-76

column headers 13-23, 13-26

conditional formats 13-36

data filters 13-71

default formats 13-27

labels 13-26

reports 13-20

character patterns 13-57, 13-69

character placeholder 13-32

charts

overview 13-74

Chart Subtype command 13-76

Cisco CAT 6K 4-23

clearing data filters 13-71

closing Standard Viewer 13-20

collapsing data groups 13-49, 13-66, 13-67

colors 13-38

column headers 13-23

column names 13-70

Column Properties dialog 13-27

columns

aligning data in 13-28

changing order of 13-41

counting rows in 13-62

deleting 13-42

determining first value in 13-54, 13-62

determining last value in 13-55, 13-62

determining type 13-30

displaying data in 13-29

formatting data in 13-35, 13-36

grouping date and time values in 13-49

resizing 13-23, 13-27

sorting data in 13-46, 13-73

Column Width command 13-27

comma-separated values files. See CSV files

comparison filters 13-69

comparison operators 13-37, 13-69

comparisons 13-36, 13-37, 13-53

concatenation operator 13-59

Conditional Formatting dialog 13-35, 13-36, 13-38

conditional formatting rules 13-35, 13-36

conditions

filtering data and 13-67, 13-68, 13-71

formatting data and 13-35

context menus 13-20

conversions 13-32

COUNT_DISTINCT function 13-53

COUNT function 13-53

Count function 13-62

Count Value function 13-62

creating

aggregate rows 13-63, 13-64

calculated columns 13-50, 13-59

data filters 13-67, 13-69, 13-70, 13-71

data groups 13-48, 13-49

formatting rules 13-35, 13-36

crud operations 7-6

CSV files 13-23, 13-24

currency 13-30

Currency format option 13-29

currency formatting options 13-30

currency symbols 13-30

Custom format option 13-29, 13-30

customizing

formats 13-31, 13-32

D

data

accessing 13-65

aligning 13-28

displaying 13-29, 13-40, 13-65

hiding 13-43

plotting relationships for 13-74

data filters 13-67, 13-69, 13-70, 13-71

data points 13-74

data rows 13-65, 13-66

data sections 13-66, 13-67

data sets 13-40, 13-62, 13-65, 13-74

data sources 13-24, 13-30, 13-46, 13-65

data types 13-30

Date and Time Format dialog 13-34

date calculations 13-61

date data types 13-29

date expressions 13-59, 13-61

date formats 13-29, 13-33, 13-34

Date or Time Column Format dialog 13-34

date values 13-33, 13-49, 13-53

DAY function 13-53

decimal values 13-30

default formats 13-27, 13-28

default network device 7-16

deleting

columns 13-42

conditional formats 13-38

data filters 13-71

filter conditions 13-73

page breaks 13-40

delimited text files 13-23, 13-24

descending sort order 13-46

designs

hiding data in 13-65

organizing data in 13-40

saving 13-25

DIFF_DAY function 13-53

DIFF_HOUR function 13-53

DIFF_MINUTE function 13-53

DIFF_MONTH function 13-53

DIFF_QUARTER function 13-53

DIFF_SECOND function 13-53

DIFF_WEEK function 13-53

DIFF_YEAR function 13-53

displaying

data 13-29, 13-40, 13-65

detail rows 13-66

reports 13-19

specific report pages 13-21, 13-22

table of contents 13-22

distinct values 13-53, 13-62

division 13-55, 13-59

division operator 13-59

downloads 18-39

duplicate values 13-65, 13-66

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-59, 13-72

equality operator 13-59

Equal to condition 13-68

Excel spreadsheets 13-23

expanding sections or groups 13-66

expanding table of contents entries 13-22

Export Data dialog 13-23

expressions

calculating data and 13-59

filtering data and 13-67, 13-68, 13-69, 13-71, 13-73

external identity server

RSA SecurID 8-46

external identity servers

RADIUS identity stores 8-52

external identity stores 8-2

LDAP 8-18

Microsoft AD 8-38

F

false function 13-53

fields 13-26

filter conditions 13-67, 13-68, 13-71, 13-73

Filter dialog 13-70, 13-71

Filter drop-down list 13-74

filters 13-67, 13-69, 13-70, 13-71

FIND function 13-53

finding text values 13-53, 13-57

FIRST function 13-53

First function 13-62

Fixed format option 13-29

fixed numeric values 13-31

Font dialog box 13-38

fonts 13-38, 13-76

footers 13-61

Format Chart page 13-76

Format command 13-76

format patterns 13-31, 13-32

formats

changing 13-27, 13-36

customizing 13-31, 13-32

data types and 13-29

deleting conditional 13-38

exporting data and 13-23

previewing conditional 13-38

selecting 13-30

formatting

column headers 13-26

labels 13-26, 13-27

string data 13-32

formatting options 13-30, 13-31, 13-32, 13-34

formatting rules 13-35, 13-36

formatting symbols 13-31, 13-32

functions 13-51, 13-52, 13-62, 13-63

G

General Date format option 13-29

General Number format option 13-29

Go to page pick list 13-21

Greater Than condition 13-68

greater than operator 13-59

Greater Than or Equal to condition 13-68

greater than or equal to operator 13-59

Group Detail dialog 13-49

grouping

filter conditions 13-73

grouping intervals 13-49

groups

adding 13-48, 13-49

aggregating data and 13-61

collapsing 13-49, 13-66, 13-67

counting rows for 13-53

displaying data and 13-40, 13-65

setting page breaks for 13-39, 13-40

sorting data and 13-47

H

headers 13-23, 13-61

hidden items 13-43

Hide Column command 13-43

Hide Detail command 13-67

Hide or Show Items dialog 13-43

hiding

detail rows 13-66

duplicate values 13-65, 13-66

report items 13-43

HTML files 13-25

I

identity store sequences 8-66

If...Then...Else statement 13-54

IF function 13-54

import and export

creating import files 5-21

supported objects 5-19

information objects 13-29

IN function 13-54

Interactive Viewer 13-20

internal identity stores 8-1

ISBOTTOMN function 13-54

ISBOTTOMNPERCENT function 13-54

Is False condition 13-68

Is False operator 13-37

Is Not Null condition 13-68

Is Not Null operator 13-37

Is Null condition 13-68

ISNULL function 13-54

Is Null operator 13-37

ISTOPN function 13-54

ISTOPNPERCENT function 13-54

Is True condition 13-68

Is True operator 13-37

L

labels 13-26, 13-27

formatting 13-27

LAST function 13-55

Last function 13-62

leading characters 13-58

LEFT function 13-55

LEN function 13-55

Less Than condition 13-68

less than operator 13-59

Less Than or Equal to condition 13-68

less than or equal to operator 13-59

licensing 18-33

Like condition 13-68

LIKE function 13-55

literal values 13-72

locales

creating charts and 13-76

customizing formats for 13-29, 13-30, 13-34

locating text values 13-53, 13-57

logical operators 13-59

Long Date format option 13-29

Long Time format option 13-29

lowercase characters 13-55

Lowercase format option 13-30

LOWER function 13-55

M

master key

definition B-21

matching character patterns 13-69

mathematical functions 13-51, 13-52

mathematical operators 13-59

MAX function 13-55

Max function 13-62

MEDIAN function 13-55

Median function 13-62

median values 13-55, 13-62

Medium Date format option 13-29

Medium Time format option 13-29

membership filters 13-69

menus 13-20

migration

common scenarios 2-7

considerations 2-3

downloads 2-3

requirements 2-2

supported versions 2-2

MIN function 13-55

Min function 13-62

Mode function 13-62

MOD function 13-55

monitoring & report viewer

configuring remote database 15-16

data backup and purge 15-3

data upgrade status 15-12

restore 15-5

viewing process status 15-11

viewing scheduled jobs 15-10

monitoring and report viewer

dashboard 11-2

MONTH function 13-55, 13-56

Move to Group Header command 13-41

Move to Group Header dialog 13-41

MOVINGAVERAGE function 13-56

moving columns 13-41

moving through reports 13-21

multipage reports 13-66

multiplication 13-60

multiplication operator 13-59

N

naming

calculated columns 13-60

navigating through reports 13-21

navigational tools 13-21

negative numbers 13-31

non-null values 13-54, 13-56, 13-68

Not Between condition 13-68

Not Between operator 13-37

note, description of ii-xxiv

Not Equal to condition 13-68

not equal to operator 13-59

Not Like condition 13-68

NOTNULL function 13-56

NOT operator 13-59, 13-73

NOW function 13-56

null value filters 13-69

null values 13-54, 13-56, 13-68, 13-69

Number Column Format dialog 13-30, 13-31

Number column format dialog 13-31

number formats 13-29, 13-30, 13-31

numeric data types 13-29

numeric expressions 13-59, 13-60

numeric values 13-23, 13-31

O

opening

exported data files 13-24

Interactive Viewer 13-20

operators 13-37, 13-59

OR operator 13-59, 13-73

P

PAC

automatic provisioning B-23

definition B-21

manual provisioning B-24

refresh B-26

Page Break on Group dialog 13-39

page breaks 13-39, 13-40

paging toolbar 13-21

pattern-matching filters 13-69

PDF files 13-25

PEAP

identity protection B-15

phases B-15

PEAP settings

configuring 18-3

percentage operator 13-59

percentages 13-30, 13-31, 13-54, 13-56

Percent format option 13-29

PERCENTILE function 13-56

PERCENTRANK function 13-56

PERCENTSUM function 13-56

previewing conditional formats 13-38

primary sorting column 13-46

Print dialog 13-25

printing 13-25

printing options 13-25

Q

QUARTER function 13-56

QUARTILE function 13-56

Quartile function 13-62

R

RADIUS proxy 4-29

configuring proxy service 4-31

supported protocols 4-30

supported RADIUS attributes 4-30

range filters 13-69

range of values 13-36, 13-37, 13-67, 13-69

RANK function 13-57

relationships 13-74

Reorder Columns command 13-41

report designs

hiding data in 13-65

organizing data in 13-40

saving 13-25

report items 13-43

reports 13-1

catalog 13-7

changing 13-20

displaying 13-19

dynamic change of authorization 13-2

favorites 13-3

navigating through 13-21

printing 13-25

setting page breaks for 13-39

shared 13-6

viewing specific pages in 13-21, 13-22

report sections 13-66, 13-67

report templates 13-26, 13-76

report viewers 13-20

resizing columns 13-23, 13-27

RIGHT function 13-57

ROUNDDOWN function 13-57

ROUND function 13-57

rounding 13-52, 13-57

ROUNDUP function 13-57

row-by-row comparisons 13-53

rows 13-65, 13-66

RUNNINGSUM function 13-57

running totals 13-57

S

Save As dialog 13-24

saving

exported data 13-24

report designs 13-25

Scientific format option 13-29

scientific numbers 13-31

SEARCH function 13-57

searching 13-53, 13-57, 13-70

sections 13-66, 13-67

Select data item dialog 13-70

Short Date format option 13-29

Short Time format option 13-29

Show Columns command 13-44

Show Columns dialog 13-44

Show Detail command 13-67

sorting multiple columns 13-46

sort order 13-46

spreadsheet reports 13-23

SQRT function 13-57

square roots 13-57

standard deviation 13-57, 13-62

Standard Deviation function 13-62

Standard Viewer 13-20

STDEV function 13-57

String Column Format dialog 13-33

String column format dialog 13-32

string conversions 13-32

string data types 13-30

string fields 13-69

string patterns 13-57

strings 13-32, 13-55, 13-68

substrings 13-55, 13-57, 13-68

subtraction operator 13-59

subtypes (charts) 13-76

SUM function 13-57

Sum function 13-62

summary values 13-57, 13-62

T

tables

aggregating data and 13-61, 13-63, 13-64

counting rows in 13-53, 13-62

TACACS+ settings

configuring 18-1

templates 13-26, 13-76

testing

character patterns 13-69

for non-null values 13-56

for null values 13-54, 13-69

range of values 13-69

sets of values 13-69

text

aggregating values for 13-63

changing label 13-26

converting case 13-32

searching for 13-53, 13-57

text files 13-23, 13-24

text formats 13-30

text patterns 13-69

text styles 13-38

themes 13-76

thousands separators 13-30

time data types 13-29

time formats 13-29, 13-33

timesaver, description of ii-xxiv

time stamps 13-56, 13-57

time values 13-33, 13-49

TODAY function 13-57

Top N condition 13-68

Top Percent condition 13-68

totals 13-36, 13-57, 13-62

trailing characters 13-58

TRIM function 13-58

TRIMLEFT function 13-58

TRIMRIGHT function 13-58

troubleshooting

connectivity 14-1

expert troubleshooter 14-2

support bundles 14-1

true function 13-58

TrustSec 4-23

U

Unformatted format option 13-29, 13-30

uppercase characters 13-58

Uppercase format option 13-30

UPPER function 13-58

V

values

averaging 13-52, 13-56, 13-58, 13-62

calculating 13-40

comparing 13-36, 13-37, 13-69

counting number of distinct 13-53, 13-62

determining rank 13-57

displaying frequently occurring 13-62

hiding duplicate 13-65, 13-66

returning highest 13-55, 13-62

returning last 13-55, 13-62

returning lowest 13-55, 13-62, 13-68

returning null 13-68

returning specified 13-68

rounding 13-52, 13-57

searching for 13-70

sorting highest or lowest 13-73

testing for non-null 13-56

testing for null 13-54, 13-69

testing for specified 13-54

testing range of 13-69

testing sets of 13-69

value series 13-74

VAR function 13-58

variance 13-58, 13-62

Variance function 13-62

viewers 13-20

viewing

data 13-29, 13-40, 13-65

detail rows 13-66

reports 13-19

specific report pages 13-21, 13-22

table of contents 13-22

viewing environments 13-19

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

WEEK function 13-58

WEIGHTEDAVERAGE function 13-58

Weighted average function 13-62

wildcard characters 13-57

X

x-axis values 13-74

Y

y-axis values 13-74

YEAR function 13-58