aggr_max_by_zsjd_of_sum_by_store_1
aggr_max_by_zsjd_of_sum_by_store_1
{ "name": "aggr_max_by_zsjd_of_sum_by_store_1", "type": "metric", "content": { "type": "function_divide", "content": [ { "type": "function_max", "content": [ { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "aggregateBy": [ "transactions.store_id" ] } } ] }, { "type": "function_sum", "content": [ { "type": "function_min", "content": [ { "type": "property", "value": "zsj_desc.population" } ], "options": { "aggregateBy": [ "zsj_desc.kod_zsj_d" ] } } ] } ] } }
one_metric_two_primary_keys_1
one_metric_two_primary_keys_1
{ "name": "one_metric_two_primary_keys_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } }
filter_by_boolean_or_and_1
filter_by_boolean_or_and_1
{ "name": "filter_by_boolean_or_and_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } }
accept_aggr_by_1
accept_aggr_by_1
{ "name": "accept_aggr_by_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "acceptAggregateBy": [ "zsj_desc" ] } } }
accept_aggr_by_2
accept_aggr_by_2
{ "name": "accept_aggr_by_2", "type": "metric", "content": { "type": "function_count", "content": [ { "type": "property", "value": "transactions.identifier" } ], "options": { "acceptAggregateBy": [ "zsj*" ] } } }
accept_aggr_by_3
accept_aggr_by_3
{ "name": "accept_aggr_by_3", "type": "metric", "content": { "type": "function_count", "content": [ { "type": "property", "value": "transactions.store_id" } ], "options": { "dontAggregateBy": [ "customers" ] } } }
filter_by_attribute_global_1
filter_by_attribute_global_1
{ "name": "filter_by_attribute_global_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "zsj_desc.population" } ], "options": { "withoutFilters": [ "transactions.store_id" ], "filterBy": [ { "property": "transactions.store_id", "value": 101, "operator": "ne" }, { "property": "zsj_desc.kod_zsj_d", "query": { "properties": [ { "id": "kod_zsj_d", "type": "property", "value": "zsj_desc.kod_zsj_d" }, { "id": "transaction_sum", "type": "function_multiply", "content": [ { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] }, { "type": "variable", "value": "number_100" } ] } ], "having": [ { "propertyId": "transaction_sum", "value": 700, "operator": "gt" } ] }, "operator": "inAttribute" } ] } } }
sort_null_1
sort_null_1
{ "name": "sort_null_1", "type": "metric", "content": { "type": "function_plus", "content": [ { "type": "function_ifnull", "content": [ { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "filterBy": [ { "property": "transactions.store_id", "value": 101, "operator": "eq" } ] } }, { "type": "number", "value": 0.0 } ] }, { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "filterBy": [ { "property": "transactions.store_id", "value": 102, "operator": "eq" } ] } } ] } }
sort_null_2
sort_null_2
{ "name": "sort_null_2", "type": "metric", "content": { "type": "function_percentile", "content": [ { "type": "function_plus", "content": [ { "type": "function_ifnull", "content": [ { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "filterBy": [ { "property": "transactions.store_id", "value": 101, "operator": "eq" } ] } }, { "type": "number", "value": 0.0 } ] }, { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "filterBy": [ { "property": "transactions.store_id", "value": 102, "operator": "eq" } ] } } ] } ], "options": { "sort": "desc" } } }
sort_null_3
sort_null_3
{ "name": "sort_null_3", "type": "metric", "content": { "type": "function_rank", "content": [ { "type": "function_plus", "content": [ { "type": "function_ifnull", "content": [ { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "filterBy": [ { "property": "transactions.store_id", "value": 101, "operator": "eq" } ] } }, { "type": "number", "value": 0.0 } ] }, { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "filterBy": [ { "property": "transactions.store_id", "value": 102, "operator": "eq" } ] } } ] } ], "options": { "sort": "desc" } } }
permission_aggregate_zsjd_1
permission_aggregate_zsjd_1
{ "name": "permission_aggregate_zsjd_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } }
permission_aggregate_zsjd_2
permission_aggregate_zsjd_2
{ "name": "permission_aggregate_zsjd_2", "type": "metric", "content": { "type": "function_count", "content": [ { "type": "property", "value": "transactions.store_id" } ] } }
permission_aggregate_zsjd_3
permission_aggregate_zsjd_3
{ "name": "permission_aggregate_zsjd_3", "type": "metric", "content": { "type": "function_count_dist", "content": [ { "type": "property", "value": "transactions.store_id" } ] } }
permission_aggregate_zsjd_4
permission_aggregate_zsjd_4
{ "name": "permission_aggregate_zsjd_4", "type": "metric", "content": { "type": "function_avg", "content": [ { "type": "property", "value": "transactions.value" } ] } }
permission_aggregate_zsjd_5
permission_aggregate_zsjd_5
{ "name": "permission_aggregate_zsjd_5", "type": "metric", "content": { "type": "function_max", "content": [ { "type": "property", "value": "transactions.value" } ] } }
permission_aggregate_zsjd_6
permission_aggregate_zsjd_6
{ "name": "permission_aggregate_zsjd_6", "type": "metric", "content": { "type": "function_min", "content": [ { "type": "property", "value": "transactions.value" } ] } }
permission_aggregate_zsjd_7
permission_aggregate_zsjd_7
{ "name": "permission_aggregate_zsjd_7", "type": "metric", "content": { "type": "function_stddev_samp", "content": [ { "type": "property", "value": "transactions.value" } ] } }
aggr_sum_of_max_multiply_number_1
aggr_sum_of_max_multiply_number_1
{ "name": "aggr_sum_of_max_multiply_number_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "function_multiply", "content": [ { "type": "number", "value": 1000.0 }, { "type": "function_max", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "aggregateBy": [ "transactions.store_id" ] } } ] } ] } }
filter_by_function_1
filter_by_function_1
{ "name": "filter_by_function_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } }
filter_by_attribute_nested_1
filter_by_attribute_nested_1
{ "name": "filter_by_attribute_nested_1", "type": "metric", "content": { "type": "function_multiply", "content": [ { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "withoutFilters": [ "transactions.store_id" ], "filterBy": [ { "property": "zsj_desc.kod_zsj_d", "query": { "properties": [ { "id": "kod_zsj_d", "type": "property", "value": "zsj_desc.kod_zsj_d" } ] }, "operator": "inAttribute" }, { "property": "transactions.value", "value": 50, "operator": "gte" } ] } }, { "id": "nested_in_attribute", "type": "number", "value": 13.0 } ] } }
aggr_sum_of_max_accept_aggr_by_1
aggr_sum_of_max_accept_aggr_by_1
{ "name": "aggr_sum_of_max_accept_aggr_by_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "function_max", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "aggregateBy": [ "transactions.store_id" ], "acceptAggregateBy": [ "transactions" ] } } ] } }
aggr_sum_of_max_by_store_customer_1
aggr_sum_of_max_by_store_customer_1
{ "name": "aggr_sum_of_max_by_store_customer_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "function_max", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "aggregateBy": [ "transactions.store_id", "transactions.customer_id" ] } } ] } }
one_metric_two_attrs_1
one_metric_two_attrs_1
{ "name": "one_metric_two_attrs_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } }
rank_of_arithm_1
rank_of_arithm_1
{ "name": "rank_of_arithm_1", "type": "metric", "content": { "type": "function_rank", "content": [ { "type": "function_divide", "content": [ { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] }, { "type": "function_count", "content": [ { "type": "property", "value": "transactions.identifier" } ] } ] } ], "options": { "sort": "desc" } } }
rank_of_arithm_2
rank_of_arithm_2
{ "name": "rank_of_arithm_2", "type": "metric", "content": { "type": "function_divide", "content": [ { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] }, { "type": "function_count", "content": [ { "type": "property", "value": "transactions.identifier" } ] } ] } }
percentile_1
percentile_1
{ "name": "percentile_1", "type": "metric", "content": { "type": "function_percentile", "content": [ { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } ], "options": { "sort": "desc" } } }
percentile_2
percentile_2
{ "name": "percentile_2", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } }
filter_by_date_1
filter_by_date_1
{ "name": "filter_by_date_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } }
aggr_by_null_filter_1
aggr_by_null_filter_1
{ "name": "aggr_by_null_filter_1", "type": "metric", "content": { "type": "function_divide", "content": [ { "type": "function_count", "content": [ { "type": "property", "value": "transactions.customer_id" } ] }, { "type": "function_count", "content": [ { "type": "property", "value": "transactions.customer_id" } ], "options": { "aggregateBy": [ null ] } } ] } }
accept_aggr_by_null_1
accept_aggr_by_null_1
{ "name": "accept_aggr_by_null_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "acceptAggregateBy": [ "zsj_desc", null ] } } }
accept_aggr_by_null_2
accept_aggr_by_null_2
{ "name": "accept_aggr_by_null_2", "type": "metric", "content": { "type": "function_count", "content": [ { "type": "property", "value": "transactions.identifier" } ], "options": { "acceptAggregateBy": [ null ] } } }
sort_null_asc_1
sort_null_asc_1
{ "name": "sort_null_asc_1", "type": "metric", "content": { "type": "function_plus", "content": [ { "type": "function_ifnull", "content": [ { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "filterBy": [ { "property": "transactions.store_id", "value": 101, "operator": "eq" } ] } }, { "type": "number", "value": 0.0 } ] }, { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "filterBy": [ { "property": "transactions.store_id", "value": 102, "operator": "eq" } ] } } ] } }
sort_null_asc_2
sort_null_asc_2
{ "name": "sort_null_asc_2", "type": "metric", "content": { "type": "function_percentile", "content": [ { "type": "function_plus", "content": [ { "type": "function_ifnull", "content": [ { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "filterBy": [ { "property": "transactions.store_id", "value": 101, "operator": "eq" } ] } }, { "type": "number", "value": 0.0 } ] }, { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "filterBy": [ { "property": "transactions.store_id", "value": 102, "operator": "eq" } ] } } ] } ], "options": { "sort": "desc" } } }
sort_null_asc_3
sort_null_asc_3
{ "name": "sort_null_asc_3", "type": "metric", "content": { "type": "function_rank", "content": [ { "type": "function_plus", "content": [ { "type": "function_ifnull", "content": [ { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "filterBy": [ { "property": "transactions.store_id", "value": 101, "operator": "eq" } ] } }, { "type": "number", "value": 0.0 } ] }, { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "filterBy": [ { "property": "transactions.store_id", "value": 102, "operator": "eq" } ] } } ] } ], "options": { "sort": "desc" } } }
having_filter_count_by_decimal_1
having_filter_count_by_decimal_1
{ "name": "having_filter_count_by_decimal_1", "type": "metric", "content": { "type": "function_count", "content": [ { "type": "property", "value": "transactions.identifier" } ] } }
accept_without_filters_1
accept_without_filters_1
{ "name": "accept_without_filters_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "acceptFilters": [ "transactions.*" ], "filterBy": [ { "property": "transactions.store_id", "value": 100, "operator": "eq" }, { "property": "transactions.value", "value": 50, "operator": "gte" } ] } } }
accept_without_filters_2
accept_without_filters_2
{ "name": "accept_without_filters_2", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "acceptFilters": [ "transactions.store_id" ], "filterBy": [ { "property": "transactions.store_id", "value": 100, "operator": "eq" }, { "property": "transactions.value", "value": 50, "operator": "gte" } ] } } }
accept_without_filters_3
accept_without_filters_3
{ "name": "accept_without_filters_3", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "withoutFilters": [ "customers.*", "transactions.store*" ], "filterBy": [ { "property": "transactions.store_id", "value": 100, "operator": "eq" }, { "property": "transactions.value", "value": 50, "operator": "gte" } ] } } }
percentile_same_values_1
percentile_same_values_1
{ "name": "percentile_same_values_1", "type": "metric", "content": { "type": "function_percentile", "content": [ { "type": "function_count", "content": [ { "type": "property", "value": "transactions.customer_id" } ] } ], "options": { "sort": "desc" } } }
percentile_same_values_2
percentile_same_values_2
{ "name": "percentile_same_values_2", "type": "metric", "content": { "type": "function_count", "content": [ { "type": "property", "value": "transactions.customer_id" } ] } }
round_property_1
round_property_1
{ "name": "round_property_1", "type": "metric", "content": { "type": "function_round", "content": [ { "type": "function_divide", "content": [ { "type": "property", "value": "transactions.value" }, { "type": "number", "value": 1000.0 } ] } ], "options": { "places": 1 } } }
round_property_2
round_property_2
{ "name": "round_property_2", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } }
permission_filter_by_attribute_nested_1
permission_filter_by_attribute_nested_1
{ "name": "permission_filter_by_attribute_nested_1", "type": "metric", "content": { "type": "function_multiply", "content": [ { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "withoutFilters": [ "transactions.store_id" ], "filterBy": [ { "property": "zsj_desc.kod_zsj_d", "query": { "properties": [ { "id": "kod_zsj_d", "type": "property", "value": "zsj_desc.kod_zsj_d" } ] }, "operator": "inAttribute" }, { "property": "transactions.value", "value": 50, "operator": "gte" } ] } }, { "id": "nested_in_attribute", "type": "number", "value": 13.0 } ] } }
ntile_1
ntile_1
{ "name": "ntile_1", "type": "metric", "content": { "type": "function_ntile", "content": [ { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } ], "options": { "sort": "desc", "buckets": 3 } } }
ntile_2
ntile_2
{ "name": "ntile_2", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } }
round_1
round_1
{ "name": "round_1", "type": "metric", "content": { "type": "function_round", "content": [ { "type": "function_avg", "content": [ { "type": "property", "value": "transactions.value" } ] } ], "options": { "places": 1 } } }
round_2
round_2
{ "name": "round_2", "type": "metric", "content": { "type": "function_round", "content": [ { "type": "function_avg", "content": [ { "type": "property", "value": "transactions.value" } ] } ], "options": { "places": -2 } } }
round_3
round_3
{ "name": "round_3", "type": "metric", "content": { "type": "function_avg", "content": [ { "type": "function_round", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "places": 1 } } ] } }
round_4
round_4
{ "name": "round_4", "type": "metric", "content": { "type": "function_round", "content": [ { "type": "function_divide", "content": [ { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] }, { "type": "number", "value": 1000.0 } ] } ], "options": { "places": 1 } } }
round_5
round_5
{ "name": "round_5", "type": "metric", "content": { "type": "function_divide", "content": [ { "type": "function_round", "content": [ { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } ], "options": { "places": 1 } }, { "type": "number", "value": 1000.0 } ] } }
filter_by_attribute_sum_of_max_1
filter_by_attribute_sum_of_max_1
{ "name": "filter_by_attribute_sum_of_max_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "zsj_desc.population" } ], "options": { "withoutFilters": [ "transactions.store_id" ], "filterBy": [ { "property": "zsj_desc.kod_zsj_d", "query": { "properties": [ { "id": "kod_zsj_d", "type": "property", "value": "zsj_desc.kod_zsj_d" }, { "id": "transaction_sum_max_customer", "type": "function_sum", "content": [ { "type": "function_max", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "aggregateBy": [ "transactions.customer_id" ] } } ] } ], "having": [ { "propertyId": "transaction_sum_max_customer", "value": 65, "operator": "gte" } ] }, "operator": "inAttribute" }, { "property": "transactions.store_id", "value": 101, "operator": "ne" } ] } } }
aggregate_zsjd_1
aggregate_zsjd_1
{ "name": "aggregate_zsjd_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } }
aggregate_zsjd_2
aggregate_zsjd_2
{ "name": "aggregate_zsjd_2", "type": "metric", "content": { "type": "function_count", "content": [ { "type": "property", "value": "transactions.store_id" } ] } }
aggregate_zsjd_3
aggregate_zsjd_3
{ "name": "aggregate_zsjd_3", "type": "metric", "content": { "type": "function_count_dist", "content": [ { "type": "property", "value": "transactions.store_id" } ] } }
aggregate_zsjd_4
aggregate_zsjd_4
{ "name": "aggregate_zsjd_4", "type": "metric", "content": { "type": "function_avg", "content": [ { "type": "property", "value": "transactions.value" } ] } }
aggregate_zsjd_5
aggregate_zsjd_5
{ "name": "aggregate_zsjd_5", "type": "metric", "content": { "type": "function_max", "content": [ { "type": "property", "value": "transactions.value" } ] } }
aggregate_zsjd_6
aggregate_zsjd_6
{ "name": "aggregate_zsjd_6", "type": "metric", "content": { "type": "function_min", "content": [ { "type": "property", "value": "transactions.value" } ] } }
aggregate_zsjd_7
aggregate_zsjd_7
{ "name": "aggregate_zsjd_7", "type": "metric", "content": { "type": "function_stddev_samp", "content": [ { "type": "property", "value": "transactions.value" } ] } }
rank_1
rank_1
{ "name": "rank_1", "type": "metric", "content": { "type": "function_rank", "content": [ { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } ], "options": { "sort": "desc" } } }
rank_2
rank_2
{ "name": "rank_2", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } }
sort_1
sort_1
{ "name": "sort_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } }
filter_by_function_today_1
filter_by_function_today_1
{ "name": "filter_by_function_today_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } }
aggr_sum_of_max_plus_min_1
aggr_sum_of_max_plus_min_1
{ "name": "aggr_sum_of_max_plus_min_1", "type": "metric", "content": { "type": "function_plus", "content": [ { "type": "function_sum", "content": [ { "type": "function_max", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "aggregateBy": [ "transactions.store_id" ] } } ] }, { "type": "function_min", "content": [ { "type": "property", "value": "transactions.value" } ] } ] } }
filter_by_boolean_1
filter_by_boolean_1
{ "name": "filter_by_boolean_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } }
having_just_one_zsjd_1
having_just_one_zsjd_1
{ "name": "having_just_one_zsjd_1", "type": "metric", "content": { "type": "function_divide", "content": [ { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] }, { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "aggregateBy": [ null ], "withoutFilters": [ "transactions.store_id" ] } } ] } }
filter_by_boolean_without_filters_1
filter_by_boolean_without_filters_1
{ "name": "filter_by_boolean_without_filters_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } }
filter_by_boolean_without_filters_2
filter_by_boolean_without_filters_2
{ "name": "filter_by_boolean_without_filters_2", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "withoutFilters": [ "trans*.va*" ], "filterBy": [ { "operator": "or", "content": [ { "property": "transactions.value", "value": 20, "operator": "lte" }, { "property": "transactions.value", "value": 80, "operator": "gte" } ] } ] } } }
aggr_sum_by_store_of_max_by_customer_1
aggr_sum_by_store_of_max_by_customer_1
{ "name": "aggr_sum_by_store_of_max_by_customer_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "function_max", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "aggregateBy": [ "transactions.store_id" ] } } ] } }
filter_by_attribute_variable_1
filter_by_attribute_variable_1
{ "name": "filter_by_attribute_variable_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "zsj_desc.population" } ], "options": { "withoutFilters": [ "transactions.store_id" ], "filterBy": [ { "property": "zsj_desc.kod_zsj_d", "query": { "properties": [ { "id": "kod_zsj_d", "type": "property", "value": "zsj_desc.kod_zsj_d" }, { "id": "transaction_sum", "type": "function_multiply", "content": [ { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] }, { "type": "variable", "value": "number_100" } ] } ], "having": [ { "propertyId": "transaction_sum", "value": 700, "operator": "gt" } ] }, "operator": "inAttribute" }, { "property": "transactions.store_id", "value": 101, "operator": "ne" } ] } } }
aggr_by_null_1
aggr_by_null_1
{ "name": "aggr_by_null_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "aggregateBy": [ null ] } } }
aggr_by_null_2
aggr_by_null_2
{ "name": "aggr_by_null_2", "type": "metric", "content": { "type": "function_count", "content": [ { "type": "property", "value": "transactions.identifier" } ], "options": { "aggregateBy": [ null ] } } }
aggr_by_null_3
aggr_by_null_3
{ "name": "aggr_by_null_3", "type": "metric", "content": { "type": "function_count", "content": [ { "type": "property", "value": "transactions.store_id" } ], "options": { "aggregateBy": [ null ] } } }
aggr_by_customer_1
aggr_by_customer_1
{ "name": "aggr_by_customer_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "aggregateBy": [ "transactions.customer_id" ] } } }
aggr_by_customer_2
aggr_by_customer_2
{ "name": "aggr_by_customer_2", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "aggregateBy": [ "transactions.store_id" ] } } }
aggr_by_customer_3
aggr_by_customer_3
{ "name": "aggr_by_customer_3", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "aggregateBy": [ null ] } } }
variable_1
variable_1
{ "name": "variable_1", "type": "metric", "content": { "type": "function_divide", "content": [ { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] }, { "type": "variable", "value": "number_1000" } ] } }
variable_2
variable_2
{ "name": "variable_2", "type": "metric", "content": { "type": "function_minus", "content": [ { "type": "variable", "value": "number_625" }, { "type": "function_multiply", "content": [ { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] }, { "type": "variable", "value": "number_121" } ] } ] } }
variable_3
variable_3
{ "name": "variable_3", "type": "metric", "content": { "type": "function_multiply", "content": [ { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] }, { "type": "variable", "value": "number_121" }, { "type": "function_count", "content": [ { "type": "property", "value": "transactions.store_id" } ] } ] } }
accept_filters_1
accept_filters_1
{ "name": "accept_filters_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "acceptFilters": [ "transactions.*" ], "filterBy": [ { "property": "transactions.store_id", "value": 100, "operator": "eq" }, { "property": "transactions.value", "value": 50, "operator": "gte" } ] } } }
accept_filters_2
accept_filters_2
{ "name": "accept_filters_2", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "acceptFilters": [ "transactions.store_id" ], "filterBy": [ { "property": "transactions.store_id", "value": 100, "operator": "eq" }, { "property": "transactions.value", "value": 50, "operator": "gte" } ] } } }
accept_filters_3
accept_filters_3
{ "name": "accept_filters_3", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "acceptFilters": [ "customers.*" ], "filterBy": [ { "property": "transactions.store_id", "value": 100, "operator": "eq" }, { "property": "transactions.value", "value": 50, "operator": "gte" } ] } } }
big_numbers_1
big_numbers_1
{ "name": "big_numbers_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "function_multiply", "content": [ { "type": "property", "value": "transactions.value" }, { "type": "number", "value": 1.0E9 } ] } ] } }
big_numbers_2
big_numbers_2
{ "name": "big_numbers_2", "type": "metric", "content": { "type": "function_multiply", "content": [ { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] }, { "type": "number", "value": 4.56789123435E9 } ], "_comment": "returns the first 12 digits, without decimal part" } }
big_numbers_3
big_numbers_3
{ "name": "big_numbers_3", "type": "metric", "content": { "type": "function_multiply", "content": [ { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] }, { "type": "number", "value": 6.789123435E7 } ], "_comment": "returns the first 12 digits, with decimal part" } }
ntile_filter_by_1
ntile_filter_by_1
{ "name": "ntile_filter_by_1", "type": "metric", "content": { "type": "function_ntile", "content": [ { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } ], "options": { "sort": "desc", "buckets": 3, "filterBy": [ { "property": "zsj_desc.kod_zsj_d", "value": 11111, "operator": "eq" }, { "property": "transactions.value", "value": 35.2, "operator": "gte" } ] } } }
ntile_filter_by_2
ntile_filter_by_2
{ "name": "ntile_filter_by_2", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } }
filter_by_metric_inherit_granularities_1
filter_by_metric_inherit_granularities_1
{ "name": "filter_by_metric_inherit_granularities_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "withoutFilters": [ "transactions.processed_at" ], "filterBy": [ { "property": "transactions.processed_at", "query": { "properties": [ { "id": "max_date", "type": "function_max", "content": [ { "type": "property", "value": "transactions.processed_at" } ], "options": { "acceptAggregateBy": [ "transactions" ] } } ] }, "operator": "inAttribute" }, { "property": "transactions.processed_at", "value": "2015-11-01", "operator": "gte" }, { "property": "transactions.processed_at", "value": "2015-11-07", "operator": "lt" } ] } } }
filter_by_attribute_combined_1
filter_by_attribute_combined_1
{ "name": "filter_by_attribute_combined_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "withoutFilters": [ "transactions.store_id" ], "filterBy": [ { "property": "zsj_desc.kod_zsj_d", "query": { "properties": [ { "id": "kod_zsj_d", "type": "property", "value": "zsj_desc.kod_zsj_d" } ], "filterBy": [ { "property": "transactions.value", "value": 45, "operator": "gte" } ] }, "operator": "inAttribute" }, { "property": "transactions.value", "value": 25, "operator": "gte" }, { "property": "transactions.store_id", "value": 101, "operator": "ne" } ] } } }
filter_by_boolean_nor_1
filter_by_boolean_nor_1
{ "name": "filter_by_boolean_nor_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } }
aggr_sum_of_count_by_store_1
aggr_sum_of_count_by_store_1
{ "name": "aggr_sum_of_count_by_store_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "function_count", "content": [ { "type": "property", "value": "transactions.identifier" } ], "options": { "aggregateBy": [ "transactions.store_id" ] } } ] } }
filter_by_attribute_two_filters_nested_1
filter_by_attribute_two_filters_nested_1
{ "name": "filter_by_attribute_two_filters_nested_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } }
row_number_zsjd_store_by_revenue_1
row_number_zsjd_store_by_revenue_1
{ "name": "row_number_zsjd_store_by_revenue_1", "type": "metric", "content": { "type": "function_row_number", "content": [ { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } ], "options": { "partitionBy": [ "kod_zsj_d" ], "sort": "desc" } } }
rank_partition_by_1
rank_partition_by_1
{ "name": "rank_partition_by_1", "type": "metric", "content": { "type": "function_rank", "content": [ { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } ], "options": { "partitionBy": [ "kod_zsj_d" ], "sort": "desc" } } }
rank_partition_by_2
rank_partition_by_2
{ "name": "rank_partition_by_2", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } }
aggr_sum_of_max_by_store_1
aggr_sum_of_max_by_store_1
{ "name": "aggr_sum_of_max_by_store_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "function_max", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "aggregateBy": [ "transactions.store_id" ] } } ] } }
having_boolean_two_metrics_1
having_boolean_two_metrics_1
{ "name": "having_boolean_two_metrics_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } }
having_boolean_two_metrics_2
having_boolean_two_metrics_2
{ "name": "having_boolean_two_metrics_2", "type": "metric", "content": { "type": "function_count", "content": [ { "type": "property", "value": "transactions.identifier" } ] } }
filter_by_extern_property_1
filter_by_extern_property_1
{ "name": "filter_by_extern_property_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "zsj_desc.population" } ] } }
filter_by_attribute_two_filters_one_skippable_1
filter_by_attribute_two_filters_one_skippable_1
{ "name": "filter_by_attribute_two_filters_one_skippable_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "filterBy": [ { "property": "zsj_desc.kod_zsj_d", "query": { "properties": [ { "id": "kod_zsj_d", "type": "property", "value": "zsj_desc.kod_zsj_d" }, { "id": "population_where_store_id_ne_101", "type": "function_sum", "content": [ { "type": "property", "value": "zsj_desc.population" } ], "options": { "filterBy": [ { "property": "zsj_desc.kod_zsj_d", "query": { "properties": [ { "id": "kod_zsj_d", "type": "property", "value": "zsj_desc.kod_zsj_d" }, { "id": "aux_metric", "type": "function_count", "content": [ { "type": "property", "value": "zsj_desc.kod_zsj_d" } ], "options": { "withoutFilters": [ "*.*" ] } } ] }, "operator": "inAttribute", "_comment": "this attribute filter shloud be skipped, it has no filters" } ] } } ], "having": [ { "propertyId": "population_where_store_id_ne_101", "value": 500, "operator": "gte" } ] }, "operator": "inAttribute" } ] } } }
filter_by_metric_1
filter_by_metric_1
{ "name": "filter_by_metric_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "withoutFilters": [ "transactions.processed_at" ], "filterBy": [ { "property": "transactions.processed_at", "query": { "properties": [ { "id": "max_date", "type": "function_max", "content": [ { "type": "property", "value": "transactions.processed_at" } ] } ] }, "operator": "inAttribute" }, { "property": "transactions.processed_at", "value": "2015-11-01", "operator": "gte" }, { "property": "transactions.processed_at", "value": "2015-11-07", "operator": "lt" } ] } } }
aggr_count_by_customer_1
aggr_count_by_customer_1
{ "name": "aggr_count_by_customer_1", "type": "metric", "content": { "type": "function_count", "content": [ { "type": "property", "value": "transactions.identifier" } ], "options": { "aggregateBy": [ "transactions.customer_id" ] } } }
percentile_partition_by_1
percentile_partition_by_1
{ "name": "percentile_partition_by_1", "type": "metric", "content": { "type": "function_percentile", "content": [ { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } ], "options": { "partitionBy": [ "kod_zsj_d" ], "sort": "desc" } } }
percentile_partition_by_2
percentile_partition_by_2
{ "name": "percentile_partition_by_2", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } }
row_number_zsjd_store_avg_transaction_1
row_number_zsjd_store_avg_transaction_1
{ "name": "row_number_zsjd_store_avg_transaction_1", "type": "metric", "content": { "type": "function_row_number", "content": [ { "type": "function_divide", "content": [ { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "filterBy": [ { "property": "transactions.value", "value": 0, "operator": "gte" } ] } }, { "type": "function_count", "content": [ { "type": "property", "value": "transactions.identifier" } ] } ] } ], "options": { "partitionBy": [ "kod_zsj_d" ], "sort": "desc" } } }
aggr_max_sum_accept_aggregate_by_store_1
aggr_max_sum_accept_aggregate_by_store_1
{ "name": "aggr_max_sum_accept_aggregate_by_store_1", "type": "metric", "content": { "type": "function_max", "content": [ { "type": "function_divide", "content": [ { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "aggregateBy": [ "transactions.store_id" ] } }, { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "aggregateBy": [ "transactions.store_id" ], "acceptAggregateBy": [ "transactions" ] } } ] } ] } }
aggr_count_dist_by_customer_1
aggr_count_dist_by_customer_1
{ "name": "aggr_count_dist_by_customer_1", "type": "metric", "content": { "type": "function_count", "content": [ { "type": "property", "value": "transactions.processed_at" } ], "options": { "aggregateBy": [ "transactions.customer_id" ] } } }
round_property_count_1
round_property_count_1
{ "name": "round_property_count_1", "type": "metric", "content": { "type": "function_round", "content": [ { "type": "property", "value": "customers.lat" } ], "options": { "places": 1, "filterBy": [ { "property": "transactions.value", "value": 10, "operator": "gte" } ] } } }
round_property_count_2
round_property_count_2
{ "name": "round_property_count_2", "type": "metric", "content": { "type": "function_round", "content": [ { "type": "property", "value": "customers.lng" } ], "options": { "places": 1, "filterBy": [ { "property": "transactions.value", "value": 10, "operator": "gte" } ] } } }
round_property_count_3
round_property_count_3
{ "name": "round_property_count_3", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } }
round_property_count_4
round_property_count_4
{ "name": "round_property_count_4", "type": "metric", "content": { "type": "function_count", "content": [ { "type": "property", "value": "customers.identifier" } ] } }
having_boolean_1
having_boolean_1
{ "name": "having_boolean_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } }
filter_by_attribute_combined_cache_1
filter_by_attribute_combined_cache_1
{ "name": "filter_by_attribute_combined_cache_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "withoutFilters": [ "transactions.store_id" ], "filterBy": [ { "property": "zsj_desc.kod_zsj_d", "query": { "properties": [ { "id": "kod_zsj_d", "type": "property", "value": "zsj_desc.kod_zsj_d" } ], "filterBy": [ { "property": "transactions.value", "value": 45, "operator": "gte" } ] }, "operator": "inAttribute" }, { "property": "transactions.value", "value": 25, "operator": "gte" }, { "property": "transactions.store_id", "value": 101, "operator": "ne" } ] } } }
filter_by_1
filter_by_1
{ "name": "filter_by_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } }
filter_by_attribute_combined_1
filter_by_attribute_combined_1
{ "name": "filter_by_attribute_combined_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "withoutFilters": [ "transactions.store_id" ], "filterBy": [ { "property": "zsj_desc.kod_zsj_d", "query": { "properties": [ { "id": "kod_zsj_d", "type": "property", "value": "zsj_desc.kod_zsj_d" } ], "filterBy": [ { "property": "transactions.value", "value": 45, "operator": "gte" } ] }, "operator": "inAttribute" }, { "property": "transactions.value", "value": 25, "operator": "gte" }, { "property": "transactions.store_id", "value": 101, "operator": "ne" } ] } } }
aggr_sum_by_zsjd_of_max_plus_min_1
aggr_sum_by_zsjd_of_max_plus_min_1
{ "name": "aggr_sum_by_zsjd_of_max_plus_min_1", "type": "metric", "content": { "type": "function_plus", "content": [ { "type": "function_sum", "content": [ { "type": "function_max", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "aggregateBy": [ "transactions.store_id" ] } } ] }, { "type": "function_min", "content": [ { "type": "property", "value": "transactions.value" } ] } ] } }
can_2694_1
can_2694_1
{ "name": "can_2694_1", "type": "metric", "content": { "type": "function_divide", "content": [ { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] }, { "type": "number", "value": 1000.0 } ] } }
can_2694_2
can_2694_2
{ "name": "can_2694_2", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "filterBy": [ { "property": "transactions.store_id", "value": 100, "operator": "eq" } ] } } }
can_2694_3
can_2694_3
{ "name": "can_2694_3", "type": "metric", "content": { "type": "function_divide", "content": [ { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] }, { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "aggregateBy": [ null ], "withoutFilters": [ "zsj_desc.kod_zsj_d" ] } } ] } }
can_2751_1
can_2751_1
{ "name": "can_2751_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "filterBy": [ { "property": "transactions.store_id", "value": 100, "operator": "eq" } ] } } }
can_2751_2
can_2751_2
{ "name": "can_2751_2", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "zsj_desc.population" } ] } }
can_3062_1
can_3062_1
{ "name": "can_3062_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "filterBy": [ { "property": "transactions.value", "value": 100, "operator": "gt" } ] }, "_comment": "match only store=102" } }
can_3062_2
can_3062_2
{ "name": "can_3062_2", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "filterBy": [ { "property": "transactions.value", "value": 75, "operator": "gt" } ] }, "_comment": "match stores=[100,102]" } }
can_3062_3
can_3062_3
{ "name": "can_3062_3", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "filterBy": [ { "property": "transactions.value", "value": 50, "operator": "gt" } ] }, "_comment": "match stores=[100,102]" } }
can_7610_1
can_7610_1
{ "name": "can_7610_1", "type": "metric", "content": { "type": "function_multiply", "content": [ { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.identifier" } ] }, { "type": "number", "value": 13.467 } ] } }
can_7610_2
can_7610_2
{ "name": "can_7610_2", "type": "metric", "content": { "type": "function_plus", "content": [ { "type": "number", "value": 13.467 }, { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.identifier" } ] } ] } }
can_8366_1
can_8366_1
{ "name": "can_8366_1", "type": "metric", "content": { "type": "function_max", "content": [ { "type": "property", "value": "customers.identifier" } ] } }
can_8366_2
can_8366_2
{ "name": "can_8366_2", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } }
can_8477_1
can_8477_1
{ "name": "can_8477_1", "type": "metric", "content": { "type": "function_divide", "content": [ { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] }, { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "aggregateBy": [ null ] } } ] } }
aggr_max_sum_accept_aggregate_all_1
aggr_max_sum_accept_aggregate_all_1
{ "name": "aggr_max_sum_accept_aggregate_all_1", "type": "metric", "content": { "type": "function_max", "content": [ { "type": "function_divide", "content": [ { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "aggregateBy": [ "transactions.store_id" ] } }, { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "aggregateBy": [ "transactions.store_id" ], "acceptAggregateBy": [ "*" ] } } ] } ] } }
filter_pushdown_1
filter_pushdown_1
{ "name": "filter_pushdown_1", "type": "metric", "content": { "type": "function_max", "content": [ { "type": "property", "value": "customers.identifier" } ] } }
filter_pushdown_2
filter_pushdown_2
{ "name": "filter_pushdown_2", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } }
having_percent_turnover_1
having_percent_turnover_1
{ "name": "having_percent_turnover_1", "type": "metric", "content": { "type": "function_divide", "content": [ { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] }, { "type": "number", "value": 1000.0 } ] } }
having_percent_turnover_2
having_percent_turnover_2
{ "name": "having_percent_turnover_2", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "filterBy": [ { "property": "transactions.store_id", "value": 100, "operator": "eq" } ] } } }
having_percent_turnover_3
having_percent_turnover_3
{ "name": "having_percent_turnover_3", "type": "metric", "content": { "type": "function_divide", "content": [ { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] }, { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "aggregateBy": [ null ] } } ] } }
aggr_max_by_store_by_client_1
aggr_max_by_store_by_client_1
{ "name": "aggr_max_by_store_by_client_1", "type": "metric", "content": { "type": "function_max", "content": [ { "type": "function_divide", "content": [ { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "aggregateBy": [ "transactions.store_id" ] } }, { "type": "function_count", "content": [ { "type": "property", "value": "transactions.identifier" } ], "options": { "aggregateBy": [ "zsj_desc.kod_zsj_d" ], "filterBy": [ { "property": "transactions.customer_id", "value": 2002, "operator": "eq" } ] } } ] } ] } }
rank_with_filter_1
rank_with_filter_1
{ "name": "rank_with_filter_1", "type": "metric", "content": { "type": "function_rank", "content": [ { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "withoutFilters": [ "*.*" ] } } ], "options": { "sort": "desc", "filterBy": [ { "property": "transactions.store_id", "value": [ 100, 101 ], "operator": "in" } ] } } }
rank_with_filter_2
rank_with_filter_2
{ "name": "rank_with_filter_2", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "withoutFilters": [ "*.*" ], "filterBy": [ { "property": "transactions.store_id", "value": [ 100, 101 ], "operator": "in" } ] } } }
rank_with_filter_3
rank_with_filter_3
{ "name": "rank_with_filter_3", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } }
local_filter_1
local_filter_1
{ "name": "local_filter_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "filterBy": [ { "property": "transactions.store_id", "value": 100, "operator": "eq" }, { "property": "transactions.value", "value": 35.2, "operator": "gt" } ] } } }
local_filter_2
local_filter_2
{ "name": "local_filter_2", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } }
sort_combined_1
sort_combined_1
{ "name": "sort_combined_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } }
aggr_sum_of_max_by_store_filter_1
aggr_sum_of_max_by_store_filter_1
{ "name": "aggr_sum_of_max_by_store_filter_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "function_max", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "aggregateBy": [ "transactions.store_id", "transactions.customer_id" ], "filterBy": [ { "property": "transactions.store_id", "value": 102, "operator": "ne" } ] } } ] } }
filter_by_metric_inherit_granularities_dont_1
filter_by_metric_inherit_granularities_dont_1
{ "name": "filter_by_metric_inherit_granularities_dont_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "withoutFilters": [ "transactions.processed_at" ], "filterBy": [ { "property": "transactions.processed_at", "query": { "properties": [ { "id": "max_date", "type": "function_max", "content": [ { "type": "property", "value": "transactions.processed_at" } ], "options": { "dontAggregateBy": [ "customers" ] } } ] }, "operator": "inAttribute" }, { "property": "transactions.processed_at", "value": "2015-11-01", "operator": "gte" }, { "property": "transactions.processed_at", "value": "2015-11-07", "operator": "lt" } ] } } }
aggr_sum_of_max_multiply_min_1
aggr_sum_of_max_multiply_min_1
{ "name": "aggr_sum_of_max_multiply_min_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "function_multiply", "content": [ { "type": "function_max", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "aggregateBy": [ "zsj_desc.kod_zsj_d" ] } }, { "type": "function_min", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "aggregateBy": [ "transactions.store_id" ] } } ] } ] } }
sort_null_inverse_1
sort_null_inverse_1
{ "name": "sort_null_inverse_1", "type": "metric", "content": { "type": "function_plus", "content": [ { "type": "function_ifnull", "content": [ { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "filterBy": [ { "property": "transactions.store_id", "value": 101, "operator": "eq" } ] } }, { "type": "number", "value": 0.0 } ] }, { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "filterBy": [ { "property": "transactions.store_id", "value": 102, "operator": "eq" } ] } } ] } }
sort_null_inverse_2
sort_null_inverse_2
{ "name": "sort_null_inverse_2", "type": "metric", "content": { "type": "function_percentile", "content": [ { "type": "function_plus", "content": [ { "type": "function_ifnull", "content": [ { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "filterBy": [ { "property": "transactions.store_id", "value": 101, "operator": "eq" } ] } }, { "type": "number", "value": 0.0 } ] }, { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "filterBy": [ { "property": "transactions.store_id", "value": 102, "operator": "eq" } ] } } ] } ], "options": { "sort": "asc" } } }
sort_null_inverse_3
sort_null_inverse_3
{ "name": "sort_null_inverse_3", "type": "metric", "content": { "type": "function_rank", "content": [ { "type": "function_plus", "content": [ { "type": "function_ifnull", "content": [ { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "filterBy": [ { "property": "transactions.store_id", "value": 101, "operator": "eq" } ] } }, { "type": "number", "value": 0.0 } ] }, { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "filterBy": [ { "property": "transactions.store_id", "value": 102, "operator": "eq" } ] } } ] } ], "options": { "sort": "asc" } } }
filter_by_attribute_two_filters_nested_to_metric_1
filter_by_attribute_two_filters_nested_to_metric_1
{ "name": "filter_by_attribute_two_filters_nested_to_metric_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "filterBy": [ { "property": "zsj_desc.kod_zsj_d", "query": { "properties": [ { "id": "kod_zsj_d", "type": "property", "value": "zsj_desc.kod_zsj_d" }, { "id": "population_where_store_id_ne_101", "type": "function_sum", "content": [ { "type": "property", "value": "zsj_desc.population" } ], "options": { "filterBy": [ { "property": "zsj_desc.kod_zsj_d", "query": { "properties": [ { "id": "kod_zsj_d", "type": "property", "value": "zsj_desc.kod_zsj_d" }, { "id": "aux_metric", "type": "function_count", "content": [ { "type": "property", "value": "zsj_desc.kod_zsj_d" } ], "options": { "withoutFilters": [ "*.*" ], "filterBy": [ { "property": "transactions.store_id", "value": 101, "operator": "eq" } ] } } ] }, "operator": "inAttribute" } ] } } ], "having": [ { "propertyId": "population_where_store_id_ne_101", "value": 500, "operator": "gte" } ] }, "operator": "inAttribute" } ] } } }
without_1
without_1
{ "name": "without_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } }
without_2
without_2
{ "name": "without_2", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "withoutFilters": [ "transactions.store_id" ], "filterBy": [ { "property": "transactions.store_id", "value": 100, "operator": "eq" } ] } } }
without_3
without_3
{ "name": "without_3", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "withoutFilters": [ "trans*.*_id" ], "filterBy": [ { "property": "transactions.store_id", "value": 100, "operator": "eq" } ] } } }
skip_in_attribute_filter_1
skip_in_attribute_filter_1
{ "name": "skip_in_attribute_filter_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "filterBy": [ { "property": "zsj_desc.kod_zsj_d", "query": { "properties": [ { "id": "kod_zsj_d", "type": "property", "value": "zsj_desc.kod_zsj_d" } ] }, "operator": "inAttribute" } ] } } }
filter_by_attribute_1
filter_by_attribute_1
{ "name": "filter_by_attribute_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "zsj_desc.population" } ] } }
filter_by_attribute_2
filter_by_attribute_2
{ "name": "filter_by_attribute_2", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "zsj_desc.population" } ], "options": { "withoutFilters": [ "transactions.store_id" ], "filterBy": [ { "property": "zsj_desc.kod_zsj_d", "query": { "properties": [ { "id": "kod_zsj_d", "type": "property", "value": "zsj_desc.kod_zsj_d" } ] }, "operator": "inAttribute" }, { "property": "transactions.store_id", "value": 101, "operator": "ne" } ] } } }
filter_by_attribute_3
filter_by_attribute_3
{ "name": "filter_by_attribute_3", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "zsj_desc.population" } ], "options": { "withoutFilters": [ "transactions.store_id" ], "filterBy": [ { "property": "zsj_desc.kod_zsj_d", "query": { "properties": [ { "id": "kod_zsj_d", "type": "property", "value": "zsj_desc.kod_zsj_d" } ] }, "operator": "inAttribute" }, { "property": "transactions.store_id", "value": 101, "operator": "ne" }, { "property": "transactions.store_id", "value": 101, "operator": "ne" } ] } } }
filter_by_attribute_4
filter_by_attribute_4
{ "name": "filter_by_attribute_4", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "zsj_desc.population" } ], "options": { "withoutFilters": [ "transactions.store_id" ], "filterBy": [ { "property": "zsj_desc.kod_zsj_d", "query": { "properties": [ { "id": "kod_zsj_d", "type": "property", "value": "zsj_desc.kod_zsj_d" }, { "id": "transaction_sum", "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } ], "having": [ { "propertyId": "transaction_sum", "value": 70, "operator": "gt" } ] }, "operator": "inAttribute" }, { "property": "transactions.store_id", "value": 101, "operator": "ne" } ] } } }
filter_by_attribute_5
filter_by_attribute_5
{ "name": "filter_by_attribute_5", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "zsj_desc.population" } ], "options": { "withoutFilters": [ "transactions.store_id" ], "filterBy": [ { "property": "zsj_desc.kod_zsj_d", "query": { "properties": [ { "id": "kod_zsj_d", "type": "property", "value": "zsj_desc.kod_zsj_d" }, { "id": "transaction_sum", "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "withoutFilters": [ "transactions.store_id" ] } } ], "having": [ { "propertyId": "transaction_sum", "value": 70, "operator": "gt" } ] }, "operator": "inAttribute" }, { "property": "transactions.store_id", "value": 101, "operator": "ne" } ] } } }
aggr_max_sum_accept_aggregate_by_store_one_agg_1
aggr_max_sum_accept_aggregate_by_store_one_agg_1
{ "name": "aggr_max_sum_accept_aggregate_by_store_one_agg_1", "type": "metric", "content": { "type": "function_max", "content": [ { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "aggregateBy": [ "transactions.store_id" ], "acceptAggregateBy": [ "transactions" ] } } ] } }
aggr_max_sum_dont_aggregate_by_store_1
aggr_max_sum_dont_aggregate_by_store_1
{ "name": "aggr_max_sum_dont_aggregate_by_store_1", "type": "metric", "content": { "type": "function_max", "content": [ { "type": "function_divide", "content": [ { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "aggregateBy": [ "transactions.store_id" ] } }, { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "aggregateBy": [ "transactions.store_id" ], "dontAggregateBy": [ "zsj_*" ] } } ] } ] } }
filter_property_in_limit_1
filter_property_in_limit_1
{ "name": "filter_property_in_limit_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "withoutFilters": [ "zsj_desc.*" ], "filterBy": [ { "property": "transactions.store_id", "value": [ 100 ], "operator": "in" }, { "property": "transactions.store_id", "value": [ 100, 102 ], "operator": "in" }, { "property": "zsj_desc.kod_zsj_d", "value": 22222, "operator": "lte" } ] } } }
filter_property_in_limit_2
filter_property_in_limit_2
{ "name": "filter_property_in_limit_2", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "withoutFilters": [ "transactions.store_id" ], "filterBy": [ { "property": "transactions.store_id", "value": [ 100, 102 ], "operator": "in" }, { "property": "zsj_desc.kod_zsj_d", "value": 22222, "operator": "lte" } ] } } }
aggr_sum_by_customer_of_max_multiply_min_1
aggr_sum_by_customer_of_max_multiply_min_1
{ "name": "aggr_sum_by_customer_of_max_multiply_min_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "function_multiply", "content": [ { "type": "function_max", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "aggregateBy": [ "zsj_desc.kod_zsj_d" ] } }, { "type": "function_min", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "aggregateBy": [ "transactions.store_id" ] } } ] } ] } }
aggr_max_sum_accept_aggregate_by_store_two_agg_1
aggr_max_sum_accept_aggregate_by_store_two_agg_1
{ "name": "aggr_max_sum_accept_aggregate_by_store_two_agg_1", "type": "metric", "content": { "type": "function_max", "content": [ { "type": "function_plus", "content": [ { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "aggregateBy": [ "transactions.store_id" ], "acceptAggregateBy": [ "transactions" ], "filterBy": [ { "property": "zsj_desc.kod_zsj_d", "value": 11111, "operator": "eq" } ] } }, { "type": "function_min", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "aggregateBy": [ "transactions.store_id" ], "acceptAggregateBy": [ "transactions" ], "filterBy": [ { "property": "zsj_desc.kod_zsj_d", "value": 33333, "operator": "ne" } ] } } ] } ] } }
arithm_1
arithm_1
{ "name": "arithm_1", "type": "metric", "content": { "type": "function_divide", "content": [ { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] }, { "type": "number", "value": 1000.0 } ] } }
arithm_2
arithm_2
{ "name": "arithm_2", "type": "metric", "content": { "type": "function_minus", "content": [ { "type": "number", "value": 625.45 }, { "type": "function_multiply", "content": [ { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] }, { "type": "number", "value": 1.21 } ] } ] } }
arithm_3
arithm_3
{ "name": "arithm_3", "type": "metric", "content": { "type": "function_multiply", "content": [ { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] }, { "type": "number", "value": 1.21 }, { "type": "function_count", "content": [ { "type": "property", "value": "transactions.store_id" } ] } ] } }
aggr_sum_of_max_without_nested_1
aggr_sum_of_max_without_nested_1
{ "name": "aggr_sum_of_max_without_nested_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "function_max", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "aggregateBy": [ "transactions.store_id" ], "withoutFilters": [ "transactions.*" ] } } ] } }
aggr_sum_of_max_by_zsjd_1
aggr_sum_of_max_by_zsjd_1
{ "name": "aggr_sum_of_max_by_zsjd_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "function_max", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "aggregateBy": [ "zsj_desc.kod_zsj_d" ] } } ] } }
without_all_filters_1
without_all_filters_1
{ "name": "without_all_filters_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } }
without_all_filters_2
without_all_filters_2
{ "name": "without_all_filters_2", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "withoutFilters": [ "transactions.*" ], "filterBy": [ { "property": "transactions.store_id", "value": 100, "operator": "eq" }, { "property": "transactions.value", "value": 35.2, "operator": "gt" } ] } } }
filter_pushdown_2_1
filter_pushdown_2_1
{ "name": "filter_pushdown_2_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "customers.identifier" } ] } }
filter_pushdown_2_2
filter_pushdown_2_2
{ "name": "filter_pushdown_2_2", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } }
ifnull_1
ifnull_1
{ "name": "ifnull_1", "type": "metric", "content": { "type": "function_plus", "content": [ { "type": "function_ifnull", "content": [ { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "filterBy": [ { "property": "transactions.store_id", "value": 101, "operator": "eq" } ] } }, { "type": "number", "value": 0.0 } ] }, { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "filterBy": [ { "property": "transactions.store_id", "value": 102, "operator": "eq" } ] } } ] } }
row_number_store_by_transaction_count_1
row_number_store_by_transaction_count_1
{ "name": "row_number_store_by_transaction_count_1", "type": "metric", "content": { "type": "function_row_number", "content": [ { "type": "function_count", "content": [ { "type": "property", "value": "transactions.identifier" } ] } ], "options": { "sort": "desc" } } }
aggr_by_null_no_granul_1
aggr_by_null_no_granul_1
{ "name": "aggr_by_null_no_granul_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "aggregateBy": [ null ] } } }
aggr_by_null_no_granul_2
aggr_by_null_no_granul_2
{ "name": "aggr_by_null_no_granul_2", "type": "metric", "content": { "type": "function_count", "content": [ { "type": "property", "value": "transactions.identifier" } ], "options": { "aggregateBy": [ null ] } } }
aggr_by_null_no_granul_3
aggr_by_null_no_granul_3
{ "name": "aggr_by_null_no_granul_3", "type": "metric", "content": { "type": "function_count", "content": [ { "type": "property", "value": "transactions.store_id" } ], "options": { "aggregateBy": [ null ] } } }
query_no_agg_1
query_no_agg_1
{ "name": "query_no_agg_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } }
query_no_agg_2
query_no_agg_2
{ "name": "query_no_agg_2", "type": "metric", "content": { "type": "function_count", "content": [ { "type": "property", "value": "transactions.identifier" } ] } }
query_no_agg_3
query_no_agg_3
{ "name": "query_no_agg_3", "type": "metric", "content": { "type": "function_avg", "content": [ { "type": "property", "value": "transactions.value" } ] } }
query_no_agg_4
query_no_agg_4
{ "name": "query_no_agg_4", "type": "metric", "content": { "type": "function_max", "content": [ { "type": "property", "value": "transactions.value" } ] } }
query_no_agg_5
query_no_agg_5
{ "name": "query_no_agg_5", "type": "metric", "content": { "type": "function_min", "content": [ { "type": "property", "value": "transactions.value" } ] } }
query_no_agg_6
query_no_agg_6
{ "name": "query_no_agg_6", "type": "metric", "content": { "type": "function_stddev_samp", "content": [ { "type": "property", "value": "transactions.value" } ] } }
ntile_partition_by_1
ntile_partition_by_1
{ "name": "ntile_partition_by_1", "type": "metric", "content": { "type": "function_ntile", "content": [ { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } ], "options": { "sort": "desc", "buckets": 8, "partitionBy": [ "kod_zsj_d" ] } } }
ntile_partition_by_2
ntile_partition_by_2
{ "name": "ntile_partition_by_2", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } }
filter_by_boolean_or_attribute_1
filter_by_boolean_or_attribute_1
{ "name": "filter_by_boolean_or_attribute_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "zsj_desc.population" } ], "options": { "withoutFilters": [ "transactions.store_id" ], "filterBy": [ { "operator": "or", "content": [ { "property": "zsj_desc.kod_zsj_d", "query": { "properties": [ { "id": "kod_zsj_d", "type": "property", "value": "zsj_desc.kod_zsj_d" }, { "id": "transaction_sum", "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } ], "having": [ { "propertyId": "transaction_sum", "value": 72, "operator": "lte" } ] }, "operator": "inAttribute" }, { "property": "zsj_desc.kod_zsj_d", "query": { "properties": [ { "id": "kod_zsj_d", "type": "property", "value": "zsj_desc.kod_zsj_d" }, { "id": "transaction_sum", "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } ], "having": [ { "propertyId": "transaction_sum", "value": 160, "operator": "gte" } ] }, "operator": "inAttribute" } ] } ] } } }
percentile_arithm_1
percentile_arithm_1
{ "name": "percentile_arithm_1", "type": "metric", "content": { "type": "function_percentile", "content": [ { "type": "function_ifnull", "content": [ { "type": "function_divide", "content": [ { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] }, { "type": "function_count", "content": [ { "type": "property", "value": "transactions.customer_id" } ] } ] }, { "type": "number", "value": 0.0 } ] } ], "options": { "sort": "desc" } } }
percentile_arithm_2
percentile_arithm_2
{ "name": "percentile_arithm_2", "type": "metric", "content": { "type": "function_divide", "content": [ { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] }, { "type": "function_count", "content": [ { "type": "property", "value": "transactions.customer_id" } ] } ], "options": { "sort": "desc" } } }
filter_by_not_in_attribute_1
filter_by_not_in_attribute_1
{ "name": "filter_by_not_in_attribute_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "zsj_desc.population" } ], "options": { "withoutFilters": [ "transactions.store_id" ], "filterBy": [ { "property": "zsj_desc.kod_zsj_d", "query": { "properties": [ { "id": "kod_zsj_d", "type": "property", "value": "zsj_desc.kod_zsj_d" } ] }, "operator": "notInAttribute" }, { "property": "transactions.store_id", "value": 101, "operator": "eq" } ] } } }
aggr_sum_of_count_dist_by_store_1
aggr_sum_of_count_dist_by_store_1
{ "name": "aggr_sum_of_count_dist_by_store_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "function_count", "content": [ { "type": "property", "value": "zsj_desc.kod_zsj_d" } ], "options": { "aggregateBy": [ "transactions.customer_id" ] } } ] } }
filter_by_function_date_trunc_1
filter_by_function_date_trunc_1
{ "name": "filter_by_function_date_trunc_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } }
filter_by_function_interval_1
filter_by_function_interval_1
{ "name": "filter_by_function_interval_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } }
filter_by_attribute_two_filters_flat_1
filter_by_attribute_two_filters_flat_1
{ "name": "filter_by_attribute_two_filters_flat_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "filterBy": [ { "property": "zsj_desc.kod_zsj_d", "query": { "properties": [ { "id": "kod_zsj_d", "type": "property", "value": "zsj_desc.kod_zsj_d" }, { "id": "population_where_store_id_ne_101", "type": "function_sum", "content": [ { "type": "property", "value": "zsj_desc.population" } ], "options": { "withoutFilters": [ "zsjd_desc.*" ] } } ], "having": [ { "propertyId": "population_where_store_id_ne_101", "value": 500, "operator": "gte" } ] }, "operator": "inAttribute" }, { "property": "zsj_desc.kod_zsj_d", "query": { "properties": [ { "id": "kod_zsj_d", "type": "property", "value": "zsj_desc.kod_zsj_d" }, { "id": "aux_metric", "type": "function_count", "content": [ { "type": "property", "value": "zsj_desc.kod_zsj_d" } ], "options": { "withoutFilters": [ "zsjd_desc.*" ] } } ], "filterBy": [ { "property": "transactions.store_id", "value": 101, "operator": "eq" } ] }, "operator": "inAttribute" } ] } } }
sort_external_property_1
sort_external_property_1
{ "name": "sort_external_property_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } }
filter_by_boolean_and_attribute_1
filter_by_boolean_and_attribute_1
{ "name": "filter_by_boolean_and_attribute_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "zsj_desc.population" } ], "options": { "withoutFilters": [ "transactions.store_id" ], "filterBy": [ { "operator": "and", "content": [ { "property": "zsj_desc.kod_zsj_d", "query": { "properties": [ { "id": "kod_zsj_d", "type": "property", "value": "zsj_desc.kod_zsj_d" }, { "id": "transaction_sum", "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } ], "having": [ { "propertyId": "transaction_sum", "value": 120, "operator": "lte" } ] }, "operator": "inAttribute" }, { "property": "zsj_desc.kod_zsj_d", "query": { "properties": [ { "id": "kod_zsj_d", "type": "property", "value": "zsj_desc.kod_zsj_d" }, { "id": "transaction_sum", "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } ], "having": [ { "propertyId": "transaction_sum", "value": 95, "operator": "gte" } ] }, "operator": "inAttribute" } ] } ] } } }
filter_by_in_1
filter_by_in_1
{ "name": "filter_by_in_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } }
one_metric_1
one_metric_1
{ "name": "one_metric_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } }