|
Menu item
|
Description
|
Script command
|
|
File
|
|
|
|
New...
|
Open or create a new project
|
|
|
Open...
|
Open a previously saved nextanalytics project
|
|
|
Save
|
Save your work in progress to a project file
|
|
|
Save As...
|
Save your work under a new project file name
|
SaveAsProject
|
|
Save/View...
|
Save your changes and look at the underlying script; you can also save to a new file name here
|
|
|
Export...
|
Saves the page as data
|
SavePageToCSV
SavePageToCSVPivot
SavePageToNOD
SavePageToXMLCrosstab
|
|
Add SQL...
|
Add a SQL query, results will be loaded into new page
|
Query,Command
Query,CommandAppend
Query,Captions
Query,CommandTimeout
Query,Roles
Query,RowLabel
Query,TextColumnNames Query,RunSave,ODBC/Oracle/SQL
Query,Run,ODBC/Oracle/SQL
|
|
Add CSV...
|
Add a CSV file, contents will be loaded into new page
|
AddData
AddPage
ImportData
ImportDataNoHeader
|
|
Add NOD...
|
Add a previously exported data cache file (NOD file), contents will be loaded into a new page
|
AddData
|
|
Run...
|
Run a script from the script directory
|
RunScript
|
| |
|
|
|
Edit
|
|
|
|
Search...
|
Search for text and mark the found rows as selected
|
SearchAndSelect
|
|
Range select...
|
Select a range of rows or columns starting at a certain point for a count of items; this can count from last
|
SelectRange
|
|
Invert row selection
|
Flip the currently selected rows to being unselected, and vice-versa for the currently un-selected
|
InvertSelection
|
|
Invert column selection
|
Flip the currently selected columns to being unselected, and vice-versa for the currently un-selected
|
InvertSelection
|
|
Clear selection
|
Remove the selection state on all rows or columns
|
ClearSelection
|
|
Keep selections
|
Keep rows only if they are selected; this is the same as remove unselected
|
KeepSelected
|
|
Remove selections
|
Remove rows if they are selected; this is the same keep unselected
|
RemoveSelected
|
|
Numeric format...
|
Assign numeric format to columns
|
AssignCellFormat
PageNumericFormat
|
|
Column style...
|
Assign a cascading style sheet element to columns
|
AssignColumnCSS
|
|
Show or hide pages...
|
Identify pages as being hidden or visible. This is also useful for switching to a page which has been hidden.
|
HidePage
ShowPage
|
|
Hide all but current page
|
Mark all but the current page as hidden
|
HidePagesExcept
|
|
Remove page
|
Reduces the resources being consumed by the current page
|
RemovePage
|
|
Titles...
|
Change the page title and page description
|
PageCaption
PageDescription
PageDescriptionAppend
|
|
Text/Date columns...
|
Assign a new name to a Text Column
|
NewTextColumnNameNewRowLabel
|
|
Row labels and data columns...
|
Assign new names to row labels or numeric column captions
|
ChangeLabelCaption
|
|
Text column values...
|
Changes the Values in a Text Column
|
ChangeTextInTextColumn
|
| |
|
|
|
Data
|
|
|
|
Sort rows...
|
Sorts rows according to a row label, text column, or numeric column
|
Sort
SortRowLabel
SortTextColumn
SortByDate
|
|
Sort columns...
|
Sorts column labels, text or numerically
|
SortColumnLabel
SortCustom
|
|
Reverse...
|
Reverses the order of the rows or columns
|
Reverse
|
|
Text from Date...
|
Select portions from a date column to create a new text column from
|
CreateTextColumnFromDateColumn
|
|
Delete text or date...
|
Removes a text or date column
|
DeleteTextColumn
|
|
Make Crosstab...
|
The text column is moved to the column axis. The unique values from the text column become the new data columns. This creates a new crosstab for each selected data column.
|
SwapTextColumnWithColumn
|
|
Concatenate text...
|
Adds multiple text columns to create one new text column
|
ConcatenateTextColumns
|
|
Split text...
|
Creates two new text columns, separating them where a character is found
|
SplitTextColumn
|
|
Copy data to text
|
Copies Selected Data Columns To be Text Columns; Gives access to some useful functions usually associated with text like Combine similar or Compare similar
|
CopyDataToTextColumns
|
|
Exchange text with row label...
|
The text column becomes the new row label and the row label is converted to being a text column
|
SwapTextColumnWithRowLabel
|
|
Move/Copy rows...
|
Moves or copies selected rows within a page or copies them to another page
|
MoveRows
|
|
Move/Copy columns...
|
Moves or copies selected columns within a page or copies them to another page
|
MoveColumns
|
|
Swap rows and columns
|
Exchanges the data on the row axis with the column
|
Swap
|
|
Group by row labels
|
Each unique row label is put onto its own page
|
MoveRowLabelsToPages
|
|
Group by text values...
|
Each unique text column value is put onto its own page
|
MoveTextColumnValuesToPages
|
|
Concatenate pages...
|
Pages with matching text in their title are combined into a single page
|
ConcatenatePagesWith
|
| |
|
|
|
Calculate
|
|
|
|
Combine...
|
Perform math operations on sets of rows or columns to create a newly calculated row or column
|
Combine
|
|
Combine similar...
|
Rows that have the same label or a value from one text column will be combined to form a new page
|
CombineSimilar
|
|
Combine duplicate...
|
Duplicate rows are combined to form a new page
|
CombineDuplicates
|
|
Math...
|
Using a value you provide, perform simple math operations such as Divide, Multiply, Subtract, Add and Fill on a set of columns.
|
MathOperation
|
|
Two Column...
|
Allows you to add, subtract, multiple, divide, and calculate growth, ratio, and percent on two columns
|
MathOperationOnTwoPositions
|
|
Rolling...
|
Repeats your choice of math operations from left to right, across all columns; each calculation can span a sub-range of columns relative to the current position
|
RollingPeriods
|
|
Cumulative...
|
Repeat the same calculation over and over again, each one with an increasing range of rows or columns from the start to the current position
|
MathOperation,Cumulative
|
|
Growth
|
Repeat a Growth calculation, left to right, for every column
|
RepeatingCalculation,Growth
|
|
Net change
|
Repeat Difference calculation, left to right, for every column
|
RepeatingCalculation,Diff
|
|
Percentages
|
Repeat Percent calculation, left to right, for every column
|
RepeatingCalculation,Percent
|
|
Ratios
|
Repeat Ratio calculation, left to right, for every column; ratio is nearly the same as percent except that it doesn't multiply by 100
|
RepeatingCalculation,Ratio
|
|
Distribute...
|
Divide or group a range of columns so that this page matches the columns in another page
|
DistributeCellCollection
|
|
Summary...
|
A new page is created with a useful selection of subtotals for a chosen axis
|
AddAggregates
|
| |
|
|
|
Filter
|
|
|
|
Row label...
|
Keep, remove, select, or flag rows when row label matches certain criteria
|
SelectByCaptions
|
|
Text column...
|
Keep, remove, select, or flag rows which have a text value that matches certain criteria
|
SelectByCaptions
|
|
Specific date...
|
Remove rows which meet the chosen condition
|
SelectByCaptions
|
|
Relative date...
|
Remove rows which meet the chosen condition
|
RemoveDate
|
|
Numeric value...
|
Keep, remove, select, or flag rows which have a value in a chosen column
|
FilterByValue
|
|
Column summary...
|
Keep, remove, select, or flag rows when compared to a calculated value for the current row, current column, or current page axis
|
FilterByValue
|
|
Rows in other page...
|
Keep, remove, select, or flag rows which have a matching row in another page
|
SelectByCaptions
|
| |
|
|
|
Compare
|
|
|
|
Axis...
|
Compare each cell to a calculation for the current row, current column, current page, or a calculation for a row, column, or page on another page.
|
Compare,ToAxis
|
|
Relative...
|
Compare each cell to another cell, one that is relative to the current one on the same page; or to a cell with a matching row label and column caption on another page
|
Compare,ToRelativeCell
|
|
Specific cell...
|
Compare each cell to another cell, a specific cell identified by a position or by a row label and column caption, on the same page or another page
|
Compare,AbsolutePosition
|
|
Specific row...
|
Compare each cell to a cell on a specific row identified by a position or by a row label, on the same page or another page
|
Compare,ToARow
|
|
Specific column...
|
Compare each cell to a cell on a specific column identified by a position by a numeric column caption, on the same page or another page
|
Compare,ToAColumn
|
|
Matching text...
|
Find rows with the same value in a text column or row label, combine them, and show each row with that value as a percent of that combined value
|
CompareSimilar
|
|
Two pages (joiners and leavers)...
|
Compare two pages to find the joiners, leavers, and the intersection
|
SetMath
|
|
Add baseline
|
Add the selected row to the list of baselines available for use by the Test operation; n.b. Only rows can be made into baselines
|
AddBaseline
AutoPopulateBaselines
|
|
Baseline cells...
|
Compare each cell to a baseline; pass or fail each cell depending on being above or below the corresponding value in the baseline; When the count of failures exceed a threshold, fail the row.
|
Test
|
|
Baseline range...
|
Compare each cell to a baseline; pass or fail each cell depending on being within a percentage range (+/-) of the corresponding value in the baseline; When the count of failures exceed a threshold, fail the row
|
Test
|
| |
|
|
|
Normalize
|
|
|
|
Ranges...
|
Calculate quartile, quintile, or decile assignments; other choices are available
|
ChangeValuesToNTile
|
|
Custom...
|
Enter a custom numeric range of value or percentage groupings, and show which range each value belongs to
|
ChangeValuesValues
|
|
80-20...
|
This is frequently used example of Custom Ranges. It calculates where each cell fits according to bottom 20% or top 20%, or in between of the chosen axis.
|
ChangeValuesPercents
|
|
Rank...
|
Calculate and show the rank position of each cell along a chosen axis
|
ChangeValuesToRank
|
|
Average/Median...
|
Calculate an axis average or median of a chosen axis, then then show if a cell is above or below it
|
ChangeValuesAboveBelowAggregation
|
|
Variance...
|
Rates how far a cell value is from the average of a chosen axis; calculates and uses standard deviation to ensure variance is relative to the normal fluctuations of the data and are accounted for
|
ShowAsNumberStandardDeviations
|
|
Text to cells...
|
Change the cell context to display context-sensitive words; offers a selection of dynamically expandable value variables from the current page that make cells self-documenting; can employ embedded html here to create really interesting graphical treatments
|
AssignWordsToValues
AssignWordsToValuesSelectedColumns
|
|
Cell values as rows
|
shows the distribution of values in a column by exchanging the row labels with the cell values; rows with the same value are grouped together
|
SwapCellValues,Row
|
|
Cell values as columns
|
shows the distribution of values in a row by exchanging the column labels with the cell values; columns with the same value are grouped together
|
SwapCellValues,Column
|
|
Count values
|
Counts the frequency (number of times) each unique value occurs in a column
|
GetCountsOfValues
|
|
Group by cell values...
|
Unique values in a numeric column are appended to a page that has rows only with that value.
|
MoveColumnValuesToPages
|
| |
|
|
|
Alert
|
|
|
|
Another cell...
|
Alert a cell based on a comparison to another cell in the same page or to a cell with a matching row label and column caption on another page; alerts are applied to the selected columns, or defaults to all columns
|
ChangeAlertTo,RelativeCell
|
|
Axis...
|
Alert a cell based on a comparison to a summary value of a chosen axis on the same page or another page; if it is another page, the column caption or row label must match, depending on the axis; alerts are applied to the selected columns, or defaults to all columns
|
ChangeAlertTo,Axis
|
|
Another Cell Value...
|
Alert a cell based on the value of a cell on another page; the cell on the other page must have a cell with a matching row label and column caption; alerts are applied to the selected columns, or defaults to all columns
|
ChangeAlertTo,CellValue
|
|
Cancel...
|
Turn off alerts for the selected columns, or default to all columns
|
ChangeAlertTo,None
|
|
Convert alert codes to data column values
|
The alert codes become the new cell value in the numeric columns; after this operation, alert values become data so they can be used in data operations such as filtering
|
ConvertAlertsTodata
|
| |
|
|
|
Programming
|
|
|
| |
These commands are available to script programmers but may not be available in the author mode user menus. |
ChangePageProperties2 Extract
GetCaption
NewStartingPoint
Prompt
PromptForPage
RemoveTextColumnsAndDataColumns
RepeatDataColumnNames
RepeatTextColumnNames
RepeatTextColumnValues
SelectBySpecificPositions
SetTupleValue
SortSelected
Variable |
