| 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. |
Reference
- Functional Index
- AddAggregates
- AddBaseline
- AddData
- AddPage
- AssignCellFormat
- AssignColumnCSS
- AssignWordsToValues
- AssignWordsToValuesSelectedColumns
- AutoPopulateBaselines
- ChangeAlertTo, Axis
- ChangeAlertTo, CellValue
- ChangeAlertTo, None
- ChangeAlertTo, RelativeCell
- ChangeLabelCaption
- ChangePageProperties2
- ChangeTextInTextColumn
- ChangeValuesAboveBelowAggregation
- ChangeValuesPercents
- ChangeValuesToNTile
- ChangeValuesToRank
- ChangeValuesValues
- ClearOldPages
- ClearSelection
- Combine
- CombineDuplicates
- CombineSimilar / ByIndex
- Compare
- CompareSimilar
- ConcatenatePagesWith
- ConcatenateTextColumns
- ConvertAlertsToData
- CopyDataToTextColumns
- CreateTextColumnFromDateColumn
- DeleteTextColumn
- DistributeCellCollection
- Extract
- FilterByValue
- FilterGlobally
- GetCaption
- GetCountsOfValues
- HidePage
- HidePagesExcept
- ImportData
- ImportDataNoHeader
- InvertSelection
- JoinTwoPagesByMatchingRowLabel
- KeepSelected
- MathOperation
- MathOperationOnTwoPositions
- MoveColumns
- MoveColumnValuesToPages
- MoveRowLabelsToPages
- MoveRows
- MoveTextColumnValuesToPages
- NewRowLabel
- NewStartingPoint
- NewTextColumnName
- PageCaption / PageDescription / PageDescriptionAppend
- PageNumericFormat
- ProjectProperties
- Prompt
- PromptForPage
- Query, Captions
- Query, Command / CommandAppend
- Query, CommandTimeout
- Query, Roles
- Query, RowLabel
- Query, Run, ODBC / Oracle / SQL / JDBC
- Query, RunSave, ODBC / Oracle / SQL / JDBC
- Query, TextColumnNames
- RemoveDate
- RemovePage
- RemoveSelected
- RemoveTextColumnsAndDataColumns
- RepeatDataColumnNames
- RepeatingCalculation
- RepeatTextColumnNames
- RepeatTextColumnValues
- Reverse
- RollingPeriods
- RunScript
- SaveAsProject
- SavePageToCSV
- SavePageToCSVPivot
- SavePageToNOD
- SavePageToXMLCrosstab
- SearchAndSelect
- Select, Cell / Unselect, Cell
- Select, Page
- Select,Row/Column Unselect,Row/Column
- SelectByCaptions
- SelectBySpecificPositions
- SelectRange / UnselectRange
- SetCultureString
- SetMath
- SetTupleValue
- ShowAsNumberStandardDeviations
- ShowPage
- Sort
- SortByDate
- SortColumnLabel
- SortCustom
- SortRowLabel
- SortSelected
- SortTextColumn
- SplitTextColumn
- Swap
- SwapCellValues
- SwapTextColumnWithColumn / ByIndex
- SwapTextColumnWithRowLabel / ByIndex
- Test