Metrics cheatsheet

Table of Contents

query_no_agg_1
1 2 3 4 5 6 7 8 9 10 11 12 13 { "name": "query_no_agg_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } }
query_no_agg_2
1 2 3 4 5 6 7 8 9 10 11 12 13 { "name": "query_no_agg_2", "type": "metric", "content": { "type": "function_count", "content": [ { "type": "property", "value": "transactions.identifier" } ] } }

 

query_no_agg_3

1 2 3 4 5 6 7 8 9 10 11 12 13 { "name": "query_no_agg_3", "type": "metric", "content": { "type": "function_avg", "content": [ { "type": "property", "value": "transactions.value" } ] } }
query_no_agg_4
1 2 3 4 5 6 7 8 9 10 11 12 13 { "name": "query_no_agg_4", "type": "metric", "content": { "type": "function_max", "content": [ { "type": "property", "value": "transactions.value" } ] } }
query_no_agg_5
1 2 3 4 5 6 7 8 9 10 11 12 13 { "name": "query_no_agg_5", "type": "metric", "content": { "type": "function_min", "content": [ { "type": "property", "value": "transactions.value" } ] } }
query_no_agg_6
1 2 3 4 5 6 7 8 9 10 11 12 13 { "name": "query_no_agg_6", "type": "metric", "content": { "type": "function_stddev_samp", "content": [ { "type": "property", "value": "transactions.value" } ] } }
aggregate_zsjd_1
1 2 3 4 5 6 7 8 9 10 11 12 13 { "name": "aggregate_zsjd_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } }
aggregate_zsjd_2
1 2 3 4 5 6 7 8 9 10 11 12 13 { "name": "aggregate_zsjd_2", "type": "metric", "content": { "type": "function_count", "content": [ { "type": "property", "value": "transactions.store_id" } ] } }
aggregate_zsjd_3
1 2 3 4 5 6 7 8 9 10 11 12 13 { "name": "aggregate_zsjd_3", "type": "metric", "content": { "type": "function_count_dist", "content": [ { "type": "property", "value": "transactions.store_id" } ] } }
aggregate_zsjd_4
1 2 3 4 5 6 7 8 9 10 11 12 13 { "name": "aggregate_zsjd_4", "type": "metric", "content": { "type": "function_avg", "content": [ { "type": "property", "value": "transactions.value" } ] } }
aggregate_zsjd_5
1 2 3 4 5 6 7 8 9 10 11 12 13 { "name": "aggregate_zsjd_5", "type": "metric", "content": { "type": "function_max", "content": [ { "type": "property", "value": "transactions.value" } ] } }
aggregate_zsjd_6
1 2 3 4 5 6 7 8 9 10 11 12 13 { "name": "aggregate_zsjd_6", "type": "metric", "content": { "type": "function_min", "content": [ { "type": "property", "value": "transactions.value" } ] } }
aggregate_zsjd_7
1 2 3 4 5 6 7 8 9 10 11 12 13 { "name": "aggregate_zsjd_7", "type": "metric", "content": { "type": "function_stddev_samp", "content": [ { "type": "property", "value": "transactions.value" } ] } }
aggr_by_null_1
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 { "name": "aggr_by_null_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "aggregateBy": [ null ] } } }
aggr_by_null_2
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 { "name": "aggr_by_null_2", "type": "metric", "content": { "type": "function_count", "content": [ { "type": "property", "value": "transactions.identifier" } ], "options": { "aggregateBy": [ null ] } } }
aggr_by_null_3
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 { "name": "round_1", "type": "metric", "content": { "type": "function_round", "content": [ { "type": "function_avg", "content": [ { "type": "property", "value": "transactions.value" } ] } ], "options": { "places": 1 } } }
round_2
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 { "name": "round_2", "type": "metric", "content": { "type": "function_round", "content": [ { "type": "function_avg", "content": [ { "type": "property", "value": "transactions.value" } ] } ], "options": { "places": -2 } } }
round_3
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 { "name": "round_3", "type": "metric", "content": { "type": "function_avg", "content": [ { "type": "function_round", "content": [ { "type": "property", "value": "transactions.value" } ], "options": { "places": 1 } } ] } }
round_4
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 { "name": "round_property_2", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } }
round_property_count_1
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 { "name": "round_property_count_3", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } }
round_property_count_4
1 2 3 4 5 6 7 8 9 10 11 12 13 { "name": "round_property_count_4", "type": "metric", "content": { "type": "function_count", "content": [ { "type": "property", "value": "customers.identifier" } ] } }
filter_by_1
1 2 3 4 5 6 7 8 9 10 11 12 13 { "name": "filter_by_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } }
filter_by_in_1
1 2 3 4 5 6 7 8 9 10 11 12 13 { "name": "filter_by_in_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } }
filter_by_extern_property_1
1 2 3 4 5 6 7 8 9 10 11 12 13 { "name": "filter_by_extern_property_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "zsj_desc.population" } ] } }
having_just_one_zsjd_1
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 { "name": "local_filter_2", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } }
without_1
1 2 3 4 5 6 7 8 9 10 11 12 13 { "name": "without_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } }
without_2
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 { "name": "without_all_filters_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } }
without_all_filters_2
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 { "name": "without_from_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } }
without_from_2
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 { "name": "ntile_2", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } }
ntile_filter_by_1
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 { "name": "ntile_filter_by_2", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } }
ntile_partition_by_1
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 { "name": "ntile_partition_by_2", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } }
rank_1
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 { "name": "rank_1", "type": "metric", "content": { "type": "function_rank", "content": [ { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } ], "options": { "sort": "desc" } } }
rank_2
1 2 3 4 5 6 7 8 9 10 11 12 13 { "name": "rank_2", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } }
rank_partition_by_1
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 { "name": "rank_partition_by_2", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } }
rank_with_filter_1
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 { "name": "rank_with_filter_3", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } }
can_2694_1
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 { "name": "can_2751_2", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "zsj_desc.population" } ] } }
can_3062_1
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 { "name": "filter_by_attribute_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "zsj_desc.population" } ] } }
filter_by_attribute_2
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 { "name": "filter_by_boolean_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } }
filter_by_boolean_nor_1
1 2 3 4 5 6 7 8 9 10 11 12 13 { "name": "filter_by_boolean_nor_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } }
filter_by_boolean_or_and_1
1 2 3 4 5 6 7 8 9 10 11 12 13 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 { "name": "having_boolean_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } }
having_boolean_two_metrics_1
1 2 3 4 5 6 7 8 9 10 11 12 13 { "name": "having_boolean_two_metrics_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } }
having_boolean_two_metrics_2
1 2 3 4 5 6 7 8 9 10 11 12 13 { "name": "having_boolean_two_metrics_2", "type": "metric", "content": { "type": "function_count", "content": [ { "type": "property", "value": "transactions.identifier" } ] } }
filter_by_boolean_and_attribute_1
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 { "name": "percentile_1", "type": "metric", "content": { "type": "function_percentile", "content": [ { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } ], "options": { "sort": "desc" } } }
percentile_2
1 2 3 4 5 6 7 8 9 10 11 12 13 { "name": "percentile_2", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } }
percentile_arithm_1
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 { "name": "percentile_partition_by_2", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } }
percentile_same_values_1
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 { "name": "percentile_same_values_2", "type": "metric", "content": { "type": "function_count", "content": [ { "type": "property", "value": "transactions.customer_id" } ] } }
accept_filters_1
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 { "name": "filter_by_date_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } }
filter_by_not_in_attribute_1
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 { "name": "having_filter_count_by_decimal_1", "type": "metric", "content": { "type": "function_count", "content": [ { "type": "property", "value": "transactions.identifier" } ] } }
filter_by_function_1
1 2 3 4 5 6 7 8 9 10 11 12 13 { "name": "filter_by_function_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } }
filter_by_function_today_1
1 2 3 4 5 6 7 8 9 10 11 12 13 { "name": "filter_by_function_today_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } }
filter_by_function_date_trunc_1
1 2 3 4 5 6 7 8 9 10 11 12 13 { "name": "filter_by_function_date_trunc_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } }
filter_by_function_interval_1
1 2 3 4 5 6 7 8 9 10 11 12 13 { "name": "filter_by_function_interval_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } }
accept_aggr_by_1
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 { "name": "accept_aggr_by_2", "type": "metric", "content": { "type": "function_count", "content": [ { "type": "property", "value": "transactions.identifier" } ], "options": { "acceptAggregateBy": [ "zsj*" ] } } }
accept_aggr_by_3
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 { "name": "filter_pushdown_1", "type": "metric", "content": { "type": "function_max", "content": [ { "type": "property", "value": "customers.identifier" } ] } }
filter_pushdown_2
1 2 3 4 5 6 7 8 9 10 11 12 13 { "name": "filter_pushdown_2", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } }
filter_pushdown_2_1
1 2 3 4 5 6 7 8 9 10 11 12 13 { "name": "filter_pushdown_2_1", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "customers.identifier" } ] } }
filter_pushdown_2_2
1 2 3 4 5 6 7 8 9 10 11 12 13 { "name": "filter_pushdown_2_2", "type": "metric", "content": { "type": "function_sum", "content": [ { "type": "property", "value": "transactions.value" } ] } }
aggr_by_customer_1
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 { "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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 { "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