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 11-17

% operator 11-42

& formatting symbol 11-17

& operator 11-42

* operator 11-41

+ operator 11-41

/ operator 11-41

<= operator 11-42

<> operator 11-42

< formatting symbol 11-17

< operator 11-42

= operator 11-42

>= operator 11-42

> formatting symbol 11-17

> operator 11-42

@ formatting symbol 11-17

- operator 11-41

A

ABS function 11-35

absolute values 11-35

accessing

data 11-47

Interactive Viewer 11-5

table of contents entries 11-7

ADD_DAY function 11-35

ADD_HOUR function 11-35

ADD_MINUTE function 11-35

ADD_MONTH function 11-35

ADD_QUARTER function 11-35

ADD_SECOND function 11-35

ADD_WEEK function 11-35

ADD_YEAR function 11-35

Add Group command 11-32

adding

aggregate rows 11-45, 11-46

data filters 11-49, 11-51, 11-52, 11-53

data groups 11-31, 11-32

formatting rules 11-20

page breaks 11-23

addition operator 11-41

Advanced Filter dialog 11-53, 11-54

Advanced Sort command 11-29

aggregate functions 11-44, 11-45

aggregate rows

creating 11-45, 11-46

formatting data in 11-13

aggregate values 11-24

Aggregation dialog 11-45

aligning data 11-12

alignment options 11-12

AND operator 11-42, 11-54

Any Of condition 11-50

arguments 11-34

Arrange Columns dialog 11-25

ascending sort order 11-29

AVERAGE function 11-35

Average function 11-44

averages 11-35, 11-39, 11-41, 11-44, 11-45

B

background colors 11-22

Between condition 11-50, 11-54

BETWEEN function 11-35

Between operator 11-21

blank characters 11-40

Boolean values 11-36, 11-41, 11-50

Bottom N condition 11-50

Bottom Percent condition 11-50

C

calculated columns

aggregating data and 11-44, 11-45, 11-46

creating 11-33, 11-41

placing values in 11-36

Calculation dialog 11-34, 11-42, 11-43

calculations 11-24

case conversions 11-17

case-insensitive searches 11-40

case-sensitive searches 11-36

category series 11-55

cautions

description i-xx

CEILING function 11-35

changing

aggregate values 11-13

chart subtypes 11-57

column headers 11-8, 11-11

conditional formats 11-20

data filters 11-53

default formats 11-12

labels 11-11

reports 11-5

character patterns 11-40, 11-51

character placeholder 11-17

charts

overview 11-55

Chart Subtype command 11-57

Cisco CAT 6K 4-25

clearing data filters 11-53

closing Standard Viewer 11-5

collapsing data groups 11-32, 11-48, 11-49

colors 11-22

column headers 11-8

column names 11-52

Column Properties dialog 11-12

columns

aligning data in 11-12

changing order of 11-25

counting rows in 11-44

deleting 11-26

determining first value in 11-36, 11-44

determining last value in 11-37, 11-44

determining type 11-15

displaying data in 11-13

formatting data in 11-20

grouping date and time values in 11-32

resizing 11-8, 11-12

sorting data in 11-29, 11-55

Column Width command 11-12

comma-separated values files. See CSV files

comparison filters 11-51

comparison operators 11-21, 11-51

comparisons 11-20, 11-21, 11-36

concatenation operator 11-42

Conditional Formatting dialog 11-20, 11-22

conditional formatting rules 11-20

conditions

filtering data and 11-49, 11-50, 11-53

formatting data and 11-19

context menus 11-5

conversions 11-17

COUNT_DISTINCT function 11-36

COUNT function 11-35

Count function 11-44

Count Value function 11-44

creating

aggregate rows 11-45, 11-46

calculated columns 11-33, 11-41

data filters 11-49, 11-51, 11-52, 11-53

data groups 11-31, 11-32

formatting rules 11-20

CSV files 11-8, 11-9

currency 11-15

