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