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

& formatting symbol 13-32

& operator 13-58

* operator 13-57

+ operator 13-57

/ operator 13-57

<= operator 13-58

<> operator 13-58

< formatting symbol 13-33

< operator 13-58

= operator 13-58

>= operator 13-58

> formatting symbol 13-33

> operator 13-58

@ formatting symbol 13-32

- operator 13-57

A

ABS function 13-51

absolute values 13-51

accessing

data 13-63

Interactive Viewer 13-20

table of contents entries 13-23

acs distributed deployment 17-1

ADD_DAY function 13-51

ADD_HOUR function 13-51

ADD_MINUTE function 13-51

ADD_MONTH function 13-51

ADD_QUARTER function 13-51

ADD_SECOND function 13-51

ADD_WEEK function 13-51

ADD_YEAR function 13-51

Add Group command 13-48

adding

aggregate rows 13-61, 13-62

data filters 13-65, 13-67, 13-68, 13-69

data groups 13-47, 13-48

formatting rules 13-35, 13-36

page breaks 13-39

addition operator 13-57

administrator access setting 16-11

administrator password policy 16-9

administrator password reset 16-12

administrator roles 16-2

Advanced Filter dialog 13-69, 13-70

Advanced Sort command 13-45

aggregate functions 13-60, 13-61

aggregate rows

creating 13-61, 13-62

formatting data in13-28to 13-29

aggregate values 13-40

Aggregation dialog 13-61

alarms 12-1

syslog targets 12-30

system alarms 12-29

alarm schedules 12-5

aligning data 13-28

alignment options 13-28

AND operator 13-58, 13-70

Any Of condition 13-66

arguments 13-50

Arrange Columns dialog 13-40

ascending sort order 13-45

AVERAGE function 13-51

Average function 13-60

averages 13-51, 13-55, 13-57, 13-60, 13-61

B

background colors 13-37

Between condition 13-66, 13-70

BETWEEN function 13-51

Between operator 13-37

blank characters 13-56

Boolean values 13-52, 13-57, 13-66

Bottom N condition 13-66

Bottom Percent condition 13-66

C

calculated columns

aggregating data and 13-60, 13-61, 13-62

creating 13-49, 13-57

placing values in 13-52

Calculation dialog 13-50, 13-58, 13-59

calculations 13-40

case conversions 13-33

case-insensitive searches 13-56

case-sensitive searches 13-52

category series 13-71

cautions

description ii-xxiv

CEILING function 13-51

changing

aggregate values 13-28

chart subtypes 13-73

column headers 13-23, 13-26

conditional formats 13-36

data filters 13-69

default formats 13-27

labels 13-26

reports 13-20

character patterns 13-56, 13-67

character placeholder 13-32

charts

overview 13-71

Chart Subtype command 13-73

Cisco CAT 6K 4-22

clearing data filters 13-69

closing Standard Viewer 13-20

collapsing data groups 13-48, 13-64, 13-65

colors 13-37

column headers 13-23

column names 13-68

Column Properties dialog 13-28

columns

aligning data in 13-28

changing order of 13-40

counting rows in 13-60

deleting 13-42

determining first value in 13-52, 13-60

determining last value in 13-53, 13-60

determining type 13-30

displaying data in 13-29

formatting data in 13-35, 13-36

grouping date and time values in 13-48

resizing 13-24, 13-28

sorting data in 13-45, 13-71

Column Width command 13-28

comma-separated values files. See CSV files

comparison filters 13-67

comparison operators 13-36, 13-67

comparisons 13-36, 13-52

concatenation operator 13-58

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

conditional formatting rules 13-35, 13-36

conditions

filtering data and 13-65, 13-66, 13-69

formatting data and 13-35

context menus 13-20

conversions 13-33

COUNT_DISTINCT function 13-52

COUNT function 13-51

Count function 13-60

Count Value function 13-60

creating

aggregate rows 13-61, 13-62

calculated columns 13-49, 13-57

data filters 13-65, 13-67, 13-68, 13-69

data groups 13-47, 13-48

formatting rules 13-35, 13-36

crud operations 7-5

CSV files 13-23, 13-25

currency 13-31

Currency format option 13-30