Currency format option 11-14

currency formatting options 11-15

currency symbols 11-15

Custom format option 11-14

customizing

formats 11-16

D

data

accessing 11-47

aligning 11-12

displaying 11-13, 11-24, 11-47

hiding 11-26

plotting relationships for 11-55

data filters 11-49, 11-51, 11-52, 11-53

data points 11-55

data rows 11-47, 11-48

data sections 11-48, 11-49

data sets 11-24, 11-44, 11-47, 11-55

data sources 11-9, 11-15, 11-29, 11-47

data types 11-15

Date and Time Format dialog 11-18

date calculations 11-43

date data types 11-14

date expressions 11-42, 11-43

date formats 11-14, 11-18

Date or Time Column Format dialog 11-19

date values 11-18, 11-32, 11-36

DAY function 11-36

decimal values 11-15

default formats 11-12

deleting

columns 11-26

conditional formats 11-22

data filters 11-53

filter conditions 11-54

page breaks 11-24

delimited text files 11-8, 11-9

descending sort order 11-29

designs

hiding data in 11-47

organizing data in 11-24

saving 11-10

DIFF_DAY function 11-36

DIFF_HOUR function 11-36

DIFF_MINUTE function 11-36

DIFF_MONTH function 11-36

DIFF_QUARTER function 11-36

DIFF_SECOND function 11-36

DIFF_WEEK function 11-36

DIFF_YEAR function 11-36

displaying

data 11-13, 11-24, 11-47

detail rows 11-48

reports 11-4

specific report pages 11-6, 11-7

table of contents 11-6

distinct values 11-36, 11-44

division 11-38, 11-41

division operator 11-41

duplicate values 11-47, 11-48

E

EAP-FAST

enabling B-24

identity protection B-17

logging B-17

master keys

definition B-19

PAC

automatic provisioning B-21

definition B-19

manual provisioning B-22

refresh B-23

phases B-17

equality 11-42, 11-54

equality operator 11-42

Equal to condition 11-50

Excel spreadsheets 11-8

expanding sections or groups 11-48

expanding table of contents entries 11-7

Export Data dialog 11-8

expressions

calculating data and 11-41, 11-42

filtering data and 11-49, 11-50, 11-51, 11-53, 11-54

F

false function 11-36

fields 11-11

filter conditions 11-49, 11-50, 11-53, 11-54

Filter dialog 11-52, 11-53

Filter drop-down list 11-55

filters 11-49, 11-51, 11-52, 11-53

FIND function 11-36

finding text values 11-36, 11-40

FIRST function 11-36

First function 11-44

Fixed format option 11-14

fixed numeric values 11-15

Font dialog box 11-22

fonts 11-22, 11-57

footers 11-44

Format Chart page 11-57

Format command 11-57

format patterns 11-16, 11-17

formats

changing 11-12, 11-20

customizing 11-16

data types and 11-13

deleting conditional 11-22

exporting data and 11-8

previewing conditional 11-22

selecting 11-15

formatting

column headers 11-11

labels 11-11

string data 11-16

formatting options 11-15, 11-16, 11-18

formatting rules 11-20

formatting symbols 11-16, 11-17

functions 11-34, 11-44, 11-45

G

General Date format option 11-14

General Number format option 11-14

Go to page pick list 11-6

Greater Than condition 11-50

greater than operator 11-42

Greater Than or Equal to condition 11-50

greater than or equal to operator 11-42

Group Detail dialog 11-32

grouping

filter conditions 11-54

grouping intervals 11-32

groups

adding 11-31, 11-32

aggregating data and 11-44

collapsing 11-32, 11-48, 11-49

counting rows for 11-35

displaying data and 11-24, 11-47

setting page breaks for 11-23, 11-24

sorting data and 11-30

H

headers 11-8, 11-44

hidden items 11-27

Hide Column command 11-27

Hide Detail command 11-49

Hide or Show Items dialog 11-26

