ScorecardChartSpec

A scorecard chart. Scorecard charts are used to highlight key performance indicators, known as KPIs, on the spreadsheet. A scorecard chart can represent things like total sales, average cost, or a top selling item. You can specify a single data value, or aggregate over a range of data. Percentage or absolute difference from a baseline value can be highlighted, like changes over time.

{
    "aggregateType": "CHART_AGGREGATE_TYPE_UNSPECIFIED",
    "baselineValueData": {
        "aggregateType": "CHART_AGGREGATE_TYPE_UNSPECIFIED",
        "columnReference": {
            "name": "string"
        },
        "groupRule": {
            "dateTimeRule": {
                "type": "CHART_DATE_TIME_RULE_TYPE_UNSPECIFIED"
            },
            "histogramRule": {
                "intervalSize": 0,
                "maxValue": 0,
                "minValue": 0
            }
        },
        "sourceRange": {
            "sources": [
                {}
            ]
        }
    },
    "baselineValueFormat": {
        "comparisonType": "COMPARISON_TYPE_UNDEFINED",
        "description": "string",
        "negativeColor": {},
        "negativeColorStyle": {
            "rgbColor": {},
            "themeColor": "THEME_COLOR_TYPE_UNSPECIFIED"
        },
        "position": {
            "horizontalAlignment": "HORIZONTAL_ALIGN_UNSPECIFIED"
        },
        "positiveColor": {},
        "positiveColorStyle": {
            "rgbColor": {},
            "themeColor": "THEME_COLOR_TYPE_UNSPECIFIED"
        },
        "textFormat": {
            "bold": true,
            "fontFamily": "string",
            "fontSize": 0,
            "foregroundColor": {},
            "foregroundColorStyle": {
                "rgbColor": {},
                "themeColor": "THEME_COLOR_TYPE_UNSPECIFIED"
            },
            "italic": true,
            "link": {
                "uri": "string"
            },
            "strikethrough": true,
            "underline": true
        }
    },
    "customFormatOptions": {
        "prefix": "string",
        "suffix": "string"
    },
    "keyValueData": {
        "aggregateType": "CHART_AGGREGATE_TYPE_UNSPECIFIED",
        "columnReference": {
            "name": "string"
        },
        "groupRule": {
            "dateTimeRule": {
                "type": "CHART_DATE_TIME_RULE_TYPE_UNSPECIFIED"
            },
            "histogramRule": {
                "intervalSize": 0,
                "maxValue": 0,
                "minValue": 0
            }
        },
        "sourceRange": {
            "sources": [
                {}
            ]
        }
    },
    "keyValueFormat": {
        "position": {
            "horizontalAlignment": "HORIZONTAL_ALIGN_UNSPECIFIED"
        },
        "textFormat": {
            "bold": true,
            "fontFamily": "string",
            "fontSize": 0,
            "foregroundColor": {},
            "foregroundColorStyle": {
                "rgbColor": {},
                "themeColor": "THEME_COLOR_TYPE_UNSPECIFIED"
            },
            "italic": true,
            "link": {
                "uri": "string"
            },
            "strikethrough": true,
            "underline": true
        }
    },
    "numberFormatSource": "CHART_NUMBER_FORMAT_SOURCE_UNDEFINED",
    "scaleFactor": 0
}