currency formatting options 13-31

currency symbols 13-31

Custom format option 13-29, 13-30

customizing

formats 13-31, 13-32

D

data

accessing 13-63

aligning 13-28

displaying 13-29, 13-40, 13-63

hiding 13-42

plotting relationships for 13-71

data filters 13-65, 13-67, 13-68, 13-69

data points 13-71

data rows 13-63, 13-64

data sections 13-64, 13-65

data sets 13-40, 13-60, 13-63, 13-71

data sources 13-25, 13-30, 13-45, 13-63

data types 13-30

Date and Time Format dialog 13-34

date calculations 13-59

date data types 13-29

date expressions 13-58, 13-59

date formats 13-29, 13-34

Date or Time Column Format dialog 13-34

date values 13-34, 13-48, 13-52

DAY function 13-52

decimal values 13-31

default formats 13-27, 13-28

default network device 7-16

deleting

columns 13-42

conditional formats 13-38

data filters 13-69

filter conditions 13-70

page breaks 13-39

delimited text files 13-23, 13-25

descending sort order 13-45

designs

hiding data in 13-63

organizing data in 13-40

saving 13-25

DIFF_DAY function 13-52

DIFF_HOUR function 13-52

DIFF_MINUTE function 13-52

DIFF_MONTH function 13-52

DIFF_QUARTER function 13-52

DIFF_SECOND function 13-52

DIFF_WEEK function 13-52

DIFF_YEAR function 13-52

displaying

data 13-29, 13-40, 13-63

detail rows 13-64

reports 13-20

specific report pages 13-22, 13-23

table of contents 13-22

distinct values 13-52, 13-60

division 13-54, 13-57

division operator 13-57

downloads 18-42

duplicate values 13-63, 13-64

E

EAP-FAST

enabling B-25

identity protection B-19

logging B-19

master keys

definition B-20

PAC

automatic provisioning B-22

definition B-20

manual provisioning B-23

refresh B-25

phases B-18

EAP-FAST settings

configuring 18-3

EAP-TLS settings

configuring 18-2

equality 13-58, 13-70

equality operator 13-58

Equal to condition 13-66

Excel spreadsheets 13-23

expanding sections or groups 13-64

expanding table of contents entries 13-23

Export Data dialog 13-24

expressions

calculating data and 13-57, 13-58

filtering data and 13-65, 13-66, 13-67, 13-69, 13-70

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

fields 13-26

filter conditions 13-65, 13-66, 13-69, 13-70

Filter dialog 13-68, 13-69

Filter drop-down list 13-71

filters 13-65, 13-67, 13-68, 13-69

FIND function 13-52

finding text values 13-52, 13-56

FIRST function 13-52

First function 13-60

Fixed format option 13-30

fixed numeric values 13-31

Font dialog box 13-37

fonts 13-37, 13-73

footers 13-60

Format Chart page 13-73

Format command 13-73

format patterns 13-31, 13-33

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

formatting

column headers 13-27

labels 13-26, 13-27

string data 13-32

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

formatting rules 13-35, 13-36

formatting symbols 13-31, 13-32

functions 13-50, 13-60, 13-61

G

General Date format option 13-29

General Number format option 13-30

Go to page pick list 13-22

Greater Than condition 13-66

greater than operator 13-58

Greater Than or Equal to condition 13-66

greater than or equal to operator 13-58

Group Detail dialog 13-48

grouping

filter conditions 13-70

grouping intervals 13-48

groups

adding 13-47, 13-48

aggregating data and 13-60

collapsing 13-48, 13-64, 13-65

counting rows for 13-51

displaying data and 13-40, 13-63

setting page breaks for 13-39

sorting data and 13-46

H

headers 13-23, 13-60

hidden items 13-42

Hide Column command 13-43

Hide Detail command 13-65

Hide or Show Items dialog 13-42

hiding

detail rows 13-64

duplicate values 13-63, 13-64

report items 13-42

HTML files 13-25

I

identity store sequences 8-65

If...Then...Else statement 13-53

IF function 13-53

import and export

creating import files 5-20

supported objects 5-18

information objects 13-29

IN function 13-53

Interactive Viewer 13-20