hiding

detail rows 11-48

duplicate values 11-47, 11-48

report items 11-26

HTML files 11-9, 11-10

I

IETF RADIUS attributes A-5

If...Then...Else statement 11-37

IF function 11-37

information objects 11-13

IN function 11-37

Interactive Viewer 11-5

ISBOTTOMN function 11-37

ISBOTTOMNPERCENT function 11-37

Is False condition 11-50

Is False operator 11-21

Is Not Null condition 11-50

Is Not Null operator 11-21

Is Null condition 11-50

ISNULL function 11-37

Is Null operator 11-21

ISTOPN function 11-37

ISTOPNPERCENT function 11-37

Is True condition 11-50

Is True operator 11-21

L

labels 11-11

formatting 11-11

LAST function 11-37

Last function 11-44

leading characters 11-40

LEFT function 11-38

LEN function 11-38

Less Than condition 11-50

less than operator 11-42

Less Than or Equal to condition 11-50

less than or equal to operator 11-42

Like condition 11-50

LIKE function 11-38

literal values 11-54

locales

creating charts and 11-57

customizing formats for 11-13, 11-15, 11-18

locating text values 11-36, 11-40

logical operators 11-41

Long Date format option 11-14

Long Time format option 11-14

lowercase characters 11-38

Lowercase format option 11-14

LOWER function 11-38

M

master key

definition B-19

matching character patterns 11-51

mathematical functions 11-34

mathematical operators 11-41

MAX function 11-38

Max function 11-44

MEDIAN function 11-38

Median function 11-44

median values 11-38, 11-44

Medium Date format option 11-14

Medium Time format option 11-14

membership filters 11-51

menus 11-5

MIN function 11-38

Min function 11-44

Mode function 11-44

MOD function 11-38

MONTH function 11-38, 11-39

Move to Group Header command 11-25

Move to Group Header dialog 11-25

MOVINGAVERAGE function 11-39

moving columns 11-25

moving through reports 11-6

multipage reports 11-48

multiplication 11-42

multiplication operator 11-41

N

naming

calculated columns 11-42

navigating through reports 11-6

navigational tools 11-6

negative numbers 11-15

non-null values 11-37, 11-39, 11-50

Not Between condition 11-50

Not Between operator 11-21

note, description of i-xx

Not Equal to condition 11-50

not equal to operator 11-42

Not Like condition 11-50

NOTNULL function 11-39

NOT operator 11-42, 11-54

NOW function 11-39

null value filters 11-51

null values 11-37, 11-39, 11-50, 11-51

Number Column Format dialog 11-15

Number column format dialog 11-16

number formats 11-14, 11-15, 11-16

numeric data types 11-14

numeric expressions 11-42

numeric values 11-8, 11-16

O

opening

exported data files 11-9

Interactive Viewer 11-5

operators 11-21, 11-41

OR operator 11-42, 11-54

P

PAC

automatic provisioning B-21

definition B-19

manual provisioning B-22

refresh B-23

Page Break on Group dialog 11-23

page breaks 11-23, 11-24

paging toolbar 11-6

pattern-matching filters 11-51

PDF files 11-9, 11-10

PEAP

identity protection B-13

phases B-13

percentage operator 11-42

percentages 11-15, 11-37, 11-39

Percent format option 11-14

PERCENTILE function 11-39

PERCENTRANK function 11-39

PERCENTSUM function 11-39

previewing conditional formats 11-22

primary sorting column 11-30

Print dialog 11-10

printing 11-9

printing options 11-9

Q

QUARTER function 11-39

QUARTILE function 11-39

Quartile function 11-44

R

range filters 11-51

range of values 11-20, 11-21, 11-50, 11-51

RANK function 11-39, 11-40

relationships 11-55

Reorder Columns command 11-25

report designs

hiding data in 11-47

organizing data in 11-24

saving 11-10

report items 11-26

reports

changing 11-5

