MetricResponse
The result of a mutation which creates or modifies a Metric.
fields
metric nullable Metric
The Metric which was created or modified.
The Metric object.
A Metric is a business indicator measured over time.
metric.id non-null ID
The Metric's unique identifier.
metric.uniqueName non-null String
The Metric's unique name.
metric.description non-null String
The Metric's description.
metric.account non-null Account
The Metric's Account.
metric.environment non-null Environment
The Metric's Environment.
metric.createdAt non-null DateTime
The Metric's creation date and time in UTC.
metric.modifiedAt non-null DateTime
The Metric's last modification date and time in UTC.
metric.createdBy non-null String
The Metric's creator. It can be either a User ID, an Application ID, or "system" if it was created by Propel.
metric.modifiedBy non-null String
The Metric's last modifier. It can be either a User ID, an Application ID, or "system" if it was modified by Propel.
metric.dataPool nullable DataPool
The Data Pool that powers this Metric.
metric.dimensions non-null array of Dimension
The Metric's Dimensions. These Dimensions are available to Query Filters.
metric.timestamp non-null Dimension
The Metric's timestamp. This is the same as its Data Pool's timestamp.
metric.boosters non-null BoosterConnection
List the Boosters associated to the Metric.
metric.type non-null MetricType
The Metric's type. The different Metric types determine how the values are calculated.
The available Metric types.
COUNT
Counts the number of records that matches the Metric Filters. For time series, it will count the values for each time granularity.
SUM
Sums the values of the specified column for every record that matches the Metric Filters. For time series, it will sum the values for each time granularity.
COUNT_DISTINCT
Counts the number of distinct values in the specified column for every record that matches the Metric Filters. For time series, it will count the distinct values for each time granularity.
AVERAGE
Averages the values of the specified column for every record that matches the Metric Filters. For time series, it will average the values for each time granularity.
MIN
Selects the minimum value of the specified column for every record that matches the Metric Filters. For time series, it will select the minimum value for each time granularity.
MAX
Selects the maximum value of the specified column for every record that matches the Metric Filters. For time series, it will select the maximum value for each time granularity.
metric.settings non-null MetricSettings
The settings for the Metric. The settings are specific to the Metric's type.
- CountMetricSettings
- SumMetricSettings
- CountDistinctMetricSettings
- AverageMetricSettings
- MinMetricSettings
- MaxMetricSettings
metric.counter nullable CounterResponse
The Metric data in counter format. A single metric value for the given time range and filters.
metric.counter.input required CounterInput
The fields for querying a Metric in counter format.
A Metric's counter query returns a single value over a given time range.
metric.counter.input.timeRange required TimeRangeInput
The time range for calculating the counter.
The fields required to specify the time range for a time series, counter, or leaderboard Metric query.
If no relative or absolute time ranges are provided, Propel defaults to an absolute time range beginning with the earliest record in the Metric's Data Pool and ending with the latest record.
If both relative and absolute time ranges are provided, the relative time range will take precedence.
If a
LAST_N
relative time period is selected, ann
≥ 1 must be provided. If non
is provided orn
< 1, aBAD_REQUEST
error will be returned.metric.counter.input.timeRange.relative optional RelativeTimeRange
The relative time period.
The Relative time ranges are based on the current date and time.
THIS
- The current unit of time. For example, if today is June 8, 2022, andTHIS_MONTH
is selected, then data for June 2022 would be returned.PREVIOUS
- The previous unit of time. For example, if today is June 8, 2022, andPREVIOUS_MONTH
is selected, then data for May 2022 would be returned. It excludes the current unit of time.NEXT
- The next unit of time. For example, if today is June 8, 2022, andNEXT_MONTH
is selected, then data for July 2022 would be returned. It excludes the current unit of time.LAST_N
- The lastn
units of time, including the current one. For example, if today is June 8, 2022 andLAST_N_YEARS
withn
= 3 is selected, then data for 2020, 2021, and 2022 will be returned. It will include the current time period.THIS_HOUR
Starts at the zeroth minute of the current hour and continues for 60 minutes.
TODAY
Starts at 12:00:00 AM of the current day and continues for 24 hours.
THIS_WEEK
Starts on Monday, 12:00:00 AM of the current week and continues for seven days.
THIS_MONTH
Starts at 12:00:00 AM on the first day of the current month and continues for the duration of the month.
THIS_QUARTER
Starts at 12:00:00 AM on the first day of the current calendar quarter and continues for the duration of the quarter.
THIS_YEAR
Starts on January 1st, 12:00:00 AM of the current year and continues for the duration of the year.
PREVIOUS_HOUR
Starts at the zeroth minute of the previous hour and continues for 60 minutes.
YESTERDAY
Starts at 12:00:00 AM on the day before the today and continues for 24 hours.
PREVIOUS_WEEK
Starts on Monday, 12:00:00 AM, a week before the current week, and continues for seven days.
PREVIOUS_MONTH
Starts at 12:00:00 AM on the first day of the month before the current month and continues for the duration of the month.
PREVIOUS_QUARTER
Starts at 12:00:00 AM on the first day of the calendar quarter before the current quarter and continues for the duration of the quarter.
PREVIOUS_YEAR
Starts on January 1st, 12:00:00 AM, the year before the current year, and continues for the duration of the year.
NEXT_HOUR
Starts at the zeroth minute of the next hour and continues for 60 minutes.
TOMORROW
" Starts at 12:00:00 AM, the day after the current day, and continues for 24 hours.
NEXT_WEEK
Starts on Monday, 12:00:00 AM, the week after the current week, and continues for the duration of the week.
NEXT_MONTH
Starts at 12:00:00 AM on the first day of the next month and continues for the duration of the month.
NEXT_QUARTER
Starts at 12:00:00 AM on the first day of the next calendar quarter and continues for the duration of the quarter.
NEXT_YEAR
Starts on January 1st, 12:00:00 AM of the next year and continues for the duration of the year.
LAST_N_MINUTES
Starts at the zeroth second
n
- 1 minute(s) before the current minute and continues through the current minute. It includes this minute.LAST_N_HOURS
Starts at the zeroth minute of the
n
- 1 hour(s) before the current hour, and continues through the current hour. It includes this hour.LAST_N_DAYS
Starts at 12:00:00 AM,
n
- 1 day(s) before the current day, and continues through the current day. It includes today.LAST_N_WEEKS
Starts on Monday, 12:00:00 AM,
n
- 1 week(s) before the current week, and continues through the current week. It includes this week.LAST_N_MONTHS
Starts at 12:00:00 AM on the first day of the month,
n
- 1 month(s) before the current month, and continues through the current month. It includes this month.LAST_N_QUARTERS
Starts at 12:00:00 AM on the first day of the calendar quarter
n
- 1 quarter(s) before the current quarter and continues through the current quarter. It includes this quarter.LAST_N_YEARS
Starts on January 1st, 12:00:00 AM of the year
n
- 1 year(s) before the current year and continues through the current year. It includes this year.LAST_15_MINUTES ⚠️ Deprecated: Use
LAST_N_MINUTES
instead.LAST_30_MINUTES ⚠️ Deprecated: Use
LAST_N_MINUTES
instead.LAST_HOUR ⚠️ Deprecated: Use
LAST_N_HOURS
instead.LAST_4_HOURS ⚠️ Deprecated: Use
LAST_N_HOURS
instead.LAST_12_HOURS ⚠️ Deprecated: Use
LAST_N_HOURS
instead.LAST_24_HOURS ⚠️ Deprecated: Use
LAST_N_HOURS
instead.LAST_7_DAYS ⚠️ Deprecated: Use
LAST_N_DAYS
instead.LAST_30_DAYS ⚠️ Deprecated: Use
LAST_N_DAYS
instead.LAST_90_DAYS ⚠️ Deprecated: Use
LAST_N_DAYS
instead.LAST_3_MONTHS ⚠️ Deprecated: Use
LAST_N_MONTHS
instead.LAST_6_MONTHS ⚠️ Deprecated: Use
LAST_N_MONTHS
instead.LAST_YEAR ⚠️ Deprecated: Use
LAST_N_YEARS
instead.LAST_2_YEARS ⚠️ Deprecated: Use
LAST_N_YEARS
instead.LAST_5_YEARS ⚠️ Deprecated: Use
LAST_N_YEARS
instead.
metric.counter.input.timeRange.n optional Int
The number of time units for the
LAST_N
relative periods.metric.counter.input.timeRange.start optional DateTime
The optional start timestamp (inclusive). Defaults to the timestamp of the earliest record in the Data Pool.
metric.counter.input.timeRange.stop optional DateTime
The optional end timestamp (exclusive). Defaults to the timestamp of the latest record in the Data Pool.
metric.counter.input.filters optional array of FilterInput
The Query Filters to apply before retrieving the counter data. If no Query Filters are provided, all data is included.
The fields for defining a Filter.
metric.counter.input.filters.column required String
The name of the column to filter on.
metric.counter.input.filters.operator required FilterOperator
The operation to perform when comparing the column and filter values.
The available Filter operators.
EQUALS
Selects values that are equal to the specified value.
NOT_EQUALS
Selects values that are not equal to the specified value.
GREATER_THAN
Selects values that are greater than the specified value.
GREATER_THAN_OR_EQUAL_TO
Selects values that are greater or equal to the specified value.
LESS_THAN
Selects values that are less than the specified value.
LESS_THAN_OR_EQUAL_TO
Selects values that are less or equal to the specified value.
metric.counter.input.filters.value required String
The value to compare the column to.
metric.counter.input.propeller optional Propeller
Optionally specifies the Propeller to use. This can be set when querying from the Metric Playground or GraphQL Explorer. Applications may not set this value. Instead, Application Queries always use the Propeller configured on the Application.
A Propeller determines your Application's query processing power. The larger the Propeller, the faster the queries and the higher the cost. Every Propel Application (and therefore every set of API credentials) has a Propeller that determines the speed and cost of queries.
Learn more about Data Sources.
P1_X_SMALL
Max records per second: 5,000,000 records per second
P1_SMALL
Max records per second: 25,000,000 records per second
P1_MEDIUM
Max records per second: 100,000,000 records per second
P1_LARGE
Max records per second: 250,000,000 records per second
P1_X_LARGE
Max records per second: 500,000,000 records per second
metric.timeSeries nullable TimeSeriesResponse
The Metric data in time series format. Arrays of timestamps and Metric values for the given time range and filters.
metric.timeSeries.input required TimeSeriesInput
The fields for querying a Metric in time series format.
A Metric's time series query returns the values over a given time range aggregated by a given time granularity; day, month, or year, for example.
metric.timeSeries.input.timeRange required TimeRangeInput
The time range for calculating the time series.
The fields required to specify the time range for a time series, counter, or leaderboard Metric query.
If no relative or absolute time ranges are provided, Propel defaults to an absolute time range beginning with the earliest record in the Metric's Data Pool and ending with the latest record.
If both relative and absolute time ranges are provided, the relative time range will take precedence.
If a
LAST_N
relative time period is selected, ann
≥ 1 must be provided. If non
is provided orn
< 1, aBAD_REQUEST
error will be returned.metric.timeSeries.input.timeRange.relative optional RelativeTimeRange
The relative time period.
The Relative time ranges are based on the current date and time.
THIS
- The current unit of time. For example, if today is June 8, 2022, andTHIS_MONTH
is selected, then data for June 2022 would be returned.PREVIOUS
- The previous unit of time. For example, if today is June 8, 2022, andPREVIOUS_MONTH
is selected, then data for May 2022 would be returned. It excludes the current unit of time.NEXT
- The next unit of time. For example, if today is June 8, 2022, andNEXT_MONTH
is selected, then data for July 2022 would be returned. It excludes the current unit of time.LAST_N
- The lastn
units of time, including the current one. For example, if today is June 8, 2022 andLAST_N_YEARS
withn
= 3 is selected, then data for 2020, 2021, and 2022 will be returned. It will include the current time period.THIS_HOUR
Starts at the zeroth minute of the current hour and continues for 60 minutes.
TODAY
Starts at 12:00:00 AM of the current day and continues for 24 hours.
THIS_WEEK
Starts on Monday, 12:00:00 AM of the current week and continues for seven days.
THIS_MONTH
Starts at 12:00:00 AM on the first day of the current month and continues for the duration of the month.
THIS_QUARTER
Starts at 12:00:00 AM on the first day of the current calendar quarter and continues for the duration of the quarter.
THIS_YEAR
Starts on January 1st, 12:00:00 AM of the current year and continues for the duration of the year.
PREVIOUS_HOUR
Starts at the zeroth minute of the previous hour and continues for 60 minutes.
YESTERDAY
Starts at 12:00:00 AM on the day before the today and continues for 24 hours.
PREVIOUS_WEEK
Starts on Monday, 12:00:00 AM, a week before the current week, and continues for seven days.
PREVIOUS_MONTH
Starts at 12:00:00 AM on the first day of the month before the current month and continues for the duration of the month.
PREVIOUS_QUARTER
Starts at 12:00:00 AM on the first day of the calendar quarter before the current quarter and continues for the duration of the quarter.
PREVIOUS_YEAR
Starts on January 1st, 12:00:00 AM, the year before the current year, and continues for the duration of the year.
NEXT_HOUR
Starts at the zeroth minute of the next hour and continues for 60 minutes.
TOMORROW
" Starts at 12:00:00 AM, the day after the current day, and continues for 24 hours.
NEXT_WEEK
Starts on Monday, 12:00:00 AM, the week after the current week, and continues for the duration of the week.
NEXT_MONTH
Starts at 12:00:00 AM on the first day of the next month and continues for the duration of the month.
NEXT_QUARTER
Starts at 12:00:00 AM on the first day of the next calendar quarter and continues for the duration of the quarter.
NEXT_YEAR
Starts on January 1st, 12:00:00 AM of the next year and continues for the duration of the year.
LAST_N_MINUTES
Starts at the zeroth second
n
- 1 minute(s) before the current minute and continues through the current minute. It includes this minute.LAST_N_HOURS
Starts at the zeroth minute of the
n
- 1 hour(s) before the current hour, and continues through the current hour. It includes this hour.LAST_N_DAYS
Starts at 12:00:00 AM,
n
- 1 day(s) before the current day, and continues through the current day. It includes today.LAST_N_WEEKS
Starts on Monday, 12:00:00 AM,
n
- 1 week(s) before the current week, and continues through the current week. It includes this week.LAST_N_MONTHS
Starts at 12:00:00 AM on the first day of the month,
n
- 1 month(s) before the current month, and continues through the current month. It includes this month.LAST_N_QUARTERS
Starts at 12:00:00 AM on the first day of the calendar quarter
n
- 1 quarter(s) before the current quarter and continues through the current quarter. It includes this quarter.LAST_N_YEARS
Starts on January 1st, 12:00:00 AM of the year
n
- 1 year(s) before the current year and continues through the current year. It includes this year.LAST_15_MINUTES ⚠️ Deprecated: Use
LAST_N_MINUTES
instead.LAST_30_MINUTES ⚠️ Deprecated: Use
LAST_N_MINUTES
instead.LAST_HOUR ⚠️ Deprecated: Use
LAST_N_HOURS
instead.LAST_4_HOURS ⚠️ Deprecated: Use
LAST_N_HOURS
instead.LAST_12_HOURS ⚠️ Deprecated: Use
LAST_N_HOURS
instead.LAST_24_HOURS ⚠️ Deprecated: Use
LAST_N_HOURS
instead.LAST_7_DAYS ⚠️ Deprecated: Use
LAST_N_DAYS
instead.LAST_30_DAYS ⚠️ Deprecated: Use
LAST_N_DAYS
instead.LAST_90_DAYS ⚠️ Deprecated: Use
LAST_N_DAYS
instead.LAST_3_MONTHS ⚠️ Deprecated: Use
LAST_N_MONTHS
instead.LAST_6_MONTHS ⚠️ Deprecated: Use
LAST_N_MONTHS
instead.LAST_YEAR ⚠️ Deprecated: Use
LAST_N_YEARS
instead.LAST_2_YEARS ⚠️ Deprecated: Use
LAST_N_YEARS
instead.LAST_5_YEARS ⚠️ Deprecated: Use
LAST_N_YEARS
instead.
metric.timeSeries.input.timeRange.n optional Int
The number of time units for the
LAST_N
relative periods.metric.timeSeries.input.timeRange.start optional DateTime
The optional start timestamp (inclusive). Defaults to the timestamp of the earliest record in the Data Pool.
metric.timeSeries.input.timeRange.stop optional DateTime
The optional end timestamp (exclusive). Defaults to the timestamp of the latest record in the Data Pool.
metric.timeSeries.input.granularity required TimeSeriesGranularity
The time granularity (hour, day, month, etc.) to aggregate the Metric values by.
The available time series granularities. Granularities define the unit of time to aggregate the Metric data for a time series query.
For example, if the granularity is set to
DAY
, then the the time series query will return a label and a value for each day.If there are no records for a given time series granularity, Propel will return the label and a value of "0" so that the time series can be properly visualized.
MINUTE
Aggregates values by minute intervals.
FIVE_MINUTES
Aggregates values by 5-minute intervals.
TEN_MINUTES
Aggregates values by 10-minute intervals.
FIFTEEN_MINUTES
Aggregates values by 15-minute intervals.
HOUR
Aggregates values by hourly intervals.
DAY
Aggregates values by daily intervals.
WEEK
Aggregates values by weekly intervals.
MONTH
Aggregates values by monthly intervals.
YEAR
Aggregates values by yearly intervals.
metric.timeSeries.input.filters optional array of FilterInput
The Query Filters to apply before retrieving the time series data. If no Query Filters are provided, all data is included.
The fields for defining a Filter.
metric.timeSeries.input.filters.column required String
The name of the column to filter on.
metric.timeSeries.input.filters.operator required FilterOperator
The operation to perform when comparing the column and filter values.
The available Filter operators.
EQUALS
Selects values that are equal to the specified value.
NOT_EQUALS
Selects values that are not equal to the specified value.
GREATER_THAN
Selects values that are greater than the specified value.
GREATER_THAN_OR_EQUAL_TO
Selects values that are greater or equal to the specified value.
LESS_THAN
Selects values that are less than the specified value.
LESS_THAN_OR_EQUAL_TO
Selects values that are less or equal to the specified value.
metric.timeSeries.input.filters.value required String
The value to compare the column to.
metric.timeSeries.input.propeller optional Propeller
Optionally specifies the Propeller to use. This can be set by Users when querying from the Metric Playground or GraphQL Explorer. Applications may not set this value. Instead, Application Queries always use the Propeller configured on the Application.
A Propeller determines your Application's query processing power. The larger the Propeller, the faster the queries and the higher the cost. Every Propel Application (and therefore every set of API credentials) has a Propeller that determines the speed and cost of queries.
Learn more about Data Sources.
P1_X_SMALL
Max records per second: 5,000,000 records per second
P1_SMALL
Max records per second: 25,000,000 records per second
P1_MEDIUM
Max records per second: 100,000,000 records per second
P1_LARGE
Max records per second: 250,000,000 records per second
P1_X_LARGE
Max records per second: 500,000,000 records per second
metric.leaderboard nullable LeaderboardResponse
The Metric data in leaderboard format. A table (array of rows) with the selected dimensions and corresponding Metric values for the given time range and filters.
metric.leaderboard.input required LeaderboardInput
The fields for querying a Metric in leaderboard format.
A Metric's leaderboard query returns an ordered table of Dimension and Metric values over a given time range.
metric.leaderboard.input.timeRange required TimeRangeInput
The time range for calculating the leaderboard.
The fields required to specify the time range for a time series, counter, or leaderboard Metric query.
If no relative or absolute time ranges are provided, Propel defaults to an absolute time range beginning with the earliest record in the Metric's Data Pool and ending with the latest record.
If both relative and absolute time ranges are provided, the relative time range will take precedence.
If a
LAST_N
relative time period is selected, ann
≥ 1 must be provided. If non
is provided orn
< 1, aBAD_REQUEST
error will be returned.metric.leaderboard.input.timeRange.relative optional RelativeTimeRange
The relative time period.
The Relative time ranges are based on the current date and time.
THIS
- The current unit of time. For example, if today is June 8, 2022, andTHIS_MONTH
is selected, then data for June 2022 would be returned.PREVIOUS
- The previous unit of time. For example, if today is June 8, 2022, andPREVIOUS_MONTH
is selected, then data for May 2022 would be returned. It excludes the current unit of time.NEXT
- The next unit of time. For example, if today is June 8, 2022, andNEXT_MONTH
is selected, then data for July 2022 would be returned. It excludes the current unit of time.LAST_N
- The lastn
units of time, including the current one. For example, if today is June 8, 2022 andLAST_N_YEARS
withn
= 3 is selected, then data for 2020, 2021, and 2022 will be returned. It will include the current time period.THIS_HOUR
Starts at the zeroth minute of the current hour and continues for 60 minutes.
TODAY
Starts at 12:00:00 AM of the current day and continues for 24 hours.
THIS_WEEK
Starts on Monday, 12:00:00 AM of the current week and continues for seven days.
THIS_MONTH
Starts at 12:00:00 AM on the first day of the current month and continues for the duration of the month.
THIS_QUARTER
Starts at 12:00:00 AM on the first day of the current calendar quarter and continues for the duration of the quarter.
THIS_YEAR
Starts on January 1st, 12:00:00 AM of the current year and continues for the duration of the year.
PREVIOUS_HOUR
Starts at the zeroth minute of the previous hour and continues for 60 minutes.
YESTERDAY
Starts at 12:00:00 AM on the day before the today and continues for 24 hours.
PREVIOUS_WEEK
Starts on Monday, 12:00:00 AM, a week before the current week, and continues for seven days.
PREVIOUS_MONTH
Starts at 12:00:00 AM on the first day of the month before the current month and continues for the duration of the month.
PREVIOUS_QUARTER
Starts at 12:00:00 AM on the first day of the calendar quarter before the current quarter and continues for the duration of the quarter.
PREVIOUS_YEAR
Starts on January 1st, 12:00:00 AM, the year before the current year, and continues for the duration of the year.
NEXT_HOUR
Starts at the zeroth minute of the next hour and continues for 60 minutes.
TOMORROW
" Starts at 12:00:00 AM, the day after the current day, and continues for 24 hours.
NEXT_WEEK
Starts on Monday, 12:00:00 AM, the week after the current week, and continues for the duration of the week.
NEXT_MONTH
Starts at 12:00:00 AM on the first day of the next month and continues for the duration of the month.
NEXT_QUARTER
Starts at 12:00:00 AM on the first day of the next calendar quarter and continues for the duration of the quarter.
NEXT_YEAR
Starts on January 1st, 12:00:00 AM of the next year and continues for the duration of the year.
LAST_N_MINUTES
Starts at the zeroth second
n
- 1 minute(s) before the current minute and continues through the current minute. It includes this minute.LAST_N_HOURS
Starts at the zeroth minute of the
n
- 1 hour(s) before the current hour, and continues through the current hour. It includes this hour.LAST_N_DAYS
Starts at 12:00:00 AM,
n
- 1 day(s) before the current day, and continues through the current day. It includes today.LAST_N_WEEKS
Starts on Monday, 12:00:00 AM,
n
- 1 week(s) before the current week, and continues through the current week. It includes this week.LAST_N_MONTHS
Starts at 12:00:00 AM on the first day of the month,
n
- 1 month(s) before the current month, and continues through the current month. It includes this month.LAST_N_QUARTERS
Starts at 12:00:00 AM on the first day of the calendar quarter
n
- 1 quarter(s) before the current quarter and continues through the current quarter. It includes this quarter.LAST_N_YEARS
Starts on January 1st, 12:00:00 AM of the year
n
- 1 year(s) before the current year and continues through the current year. It includes this year.LAST_15_MINUTES ⚠️ Deprecated: Use
LAST_N_MINUTES
instead.LAST_30_MINUTES ⚠️ Deprecated: Use
LAST_N_MINUTES
instead.LAST_HOUR ⚠️ Deprecated: Use
LAST_N_HOURS
instead.LAST_4_HOURS ⚠️ Deprecated: Use
LAST_N_HOURS
instead.LAST_12_HOURS ⚠️ Deprecated: Use
LAST_N_HOURS
instead.LAST_24_HOURS ⚠️ Deprecated: Use
LAST_N_HOURS
instead.LAST_7_DAYS ⚠️ Deprecated: Use
LAST_N_DAYS
instead.LAST_30_DAYS ⚠️ Deprecated: Use
LAST_N_DAYS
instead.LAST_90_DAYS ⚠️ Deprecated: Use
LAST_N_DAYS
instead.LAST_3_MONTHS ⚠️ Deprecated: Use
LAST_N_MONTHS
instead.LAST_6_MONTHS ⚠️ Deprecated: Use
LAST_N_MONTHS
instead.LAST_YEAR ⚠️ Deprecated: Use
LAST_N_YEARS
instead.LAST_2_YEARS ⚠️ Deprecated: Use
LAST_N_YEARS
instead.LAST_5_YEARS ⚠️ Deprecated: Use
LAST_N_YEARS
instead.
metric.leaderboard.input.timeRange.n optional Int
The number of time units for the
LAST_N
relative periods.metric.leaderboard.input.timeRange.start optional DateTime
The optional start timestamp (inclusive). Defaults to the timestamp of the earliest record in the Data Pool.
metric.leaderboard.input.timeRange.stop optional DateTime
The optional end timestamp (exclusive). Defaults to the timestamp of the latest record in the Data Pool.
metric.leaderboard.input.dimensions required array of DimensionInput
One or many Dimensions to group the Metric values by. Typically, Dimensions in a leaderboard are what you want to compare and rank.
The fields for creating or modifying a Dimension.
metric.leaderboard.input.dimensions.columnName required String
The name of the column to create the Dimension from.
metric.leaderboard.input.sort optional Sort
The sort order of the rows. It can be ascending (
ASC
) or descending (DESC
) order. Defaults to descending (DESC
) order when not provided.The sort order options for Metric Queries.
ASC
Sort in ascending order.
DESC
Sort in descending order.
metric.leaderboard.input.rowLimit required Int
The number of rows to be returned. It can be a number between 1 and 1,000.
metric.leaderboard.input.filters optional array of FilterInput
The list of filters to apply before retrieving the leaderboard data. If no Query Filters are provided, all data is included.
The fields for defining a Filter.
metric.leaderboard.input.filters.column required String
The name of the column to filter on.
metric.leaderboard.input.filters.operator required FilterOperator
The operation to perform when comparing the column and filter values.
The available Filter operators.
EQUALS
Selects values that are equal to the specified value.
NOT_EQUALS
Selects values that are not equal to the specified value.
GREATER_THAN
Selects values that are greater than the specified value.
GREATER_THAN_OR_EQUAL_TO
Selects values that are greater or equal to the specified value.
LESS_THAN
Selects values that are less than the specified value.
LESS_THAN_OR_EQUAL_TO
Selects values that are less or equal to the specified value.
metric.leaderboard.input.filters.value required String
The value to compare the column to.
metric.leaderboard.input.propeller optional Propeller
Optionally specifies the Propeller to use. This can be set by Users when querying from the Metric Playground or GraphQL Explorer. Applications may not set this value. Instead, Application Queries always use the Propeller configured on the Application.
A Propeller determines your Application's query processing power. The larger the Propeller, the faster the queries and the higher the cost. Every Propel Application (and therefore every set of API credentials) has a Propeller that determines the speed and cost of queries.
Learn more about Data Sources.
P1_X_SMALL
Max records per second: 5,000,000 records per second
P1_SMALL
Max records per second: 25,000,000 records per second
P1_MEDIUM
Max records per second: 100,000,000 records per second
P1_LARGE
Max records per second: 250,000,000 records per second
P1_X_LARGE
Max records per second: 500,000,000 records per second
metric.policies non-null PolicyConnection
List the Policies associated to the Metric.
metric.accessControlEnabled non-null Boolean
Whether or not access control is enabled for the Metric.
metric.measure nullable Dimension ⚠️ Deprecated: Use the Metric
settings
object instead.The Metric's measure. Access this from the Metric's
settings
object instead.