Tool to count the number of groups matching certain criteria in a Gigasheet dataset. Use when you need to determine how many distinct groups exist based on specified row grouping columns and optional filters. This action is useful for understanding data distribution and cardinal…
endRowintegerEnding row index for pagination.
handleRequiredstringUnique identifier (handle) of the dataset to count groups in. Typically returned by upload or dataset operations.
startRowintegerStarting row index for pagination.
groupKeysarrayList of group keys to filter by. Empty list means no filtering by group keys.
pivotColsarrayList of column configurations to use for pivoting, if pivot mode is enabled.
pivotModebooleanWhether to enable pivot mode for the count operation.
sortModelarraySort configuration for the groups being counted.
valueColsarrayList of value columns to aggregate when counting groups.
FieldTypesarrayList of field types if working with pivot mode. System checks type of field by example: int, float, string.
filterModelobjectFilter conditions to apply before counting groups. Keys are column names, values are filter specifications.
rowGroupColsRequiredarrayList of column configurations to use for row grouping. Each column defines how data should be grouped.
AllowUnstableOrderbooleanSet to true to allow unstable result order for faster performance on large files.
dataRequiredData from the action execution
errorstringError if any occurred during the execution of the action
successfulRequiredbooleanWhether or not the action execution was successful or not
API key connection. Risk level 2 of 5.
Free Action
No published Skills explicitly reference this Action yet.