| GetCountsOfValues |
Swaps columns to the rows and sets the columns to the unique values in the data, then shows the counts / number of times each unique value occurred.
Syntax:GetCountsOfValuesParameters:None Examples:GetCountsOfValues This example perfroms the transformation. Comments:You should fill empty cells with zero to avoid having to handle ‘missing’ values. |
| < Prev | Next > |
|---|
Reference
- AddAggregates
- AddBaseline
- AddData
- AddPage
- AssignCellFormat
- AssignColumnCSS
- AssignWordsToValues
- AssignWordsToValuesSelectedColumns
- AutoPopulateBaselines
- ChangeAlertTo, Axis
- ChangeAlertTo, CellValue
- ChangeAlertTo, None
- ChangeAlertTo, RelativeCell
- ChangeLabelCaption
- ChangePageProperties2
- ChangeValuesAboveBelowAggregation
- ChangeValuesPercents
- ChangeValuesToNTile
- ChangeValuesToRank
- ChangeValuesValues
- ClearSelection
- Combine
- CombineDuplicates
- CombineSimilar / CombineSimilarByIndex
- Compare
- CompareSimilar
- ConcatenatePagesWith
- ConcatenateTextColumns
- ConvertAlertsToData
- CopyDataToTextColumns
- DeleteTextColumn
- DistributeCellCollection
- Extract
- FilterByNumeric
- FilterByText
- FilterByValue
- GetCountsOfValues
- HidePage
- HidePagesExcept
- ImportData
- ImportDataNoHeader
- InvertSelection
- KeepSelected
- MathOperation
- MathOperationOnTwoPositions
- MoveColumns
- MoveColumnValuesToPages
- MoveRowLabelsToPages
- MoveRows
- MoveTextColumnValuesToPages
- NewRowLabel
- NewStartingPoint
- NewTextColumnName
- PageCaption / PageDescription / PageDescriptionAppend
- PageNumericFormat
- Prompt, Add
- Query, Captions
- Query, Command / Query, CommandAppend
- Query, CommandTimeout
- Query, Roles
- Query, RowLabel
- Query, RunSave, Oracle / Query, RunSave, SQL
- Query, TextColumnNames
- RemoveSelected
- RemoveTextColumnsAndDataColumns
- RepeatDataColumnNames
- RepeatingCalculation
- RepeatTextColumnValues
- RepeatVisibleTextColumns
- Reverse
- RollingPeriods
- RunScript
- SaveAsProject
- SavePageToCSV
- SavePageToCSVPivot
- SavePageToNOD
- SavePageToXMLCrosstab
- Select, Cell / Unselect, Cell
- Select, Page
- Select,Row / Unselect,Row / Select,Column / Unselect,Column
- SelectByCaptions
- SelectBySpecificPositions
- SelectRange / UnselectRange
- SetCaption
- SetMath
- SetTupleValue
- ShowAsNumberStandardDeviations
- ShowPage
- Sort
- SortColumnLabel
- SortCustom
- SortRowLabel
- SortSelected
- SortTextColumn
- Swap
- SwapCellValues
- SwapTextColumnWithColumn
- SwapTextColumnWithColumnByIndex
- SwapTextColumnWithRowLabel
- SwapTextColumnWithRowLabelByIndex
- Test
- Variable
- VisibleTextColumns