internal identity stores 8-1

ISBOTTOMN function 13-53

ISBOTTOMNPERCENT function 13-53

Is False condition 13-66

Is False operator 13-36

Is Not Null condition 13-66

Is Not Null operator 13-36

Is Null condition 13-66

ISNULL function 13-53

Is Null operator 13-36

ISTOPN function 13-53

ISTOPNPERCENT function 13-53

Is True condition 13-66

Is True operator 13-36

L

labels 13-26, 13-27

formatting 13-27

LAST function 13-53

Last function 13-60

leading characters 13-56

LEFT function 13-54

LEN function 13-54

Less Than condition 13-66

less than operator 13-58

Less Than or Equal to condition 13-66

less than or equal to operator 13-58

licensing 18-35

Like condition 13-66

LIKE function 13-54

literal values 13-70

locales

creating charts and 13-73

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

locating text values 13-52, 13-56

logical operators 13-57

Long Date format option 13-29

Long Time format option 13-29

lowercase characters 13-54

Lowercase format option 13-30

LOWER function 13-54

M

master key

definition B-20

matching character patterns 13-67

mathematical functions 13-50

mathematical operators 13-57

MAX function 13-54

Max function 13-60

MEDIAN function 13-54

Median function 13-60

median values 13-54, 13-60

Medium Date format option 13-29

Medium Time format option 13-29

membership filters 13-67

menus 13-20

migration

common scenarios 2-7

considerations 2-3

downloads 2-3

requirements 2-2

supported versions 2-2

MIN function 13-54

Min function 13-60

Mode function 13-60

MOD function 13-54

monitoring & report viewer

configuring remote database 15-16

data backup and purge 15-2

data upgrade status 15-11

restore 15-5

viewing process status 15-10

viewing scheduled jobs 15-10

monitoring and report viewer

dashboard 11-3

MONTH function 13-54, 13-55

Move to Group Header command 13-41

Move to Group Header dialog 13-41

MOVINGAVERAGE function 13-55

moving columns 13-40

moving through reports 13-22

multipage reports 13-64

multiplication 13-58

multiplication operator 13-57

N

naming

calculated columns 13-58

navigating through reports 13-22

navigational tools 13-22

negative numbers 13-31

non-null values 13-53, 13-55, 13-66

Not Between condition 13-66

Not Between operator 13-37

note, description of ii-xxiv

Not Equal to condition 13-66

not equal to operator 13-58

Not Like condition 13-66

NOTNULL function 13-55

NOT operator 13-58, 13-70

NOW function 13-55

null value filters 13-67

null values 13-53, 13-55, 13-66, 13-67

Number Column Format dialog 13-30, 13-31

Number column format dialog 13-32

number formats 13-30, 13-31

numeric data types 13-30

numeric expressions 13-58

numeric values 13-23, 13-31

O

opening

exported data files 13-25

Interactive Viewer 13-20

operators 13-36, 13-57

OR operator 13-58, 13-70

P

PAC

automatic provisioning B-22

definition B-20

manual provisioning B-23

refresh B-25

Page Break on Group dialog 13-39

page breaks 13-39

paging toolbar 13-22

pattern-matching filters 13-67

PDF files 13-25

PEAP

identity protection B-14

phases B-14

PEAP settings

configuring 18-3

percentage operator 13-58

percentages 13-31, 13-53, 13-55

Percent format option 13-30

PERCENTILE function 13-55

PERCENTRANK function 13-55

PERCENTSUM function 13-55

previewing conditional formats 13-38

primary sorting column 13-45

Print dialog 13-25

printing 13-25

printing options 13-25

Q

QUARTER function 13-55

QUARTILE function 13-55

Quartile function 13-60

R

RADIUS proxy 4-27

configuring proxy service 4-29

supported protocols 4-28

supported RADIUS attributes 4-29

range filters 13-67

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

RANK function 13-55, 13-56

relationships 13-71

Reorder Columns command 13-40

report designs

hiding data in 13-63

organizing data in 13-40

saving 13-25

report items 13-42

reports 13-1

catalog 13-7

changing 13-20

displaying 13-20

dynamic change of authorization 13-2

favorites 13-3

navigating through 13-22