displaying 11-4

navigating through 11-6

printing 11-9

setting page breaks for 11-23

viewing specific pages in 11-6, 11-7

report sections 11-48, 11-49

report templates 11-11, 11-57

report viewers 11-5

resizing columns 11-8, 11-12

RIGHT function 11-40

ROUNDDOWN function 11-40

ROUND function 11-40

rounding 11-35, 11-40

ROUNDUP function 11-40

row-by-row comparisons 11-36

rows 11-47, 11-48

RUNNINGSUM function 11-40

running totals 11-40

S

Save As dialog 11-9

saving

exported data 11-9

report designs 11-10

Scientific format option 11-14

scientific numbers 11-15

SEARCH function 11-40

searching 11-36, 11-40, 11-52

sections 11-48, 11-49

Select data item dialog 11-52

Short Date format option 11-14

Short Time format option 11-14

Show Columns command 11-27

Show Columns dialog 11-27

Show Detail command 11-49

sorting multiple columns 11-30

sort order 11-29

spreadsheet reports 11-8

SQRT function 11-40

square roots 11-40

standard deviation 11-40, 11-44

Standard Deviation function 11-44

Standard Viewer 11-5

STDEV function 11-40

String Column Format dialog 11-17

String column format dialog 11-16

string conversions 11-17

string data types 11-14

string fields 11-51

string patterns 11-40

strings 11-16, 11-38, 11-50

substrings 11-38, 11-40, 11-50

subtraction operator 11-41

subtypes (charts) 11-57

SUM function 11-40

Sum function 11-44

summary values 11-40, 11-44

T

tables

aggregating data and 11-44, 11-45, 11-46

counting rows in 11-35, 11-44

templates 11-11, 11-57

testing

character patterns 11-51

for non-null values 11-39

for null values 11-37, 11-51

range of values 11-51

sets of values 11-51

text

aggregating values for 11-45

changing label 11-11

converting case 11-17

searching for 11-36, 11-40

text files 11-8, 11-9

text formats 11-14

text patterns 11-51

text styles 11-22

themes 11-57

thousands separators 11-15

time data types 11-14

time formats 11-14, 11-18

timesaver, description of i-xx

time stamps 11-39, 11-40

time values 11-18, 11-32

TODAY function 11-40

Top N condition 11-50

Top Percent condition 11-50

totals 11-20, 11-40, 11-44

trailing characters 11-40

TRIM function 11-40

TRIMLEFT function 11-40

TRIMRIGHT function 11-41

true function 11-41

TrustSec 4-25

U

Unformatted format option 11-14

uppercase characters 11-41

Uppercase format option 11-14

UPPER function 11-41

V

values

averaging 11-35, 11-39, 11-41, 11-44, 11-45

calculating 11-24

comparing 11-20, 11-21, 11-51

counting number of distinct 11-36, 11-44

determining rank 11-39

displaying frequently occurring 11-44

hiding duplicate 11-47, 11-48

returning highest 11-38, 11-44

returning last 11-37, 11-44

returning lowest 11-38, 11-44, 11-50

returning null 11-50

returning specified 11-50

rounding 11-35, 11-40

searching for 11-52

sorting highest or lowest 11-55

testing for non-null 11-39

testing for null 11-37, 11-51

testing for specified 11-37

testing range of 11-51

testing sets of 11-51

value series 11-55

VAR function 11-41

variance 11-41, 11-45

Variance function 11-45

vendor-specific attributes (VSAs) A-5

viewers 11-5

viewing

data 11-13, 11-24, 11-47

detail rows 11-48

reports 11-4

specific report pages 11-6, 11-7

table of contents 11-6

viewing environments 11-4

W

WEEKDAY function 11-41

WEEK function 11-41

WEIGHTEDAVERAGE function 11-41

Weighted average function 11-45

wildcard characters 11-40

X

x-axis values 11-55

Y

y-axis values 11-55

YEAR function 11-41