ManualRule

Allows you to manually organize the values in a source data column into buckets with names of your choosing. For example, a pivot table that aggregates population by state: +-------+-------------------+ | State | SUM of Population | +-------+-------------------+ | AK | 0.7 | | AL | 4.8 | | AR | 2.9 | ... +-------+-------------------+ could be turned into a pivot table that aggregates population by time zone by providing a list of groups (for example, groupName = 'Central', items = ['AL', 'AR', '

{
    "groups": [
        {
            "groupName": {
                "boolValue": true,
                "errorValue": {
                    "message": "string",
                    "type": "ERROR_TYPE_UNSPECIFIED"
                },
                "formulaValue": "string",
                "numberValue": 0,
                "stringValue": "string"
            },
            "items": [
                {
                    "boolValue": true,
                    "errorValue": {
                        "message": "string",
                        "type": "ERROR_TYPE_UNSPECIFIED"
                    },
                    "formulaValue": "string",
                    "numberValue": 0,
                    "stringValue": "string"
                }
            ]
        }
    ]
}