Class 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.

Inheritance

object

ScorecardChartSpec

Implements

IDirectResponseSchema

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Namespace: Google.Apis.Sheets.v4.Data

Assembly: Google.Apis.Sheets.v4.dll

Syntax

public class ScorecardChartSpec : IDirectResponseSchema

Properties

AggregateType

The aggregation type for key and baseline chart data in scorecard chart. This field is not supported for data source charts. Use the ChartData.aggregateType field of the key_value_data or baseline_value_data instead for data source charts. This field is optional.

Declaration

[JsonProperty("aggregateType")]
public virtual string AggregateType { get; set; }

Property Value

Type	Description
string

BaselineValueData

The data for scorecard baseline value. This field is optional.

Declaration

[JsonProperty("baselineValueData")]
public virtual ChartData BaselineValueData { get; set; }

Property Value

Type	Description
ChartData

BaselineValueFormat

Formatting options for baseline value. This field is needed only if baseline_value_data is specified.

Declaration

[JsonProperty("baselineValueFormat")]
public virtual BaselineValueFormat BaselineValueFormat { get; set; }

Property Value

Type	Description
BaselineValueFormat

CustomFormatOptions

Custom formatting options for numeric key/baseline values in scorecard chart. This field is used only when number_format_source is set to CUSTOM. This field is optional.

Declaration

[JsonProperty("customFormatOptions")]
public virtual ChartCustomNumberFormatOptions CustomFormatOptions { get; set; }

Property Value

Type	Description
ChartCustomNumberFormatOptions

ETag

The ETag of the item.

Declaration

public virtual string ETag { get; set; }

Property Value

Type	Description
string

KeyValueData

The data for scorecard key value.

Declaration

[JsonProperty("keyValueData")]
public virtual ChartData KeyValueData { get; set; }

Property Value

Type	Description
ChartData

KeyValueFormat

Formatting options for key value.

Declaration

[JsonProperty("keyValueFormat")]
public virtual KeyValueFormat KeyValueFormat { get; set; }

Property Value

Type	Description
KeyValueFormat

NumberFormatSource

The number format source used in the scorecard chart. This field is optional.

Declaration

[JsonProperty("numberFormatSource")]
public virtual string NumberFormatSource { get; set; }

Property Value

Type	Description
string

ScaleFactor

Value to scale scorecard key and baseline value. For example, a factor of 10 can be used to divide all values in the chart by 10. This field is optional.

Declaration

[JsonProperty("scaleFactor")]
public virtual double? ScaleFactor { get; set; }

Property Value

Type	Description
double?

Implements

IDirectResponseSchema