Versions Compared
compared with
Key
- This line was added.
- This line was removed.
- Formatting was changed.
Table of Contents
Table of Contents |
---|
query_no_agg_1
Code Block |
---|
{ "name": "query_no_agg_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } } |
query_no_agg_2
Code Block |
---|
{ "name": "query_no_agg_2", "type": "metric", "content": { "type": "function_count", "content": [ { "type": "property", "value": "transactions.identifier" } ] } } |
query_no_agg_3
Code Block |
---|
{ "name": "query_no_agg_3", "type": "metric", "content": { "type": "function_avg", "content": [ { "type": "property", "value": "transactions.value" } ] } } |
query_no_agg_4
Code Block |
---|
{ "name": "query_no_agg_4", "type": "metric", "content": { "type": "function_max", "content": [ { "type": "property", "value": "transactions.value" } ] } } |
query_no_agg_5
Code Block |
---|
{ "name": "query_no_agg_5", "type": "metric", "content": { "type": "function_min", "content": [ { "type": "property", "value": "transactions.value" } ] } } |
query_no_agg_6
Code Block |
---|
{ "name": "query_no_agg_6", "type": "metric", "content": { "type": "function_stddev_samp", "content": [ { "type": "property", "value": "transactions.value" } ] } } |
aggregate_zsjd_1
Code Block |
---|
{ "name": "aggregate_zsjd_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } } |
aggregate_zsjd_2
Code Block |
---|
{ "name": "aggregate_zsjd_2", "type": "metric", "content": { "type": "function_count", "content": [ { "type": "property", "value": "transactions.store_id" } ] } } |
aggregate_zsjd_3
Code Block |
---|
{ "name": "aggregate_zsjd_3", "type": "metric", "content": { "type": "function_count_dist", "content": [ { "type": "property", "value": "transactions.store_id" } ] } } |
aggregate_zsjd_4
Code Block |
---|
{ "name": "aggregate_zsjd_4", "type": "metric", "content": { "type": "function_avg", "content": [ { "type": "property", "value": "transactions.value" } ] } } |
aggregate_zsjd_5
Code Block |
---|
{ "name": "aggregate_zsjd_5", "type": "metric", "content": { "type": "function_max", "content": [ { "type": "property", "value": "transactions.value" } ] } } |
aggregate_zsjd_6
Code Block |
---|
{ "name": "aggregate_zsjd_6", "type": "metric", "content": { "type": "function_min", "content": [ { "type": "property", "value": "transactions.value" } ] } } |
aggregate_zsjd_7
Code Block |
---|
{ "name": "aggregate_zsjd_7", "type": "metric", "content": { "type": "function_stddev_samp", "content": [ { "type": "property", "value": "transactions.value" } ] } } |
aggr_by_null_1
Code Block |
---|
{ "name": "aggr_by_null_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "aggregateBy": [ null ] } } } |
aggr_by_null_2
Code Block |
---|
{ "name": "aggr_by_null_2", "type": "metric", "content": { "type": "function_count", "content": [ { "type": "property", "value": "transactions.identifier" } ], "options": { "aggregateBy": [ null ] } } } |
aggr_by_null_3
Code Block |
---|
{ "name": "aggr_by_null_3", "type": "metric", "content": { "type": "function_count", "content": [ { "type": "property", "value": "transactions.store_id" } ], "options": { "aggregateBy": [ null ] } } } |
aggr_by_null_filter_1
Code Block |
---|
{ "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 ] } } ] } } |
aggr_by_null_no_granul_1
Code Block |
---|
{ "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
Code Block |
---|
{ "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
Code Block |
---|
{ "name": "aggr_by_null_no_granul_3", "type": "metric", "content": { "type": "function_count", "content": [ { "type": "property", "value": "transactions.store_id" } ], "options": { "aggregateBy": [ null ] } } } |
arithm_1
Code Block |
---|
{ "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
Code Block |
---|
{ "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
Code Block |
---|
{ "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" } ] } ] } } |
variable_1
Code Block |
---|
{ "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
Code Block |
---|
{ "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
Code Block |
---|
{ "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" } ] } ] } } |
round_1
Code Block |
---|
{ "name": "round_1", "type": "metric", "content": { "type": "function_round", "content": [ { "type": "function_avg", "content": [ { "type": "property", "value": "transactions.value" } ] } ], "options": { "places": 1 } } } |
round_2
Code Block |
---|
{ "name": "round_2", "type": "metric", "content": { "type": "function_round", "content": [ { "type": "function_avg", "content": [ { "type": "property", "value": "transactions.value" } ] } ], "options": { "places": -2 } } } |
round_3
Code Block |
---|
{ "name": "round_3", "type": "metric", "content": { "type": "function_avg", "content": [ { "type": "function_round", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "places": 1 } } ] } } |
round_4
Code Block |
---|
{ "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
Code Block |
---|
{ "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 } ] } } |
round_property_1
Code Block |
---|
{ "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
Code Block |
---|
{ "name": "round_property_2", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } } |
round_property_count_1
Code Block |
---|
{ "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
Code Block |
---|
{ "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
Code Block |
---|
{ "name": "round_property_count_3", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } } |
round_property_count_4
Code Block |
---|
{ "name": "round_property_count_4", "type": "metric", "content": { "type": "function_count", "content": [ { "type": "property", "value": "customers.identifier" } ] } } |
filter_by_1
Code Block |
---|
{ "name": "filter_by_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } } |
filter_by_in_1
Code Block |
---|
{ "name": "filter_by_in_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } } |
filter_by_extern_property_1
Code Block |
---|
{ "name": "filter_by_extern_property_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "zsj_desc.population" } ] } } |
having_just_one_zsjd_1
Code Block |
---|
{ "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" ] } } ] } } |
having_percent_turnover_1
Code Block |
---|
{ "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
Code Block |
---|
{ "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
Code Block |
---|
{ "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 ] } } ] } } |
local_filter_1
Code Block |
---|
{ "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
Code Block |
---|
{ "name": "local_filter_2", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } } |
without_1
Code Block |
---|
{ "name": "without_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } } |
without_2
Code Block |
---|
{ "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
Code Block |
---|
{ "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" } ] } } } |
without_all_filters_1
Code Block |
---|
{ "name": "without_all_filters_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } } |
without_all_filters_2
Code Block |
---|
{ "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" } ] } } } |
without_from_1
Code Block |
---|
{ "name": "without_from_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } } |
without_from_2
Code Block |
---|
{ "name": "without_from_2", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "withoutFilters": [ "from:transactions" ], "filterBy": [ { "property": "transactions.store_id", "value": 100, "operator": "eq" } ] } } } |
without_from_3
Code Block |
---|
{ "name": "without_from_3", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "withoutFilters": [ "from:customers" ], "filterBy": [ { "property": "transactions.store_id", "value": 100, "operator": "eq" } ] } } } |
ntile_1
Code Block |
---|
{ "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
Code Block |
---|
{ "name": "ntile_2", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } } |
ntile_filter_by_1
Code Block |
---|
{ "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
Code Block |
---|
{ "name": "ntile_filter_by_2", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } } |
ntile_partition_by_1
Code Block |
---|
{ "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
Code Block |
---|
{ "name": "ntile_partition_by_2", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } } |
rank_1
Code Block |
---|
{ "name": "rank_1", "type": "metric", "content": { "type": "function_rank", "content": [ { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } ], "options": { "sort": "desc" } } } |
rank_2
Code Block |
---|
{ "name": "rank_2", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } } |
rank_partition_by_1
Code Block |
---|
{ "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
Code Block |
---|
{ "name": "rank_partition_by_2", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } } |
rank_with_filter_1
Code Block |
---|
{ "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
Code Block |
---|
{ "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
Code Block |
---|
{ "name": "rank_with_filter_3", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } } |
can_2694_1
Code Block |
---|
{ "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
Code Block |
---|
{ "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
Code Block |
---|
{ "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
Code Block |
---|
{ "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
Code Block |
---|
{ "name": "can_2751_2", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "zsj_desc.population" } ] } } |
can_3062_1
Code Block |
---|
{ "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
Code Block |
---|
{ "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
Code Block |
---|
{ "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]" } } |
filter_property_in_limit_1
Code Block |
---|
{ "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
Code Block |
---|
{ "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" } ] } } } |
rank_of_arithm_1
Code Block |
---|
{ "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
Code Block |
---|
{ "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" } ] } ] } } |
filter_by_attribute_1
Code Block |
---|
{ "name": "filter_by_attribute_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "zsj_desc.population" } ] } } |
filter_by_attribute_2
Code Block |
---|
{ "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
Code Block |
---|
{ "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
Code Block |
---|
{ "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
Code Block |
---|
{ "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" } ] } } } |
filter_by_attribute_variable_1
Code Block |
---|
{ "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" } ] } } } |
filter_by_attribute_global_1
Code Block |
---|
{ "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" } ] } } } |
filter_by_attribute_combined_1
Code Block |
---|
{ "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_attribute_nested_1
Code Block |
---|
{ "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 } ] } } |
ifnull_1
Code Block |
---|
{ "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" } ] } } ] } } |
filter_by_boolean_1
Code Block |
---|
{ "name": "filter_by_boolean_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } } |
filter_by_boolean_nor_1
Code Block |
---|
{ "name": "filter_by_boolean_nor_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } } |
filter_by_boolean_or_and_1
Code Block |
---|
{ "name": "filter_by_boolean_or_and_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } } |
filter_by_boolean_without_filters_1
Code Block |
---|
{ "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
Code Block |
---|
{ "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" } ] } ] } } } |
having_boolean_1
Code Block |
---|
{ "name": "having_boolean_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } } |
having_boolean_two_metrics_1
Code Block |
---|
{ "name": "having_boolean_two_metrics_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } } |
having_boolean_two_metrics_2
Code Block |
---|
{ "name": "having_boolean_two_metrics_2", "type": "metric", "content": { "type": "function_count", "content": [ { "type": "property", "value": "transactions.identifier" } ] } } |
filter_by_boolean_and_attribute_1
Code Block |
---|
{ "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_boolean_or_attribute_1
Code Block |
---|
{ "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_1
Code Block |
---|
{ "name": "percentile_1", "type": "metric", "content": { "type": "function_percentile", "content": [ { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } ], "options": { "sort": "desc" } } } |
percentile_2
Code Block |
---|
{ "name": "percentile_2", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } } |
percentile_arithm_1
Code Block |
---|
{ "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
Code Block |
---|
{ "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" } } } |
percentile_partition_by_1
Code Block |
---|
{ "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
Code Block |
---|
{ "name": "percentile_partition_by_2", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } } |
percentile_same_values_1
Code Block |
---|
{ "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
Code Block |
---|
{ "name": "percentile_same_values_2", "type": "metric", "content": { "type": "function_count", "content": [ { "type": "property", "value": "transactions.customer_id" } ] } } |
accept_filters_1
Code Block |
---|
{ "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
Code Block |
---|
{ "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
Code Block |
---|
{ "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" } ] } } } |
accept_without_filters_1
Code Block |
---|
{ "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
Code Block |
---|
{ "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
Code Block |
---|
{ "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" } ] } } } |
big_numbers_1
Code Block |
---|
{ "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
Code Block |
---|
{ "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
Code Block |
---|
{ "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" } } |
filter_by_date_1
Code Block |
---|
{ "name": "filter_by_date_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } } |
filter_by_not_in_attribute_1
Code Block |
---|
{ "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" } ] } } } |
having_filter_count_by_decimal_1
Code Block |
---|
{ "name": "having_filter_count_by_decimal_1", "type": "metric", "content": { "type": "function_count", "content": [ { "type": "property", "value": "transactions.identifier" } ] } } |
filter_by_function_1
Code Block |
---|
{ "name": "filter_by_function_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } } |
filter_by_function_today_1
Code Block |
---|
{ "name": "filter_by_function_today_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } } |
filter_by_function_date_trunc_1
Code Block |
---|
{ "name": "filter_by_function_date_trunc_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } } |
filter_by_function_interval_1
Code Block |
---|
{ "name": "filter_by_function_interval_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } } |
accept_aggr_by_1
Code Block |
---|
{ "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
Code Block |
---|
{ "name": "accept_aggr_by_2", "type": "metric", "content": { "type": "function_count", "content": [ { "type": "property", "value": "transactions.identifier" } ], "options": { "acceptAggregateBy": [ "zsj*" ] } } } |
accept_aggr_by_3
Code Block |
---|
{ "name": "accept_aggr_by_3", "type": "metric", "content": { "type": "function_count", "content": [ { "type": "property", "value": "transactions.store_id" } ], "options": { "dontAggregateBy": [ "customers" ] } } } |
accept_aggr_by_null_1
Code Block |
---|
{ "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
Code Block |
---|
{ "name": "accept_aggr_by_null_2", "type": "metric", "content": { "type": "function_count", "content": [ { "type": "property", "value": "transactions.identifier" } ], "options": { "acceptAggregateBy": [ null ] } } } |
filter_by_attribute_two_filters_nested_1
Code Block |
---|
{ "name": "filter_by_attribute_two_filters_nested_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } } |
filter_by_attribute_two_filters_nested_filters_1
Code Block |
---|
{ "name": "filter_by_attribute_two_filters_nested_filters_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } } |
filter_by_attribute_two_filters_nested_to_metric_1
Code Block |
---|
{ "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" } ] } } } |
filter_by_attribute_two_filters_one_skippable_1
Code Block |
---|
{ "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_attribute_two_filters_flat_1
Code Block |
---|
{ "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" } ] } } } |
skip_in_attribute_filter_1
Code Block |
---|
{ "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" } ] } } } |
row_number_zsjd_store_by_revenue_1
Code Block |
---|
{ "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" } } } |
row_number_zsjd_store_avg_transaction_1
Code Block |
---|
{ "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" } } } |
row_number_store_by_transaction_count_1
Code Block |
---|
{ "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" } } } |
can_7610_1
Code Block |
---|
{ "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
Code Block |
---|
{ "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" } ] } ] } } |
filter_by_attribute_combined_1
Code Block |
---|
{ "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_attribute_combined_cache_1
Code Block |
---|
{ "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_pushdown_1
Code Block |
---|
{ "name": "filter_pushdown_1", "type": "metric", "content": { "type": "function_max", "content": [ { "type": "property", "value": "customers.identifier" } ] } } |
filter_pushdown_2
Code Block |
---|
{ "name": "filter_pushdown_2", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } } |
filter_pushdown_2_1
Code Block |
---|
{ "name": "filter_pushdown_2_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "customers.identifier" } ] } } |
filter_pushdown_2_2
Code Block |
---|
{ "name": "filter_pushdown_2_2", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } } |
aggr_by_customer_1
Code Block |
---|
{ "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
Code Block |
---|
{ "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
Code Block |
---|
{ "name": "aggr_by_customer_3", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "aggregateBy": [ null ] } } } |
aggr_sum_of_max_by_store_1
Code Block |
---|
{ "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" ] } } ] } } |
aggr_sum_of_max_by_store_customer_1
Code Block |
---|
{ "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" ] } } ] } } |
aggr_sum_of_max_by_store_filter_1
Code Block |
---|
{ "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" } ] } } ] } } |
aggr_sum_by_store_of_max_by_customer_1
Code Block |
---|
{ "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" ] } } ] } } |
aggr_sum_of_max_by_zsjd_1
Code Block |
---|
{ "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" ] } } ] } } |
aggr_sum_of_max_multiply_number_1
Code Block |
---|
{ "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" ] } } ] } ] } } |
aggr_sum_of_max_multiply_min_1
Code Block |
---|
{ "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" ] } } ] } ] } } |
aggr_sum_by_customer_of_max_multiply_min_1
Code Block |
---|
{ "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_sum_of_max_plus_min_1
Code Block |
---|
{ "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" } ] } ] } } |
aggr_sum_by_zsjd_of_max_plus_min_1
Code Block |
---|
{ "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" } ] } ] } } |
aggr_sum_of_max_without_nested_1
Code Block |
---|
{ "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_accept_aggr_by_1
Code Block |
---|
{ "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" ] } } ] } } |
filter_by_attribute_sum_of_max_1
Code Block |
---|
{ "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" } ] } } } |
aggr_max_by_zsjd_of_sum_by_store_1
Code Block |
---|
{ "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" ] } } ] } ] } } |
aggr_sum_of_count_by_store_1
Code Block |
---|
{ "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" ] } } ] } } |
aggr_sum_of_count_dist_by_store_1
Code Block |
---|
{ "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" ] } } ] } } |
aggr_count_by_customer_1
Code Block |
---|
{ "name": "aggr_count_by_customer_1", "type": "metric", "content": { "type": "function_count", "content": [ { "type": "property", "value": "transactions.identifier" } ], "options": { "aggregateBy": [ "transactions.customer_id" ] } } } |
aggr_count_dist_by_customer_1
Code Block |
---|
{ "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" ] } } } |
can_8477_1
Code Block |
---|
{ "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_by_store_1
Code Block |
---|
{ "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_max_sum_dont_aggregate_by_store_1
Code Block |
---|
{ "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_*" ] } } ] } ] } } |
aggr_max_sum_accept_aggregate_all_1
Code Block |
---|
{ "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": [ "*" ] } } ] } ] } } |
aggr_max_by_store_by_client_1
Code Block |
---|
{ "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" } ] } } ] } ] } } |
aggr_max_sum_accept_aggregate_by_store_one_agg_1
Code Block |
---|
{ "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_accept_aggregate_by_store_two_agg_1
Code Block |
---|
{ "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" } ] } } ] } ] } } |
can_8366_1
Code Block |
---|
{ "name": "can_8366_1", "type": "metric", "content": { "type": "function_max", "content": [ { "type": "property", "value": "customers.identifier" } ] } } |
can_8366_2
Code Block |
---|
{ "name": "can_8366_2", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } } |
one_metric_1
Code Block |
---|
{ "name": "one_metric_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } } |
one_metric_two_attrs_1
Code Block |
---|
{ "name": "one_metric_two_attrs_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } } |
one_metric_two_primary_keys_1
Code Block |
---|
{ "name": "one_metric_two_primary_keys_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } } |
filter_by_metric_1
Code Block |
---|
{ "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" } ] } } } |
filter_by_metric_inherit_granularities_1
Code Block |
---|
{ "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_metric_inherit_granularities_dont_1
Code Block |
---|
{ "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" } ] } } } |
h3_grid_1
Code Block |
---|
{ "name": "h3_grid_1", "type": "metric", "content": { "type": "function_h3_grid", "options": { "dataset": "customers", "resolution": 13 }, "content": [ { "type": "property", "value": "customers.lng" }, { "type": "property", "value": "customers.lat" } ] } } |
h3_grid_2
Code Block |
---|
{ "name": "h3_grid_2", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } } |
h3_grid_resultset_1
Code Block |
---|
{ "name": "h3_grid_resultset_1", "type": "metric", "content": { "type": "function_h3_grid", "options": { "dataset": "customers", "resolution": 13 }, "content": [ { "type": "property", "value": "customers.lng" }, { "type": "property", "value": "customers.lat" } ] } } |
h3_grid_resultset_2
Code Block |
---|
{ "name": "h3_grid_resultset_2", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } } |
filter_by_function_h3_grid_1
Code Block |
---|
{ "name": "filter_by_function_h3_grid_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } } |
filter_by_function_h3_grid_eq_1
Code Block |
---|
{ "name": "filter_by_function_h3_grid_eq_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } } |
filter_by_attribute_h3_grid_1
Code Block |
---|
{ "name": "filter_by_attribute_h3_grid_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } } |
filter_by_attribute_h3_grid_two_resolutions_1
Code Block |
---|
{ "name": "filter_by_attribute_h3_grid_two_resolutions_1", "type": "metric", "content": { "type": "function_h3_grid", "options": { "dataset": "customers", "resolution": 13, "filterBy": [ { "function": { "type": "function_h3_grid", "options": { "dataset": "customers", "resolution": 7 }, "content": [ { "type": "property", "value": "customers.lng" }, { "type": "property", "value": "customers.lat" } ] }, "query": { "properties": [ { "id": "h3_grid", "type": "function_h3_grid", "options": { "dataset": "customers", "resolution": 7 }, "content": [ { "type": "property", "value": "customers.lng" }, { "type": "property", "value": "customers.lat" } ] }, { "id": "customers_turnover", "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } ], "having": [ { "propertyId": "customers_turnover", "value": 200, "operator": "gte" } ] }, "operator": "inAttribute" } ] }, "content": [ { "type": "property", "value": "customers.lng" }, { "type": "property", "value": "customers.lat" } ] } } |
filter_by_attribute_h3_grid_two_resolutions_2
Code Block |
---|
{ "name": "filter_by_attribute_h3_grid_two_resolutions_2", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } } |
filter_by_attribute_order_1_1
Code Block |
---|
{ "name": "filter_by_attribute_order_1_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "withoutFilters": [ "transactions.store_id" ], "filterBy": [ { "property": "transactions.store_id", "value": 101, "operator": "eq" }, { "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": 15, "operator": "gte" } ] }, "operator": "inAttribute" } ] } } } |
filter_by_attribute_order_2_1
Code Block |
---|
{ "name": "filter_by_attribute_order_2_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } } |
filter_by_attribute_order_inject_inAttribute_1
Code Block |
---|
{ "name": "filter_by_attribute_order_inject_inAttribute_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } } |
filter_by_attribute_order_nested_inAttributes_1
Code Block |
---|
{ "name": "filter_by_attribute_order_nested_inAttributes_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "filterBy": [ { "property": "transactions.store_id", "query": { "properties": [ { "id": "store_id", "type": "property", "value": "transactions.store_id" }, { "id": "store_value", "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } ], "having": [ { "propertyId": "store_value", "value": 111, "operator": "lte" } ] }, "operator": "inAttribute" }, { "property": "customers.identifier", "query": { "properties": [ { "id": "customer", "type": "property", "value": "customers.identifier" }, { "id": "customer_value", "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } ], "having": [ { "propertyId": "customer_value", "value": 71.1, "operator": "gt" } ] }, "operator": "inAttribute" } ] } } } |
filter_by_attribute_order_two_inAttributes_1
Code Block |
---|
{ "name": "filter_by_attribute_order_two_inAttributes_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": 42.7, "operator": "gte" } ] }, "operator": "inAttribute" }, { "property": "transactions.store_id", "value": 101, "operator": "eq" }, { "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": 15, "operator": "gte" } ] }, "operator": "inAttribute" } ] } } } |
percent_of_total_1
Code Block |
---|
{ "name": "percent_of_total_1", "type": "metric", "content": { "type": "function_percent_to_total", "content": [ { "type": "function_count", "content": [ { "type": "property", "value": "transactions.customer_id" } ] } ] } } |
percent_of_total_nested_aggr_1
Code Block |
---|
{ "name": "percent_of_total_nested_aggr_1", "type": "metric", "content": { "type": "function_percent_to_total", "content": [ { "type": "function_multiply", "content": [ { "type": "function_count", "content": [ { "type": "property", "value": "transactions.customer_id" } ] }, { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } ] } ] } } |
sort_1
Code Block |
---|
{ "name": "sort_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } } |
sort_null_1
Code Block |
---|
{ "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
Code Block |
---|
{ "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
Code Block |
---|
{ "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" } } } |
sort_null_asc_1
Code Block |
---|
{ "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
Code Block |
---|
{ "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
Code Block |
---|
{ "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" } } } |
sort_null_inverse_1
Code Block |
---|
{ "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
Code Block |
---|
{ "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
Code Block |
---|
{ "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" } } } |
sort_external_property_1
Code Block |
---|
{ "name": "sort_external_property_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } } |
sort_combined_1
Code Block |
---|
{ "name": "sort_combined_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } } |
sort_asc_nulls_last_1
Code Block |
---|
{ "name": "sort_asc_nulls_last_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_asc_nulls_last_2
Code Block |
---|
{ "name": "sort_asc_nulls_last_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_asc_nulls_last_3
Code Block |
---|
{ "name": "sort_asc_nulls_last_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" } } } |
sort_asc_nulls_first_1
Code Block |
---|
{ "name": "sort_asc_nulls_first_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_asc_nulls_first_2
Code Block |
---|
{ "name": "sort_asc_nulls_first_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_asc_nulls_first_3
Code Block |
---|
{ "name": "sort_asc_nulls_first_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" } } } |
expand_metric_1
Code Block |
---|
{ "name": "expand_metric_1", "type": "metric", "content": { "type": "function_divide", "content": [ { "type": "metric", "metric": "/rest/projects/test_query_service/md/metrics?name=turnover_metric" }, { "type": "number", "value": 1000.0 } ] } } |
expand_inattribute_metric_1
Code Block |
---|
{ "name": "expand_inattribute_metric_1", "type": "metric", "content": { "type": "function_divide", "content": [ { "type": "metric", "metric": "/rest/projects/test_query_service/md/metrics?name=turnover_metric" }, { "type": "number", "value": 1000.0 } ] } } |