printing 13-25

setting page breaks for 13-39

shared 13-7

viewing specific pages in 13-22, 13-23

report sections 13-64, 13-65

report templates 13-27, 13-73

report viewers 13-20

resizing columns 13-24, 13-28

RIGHT function 13-56

ROUNDDOWN function 13-56

ROUND function 13-56

rounding 13-51, 13-56

ROUNDUP function 13-56

row-by-row comparisons 13-52

rows 13-63, 13-64

RUNNINGSUM function 13-56

running totals 13-56

S

Save As dialog 13-25

saving

exported data 13-25

report designs 13-25

Scientific format option 13-30

scientific numbers 13-31

SEARCH function 13-56

searching 13-52, 13-56, 13-68

sections 13-64, 13-65

Select data item dialog 13-68

Short Date format option 13-29

Short Time format option 13-29

Show Columns command 13-43

Show Columns dialog 13-43

Show Detail command 13-65

software

updates 17-21

sorting multiple columns 13-45

sort order 13-45

spreadsheet reports 13-23

SQRT function 13-56

square roots 13-56

standard deviation 13-56, 13-60

Standard Deviation function 13-60

Standard Viewer 13-20

STDEV function 13-56

String Column Format dialog 13-33

String column format dialog 13-32

string conversions 13-33

string data types 13-30

string fields 13-67

string patterns 13-56

strings 13-32, 13-54, 13-66

substrings 13-54, 13-56, 13-66

subtraction operator 13-57

subtypes (charts) 13-73

SUM function 13-56

Sum function 13-60

summary values 13-56, 13-60

T

tables

aggregating data and 13-60, 13-61, 13-62

counting rows in 13-51, 13-60

TACACS+ settings

configuring 18-1

templates 13-27, 13-73

testing

character patterns 13-67

for non-null values 13-55

for null values 13-53, 13-67

range of values 13-67

sets of values 13-67

text

aggregating values for 13-61

changing label 13-26

converting case 13-33

searching for 13-52, 13-56

text files 13-23, 13-25

text formats 13-30

text patterns 13-67

text styles 13-37

themes 13-73

thousands separators 13-31

time data types 13-29

time formats 13-29, 13-34

timesaver, description of ii-xxiv

time stamps 13-55, 13-56

time values 13-34, 13-48

TODAY function 13-56

Top N condition 13-66

Top Percent condition 13-66

totals 13-36, 13-56, 13-60

trailing characters 13-56

TRIM function 13-56

TRIMLEFT function 13-56

TRIMRIGHT function 13-57

troubleshooting

connectivity 14-1

expert troubleshooter 14-2

support bundles 14-1

true function 13-57

TrustSec 4-22

U

Unformatted format option 13-29, 13-30

uppercase characters 13-57

Uppercase format option 13-30

UPPER function 13-57

V

values

averaging 13-51, 13-55, 13-57, 13-60, 13-61

calculating 13-40

comparing 13-36, 13-67

counting number of distinct 13-52, 13-60

determining rank 13-55

displaying frequently occurring 13-60

hiding duplicate 13-63, 13-64

returning highest 13-54, 13-60

returning last 13-53, 13-60

returning lowest 13-54, 13-60, 13-66

returning null 13-66

returning specified 13-66

rounding 13-51, 13-56

searching for 13-68

sorting highest or lowest 13-71

testing for non-null 13-55

testing for null 13-53, 13-67

testing for specified 13-53

testing range of 13-67

testing sets of 13-67

value series 13-71

VAR function 13-57

variance 13-57, 13-61

Variance function 13-61

viewers 13-20

viewing

data 13-29, 13-40, 13-63

detail rows 13-64

reports 13-20

specific report pages 13-22, 13-23

table of contents 13-22

viewing environments 13-20

vpn remote access 4-19

configuring access service 4-21

supported clients 4-21

supported identity stores 4-20

supported network access servers 4-20

supported protocols 4-19

W

WEEKDAY function 13-57

WEEK function 13-57

WEIGHTEDAVERAGE function 13-57

Weighted average function 13-61

wildcard characters 13-56

X

x-axis values 13-71

Y

y-axis values 13-71

YEAR function 13-57