Class Pivot
The Pivot describes the pivot section in the request. The Pivot helps rearrange the information in the table for certain reports by pivoting your data on a second dimension.
Implements
Inherited Members
Namespace: Google.Apis.AnalyticsReporting.v4.Data
Assembly: Google.Apis.AnalyticsReporting.v4.dll
Syntax
public class Pivot : IDirectResponseSchema
Properties
DimensionFilterClauses
DimensionFilterClauses are logically combined with an AND
operator: only data that is included by all
these DimensionFilterClauses contributes to the values in this pivot region. Dimension filters can be used
to restrict the columns shown in the pivot region. For example if you have ga:browser
as the requested
dimension in the pivot region, and you specify key filters to restrict ga:browser
to only "IE" or
"Firefox", then only those two browsers would show up as columns.
Declaration
[JsonProperty("dimensionFilterClauses")]
public virtual IList<DimensionFilterClause> DimensionFilterClauses { get; set; }
Property Value
Type | Description |
---|---|
IList<DimensionFilterClause> |
Dimensions
A list of dimensions to show as pivot columns. A Pivot can have a maximum of 4 dimensions. Pivot dimensions are part of the restriction on the total number of dimensions allowed in the request.
Declaration
[JsonProperty("dimensions")]
public virtual IList<Dimension> Dimensions { get; set; }
Property Value
Type | Description |
---|---|
IList<Dimension> |
ETag
The ETag of the item.
Declaration
public virtual string ETag { get; set; }
Property Value
Type | Description |
---|---|
string |
MaxGroupCount
Specifies the maximum number of groups to return. The default value is 10, also the maximum value is 1,000.
Declaration
[JsonProperty("maxGroupCount")]
public virtual int? MaxGroupCount { get; set; }
Property Value
Type | Description |
---|---|
int? |
Metrics
The pivot metrics. Pivot metrics are part of the restriction on total number of metrics allowed in the request.
Declaration
[JsonProperty("metrics")]
public virtual IList<Metric> Metrics { get; set; }
Property Value
Type | Description |
---|---|
IList<Metric> |
StartGroup
If k metrics were requested, then the response will contain some data-dependent multiple of k columns in the
report. E.g., if you pivoted on the dimension ga:browser
then you'd get k columns for "Firefox", k columns
for "IE", k columns for "Chrome", etc. The ordering of the groups of columns is determined by descending
order of "total" for the first of the k values. Ties are broken by lexicographic ordering of the first pivot
dimension, then lexicographic ordering of the second pivot dimension, and so on. E.g., if the totals for the
first value for Firefox, IE, and Chrome were 8, 2, 8, respectively, the order of columns would be Chrome,
Firefox, IE. The following let you choose which of the groups of k columns are included in the response.
Declaration
[JsonProperty("startGroup")]
public virtual int? StartGroup { get; set; }
Property Value
Type | Description |
---|---|
int? |