Skip to main content

CreateCountDistinctMetricInput

The fields for creating a new Count Distinct Metric.

fields

  • dataPool required ID

    The Data Pool that powers this Metric.

  • uniqueName optional String

    The Metric's unique name. If not specified, Propel will set the ID as unique name.

  • description optional String

    The Metric's description.

  • filters optional array of FilterInput

    The Metric's Filters. Metric Filters allow defining a Metric with a subset of records from the given Data Pool. If no Filters are present, all records will be included.

    The fields for defining a Filter.

    • filters.column required String

      The name of the column to filter on.

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

    • filters.value required String

      The value to compare the column to.

  • dimensions optional array of DimensionInput

    The Metric's Dimensions. Dimensions define the columns that will be available to filter the Metric at query time.

    The fields for creating or modifying a Dimension.

    • dimensions.columnName required String

      The name of the column to create the Dimension from.

  • dimension required DimensionInput

    The Dimension over which the count distinct operation is going to be performed.

    The fields for creating or modifying a Dimension.

    • dimension.columnName required String

      The name of the column to create the Dimension from.