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

System.Object

ScorecardChartSpec

Implements

Google.Apis.Requests.IDirectResponseSchema

Inherited Members

System.Object.Equals(System.Object)

System.Object.Equals(System.Object, System.Object)

System.Object.GetHashCode()

System.Object.GetType()

System.Object.MemberwiseClone()

System.Object.ReferenceEquals(System.Object, System.Object)

System.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 optional.

Declaration

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

Property Value

Type	Description
System.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
System.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
System.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
System.Nullable<System.Double>

Implements

Google.Apis.Requests.IDirectResponseSchema