Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Table of Contents

...

query_

...

no_agg_1
Code Block
titleaggrquery_maxno_by_zsjd_of_sum_by_store_agg_1
{
    "name": "aggrquery_max_by_zsjd_of_sum_by_storeno_agg_1",
    "type": "metric",
    "content": {
        "type": "function_dividesum",
        "content": [
            {
                "type": "function_maxproperty",
                "contentvalue": ["transactions.value"
            }
       { ]
    }
}
query_no_agg_2
Code Block
titlequery_no_agg_2
{
    "name": "query_no_agg_2",
          "type": "function_summetric",
    "content": {
        "type": "function_count",
        "content": [
            {
               {        "type": "property",
                        "type"value": "propertytransactions.identifier",
            }
        ]
    }
}
query_no_agg_3
Code Block
titlequery_no_agg_3
{
    "valuename": "transactions.value"query_no_agg_3",
    "type": "metric",
    "content": {
        "type": "function_avg",
       } "content": [
            {
         ],       "type": "property",
                "optionsvalue": {"transactions.value"
            }
        ]
    }
 "aggregateBy": [}
query_no_agg_4
Code Block
titlequery_no_agg_4
{
    "name": "query_no_agg_4",
    "type": "metric",
    "content": {
               "transactions.store_id""type": "function_max",
        "content": [
            {
     ]           "type": "property",
            }    "value": "transactions.value"
               }
      
         ]
    }
}
query_no_agg_5
Code Block
titlequery_no_agg_5
{
     }"name": "query_no_agg_5",
    "type": "metric",
    "content":  {
 
              "type": "function_summin",
    
           "content": [
    
               {
       
                "type": "function_minproperty",
                        "content"value": ["transactions.value"
            }
        ]
    }
}
query_no_agg_6
Code Block
titlequery_no_agg_6
{
    "name": "query_no_agg_6",
    "type": "metric",
        "content": {
           "type": "propertyfunction_stddev_samp",
        "content": [
            {
         "value": "zsj_desc.population"      "type": "property",
                "value": "transactions.value"
   }               }
         ],
    }
}
aggregate_zsjd_1
Code Block
titleaggregate_zsjd_1
{
    "name": "aggregate_zsjd_1",
      "type": "metric",
    "optionscontent": {
           "type": "function_sum",
                "aggregateBy"content": [
            {
                "type":   "zsj_desc.kod_zsj_d""property",
                  "value": "transactions.value"
         ]   }
        ]
    }
       }
                    }
                ]
            }
        ]
    }
}
one_metric_two_primary_keys_1
}
aggregate_zsjd_2
Code Block
titleoneaggregate_metric_two_primary_keys_1zsjd_2
{
    "name": "oneaggregate_metric_two_primary_keys_1zsjd_2",
    "type": "metric",
    "content": {
        "type": "function_sumcount",
        "content": [
            {
                "type": "property",
                "value": "transactions.valuestore_id"
            }
        ]
    }
}

...

aggregate_

...

zsjd_3
Code Block
titlefilteraggregate_by_boolean_or_and_1zsjd_3
{
    "name": "filteraggregate_by_boolean_or_and_1zsjd_3",
    "type": "metric",
    "content": {
        "type": "function_sumcount_dist",
        "content": [
            {
                "type": "property",
                "value": "transactions.valuestore_id"
            }
        ]
    }
}

...

aggregate_

...

zsjd_

...

4
Code Block
titleacceptaggregate_aggrzsjd_by_14
{
    "name": "acceptaggregate_aggrzsjd_by_14",
    "type": "metric",
    "content": {
        "type": "function_sumavg",
        "content": [
            {
                "type": "property",
                "value": "transactions.value"
            }
        ]
    }
}
aggregate_zsjd_5
Code Block
titleaggregate_zsjd_5
{
    "name": "aggregate_zsjd_5",
    "type": "metric",
    "optionscontent": {
        "type": "function_max",
  "acceptAggregateBy      "content": [
            {
   "zsj_desc"             "type": "property",
            ]    "value": "transactions.value"
            }
        ]
    }
}

...

aggregate_

...

zsjd_

...

6
Code Block
titleacceptaggregate_aggrzsjd_by_26
{
    "name": "acceptaggregate_aggrzsjd_by_26",
    "type": "metric",
    "content": {
        "type": "function_countmin",
        "content": [
            {
                "type": "property",
                "value": "transactions.identifiervalue"
            }
        ],
    }
   "options}
aggregate_zsjd_7
Code Block
titleaggregate_zsjd_7
{
    "name": "aggregate_zsjd_7",
    "type": "metric",
    "content": {
        "type": "function_stddev_samp",
        "acceptAggregateBycontent": [
            {
                "zsj*""type": "property",
                ]"value": "transactions.value"
            }
        ]
    }
}

...

aggr_by_null_

...

1
Code Block
titleaccept_aggr_by_3null_1
{
    "name": "accept_aggr_by_null_31",
    "type": "metric",
    "content": {
        "type": "function_countsum",
        "content": [
            {
                "type": "property",
                "value": "transactions.store_idvalue"
            }
        ],
        "options": {
            "dontAggregateByaggregateBy": [
                "customers"null
            ]
        }
    }
}

...

aggr_by_

...

null_

...

2
Code Block
titlefilteraggr_by_attributenull_global_12
{
    "name": "filteraggr_by_attributenull_global_12",
    "type": "metric",
    "content": {
        "type": "function_sumcount",
        "content": [
            {
                "type": "property",
                "value": "zsj_desctransactions.populationidentifier"
            }
        ],
        "options": {
            "withoutFiltersaggregateBy": [
                "transactions.store_id"null
            ],
        }
   "filterBy": [}
}
aggr_by_null_3
Code Block
titleaggr_by_null_3
{
    "name": "aggr_by_null_3",
    "type": "metric",
  {  "content": {
                 "property"type": "transactions.storefunction_idcount",
        "content": [
          "value": 101, {
                   "operatortype": "neproperty",
                },
"value": "transactions.store_id"
            }
  {      ],
              "property"options": "zsj_desc.kod_zsj_d",{
            "aggregateBy": [
      "query": {         null
            ]
  "properties": [     }
    }
}
aggr_by_null_filter_1
Code Block
titleaggr_by_null_filter_1
{
    "name": "aggr_by_null_filter_1",
    "type": "metric",
    "content": {
        "type": "function_divide",
        "content": [
            {
"id": "kod_zsj_d",               "type": "function_count",
                "typecontent": "property",[
                    {
           "value": "zsj_desc.kod_zsj_d"            "type": "property",
               },         "value": "transactions.customer_id"
                  {  }
                ]
             "id": "transaction_sum"},
            {
                   "type": "function_multiplycount",
                "content": [
              "content": [     {
                        "type": "property",
     {                   "value": "transactions.customer_id"
                    "type": "function_sum",}
                       ],
                 "contentoptions": [{
                    "aggregateBy": [
                      {  null
                    ]
                }
        "type": "property",   }
        ]
    }
}
aggr_by_null_no_granul_1
Code Block
titleaggr_by_null_no_granul_1
{
    "name": "aggr_by_null_no_granul_1",
    "type": "metric",
    "content": {
           "valuetype": "transactions.value"function_sum",
        "content": [
            {
                "type": "property",
   }             "value": "transactions.value"
            }
             ],
        "options": {
            "aggregateBy": [
            },    null
            ]
        }
    }
     }
aggr_by_null_no_granul_2
Code Block
titleaggr_by_null_no_granul_2
{
    "name": "aggr_by_null_no_granul_2",
    "type": "metric",
                   "content": {
        "type": "variablefunction_count",
        "content": [
             {
                "valuetype": "number_100property",
                "value": "transactions.identifier"
            }
     }   ],
        "options": {
            "aggregateBy": [
     ]           null
            ]
    }    }
    }
}
aggr_by_null_no_granul_3
Code Block
titleaggr_by_null_no_granul_3
{
    "name": "aggr_by_null_no_granul_3",
       ]"type": "metric",
    "content": {
        "type": "function_count",
        "havingcontent": [
             {
              {  "type": "property",
                             "propertyId"value": "transactiontransactions.store_sumid",
            }
          ],
        "valueoptions": 700,{
            "aggregateBy": [
                null
 "operator": "gt"          ]
        }
    }
}
arithm_1
Code Block
titlearithm_1
{
  }  "name": "arithm_1",
    "type": "metric",
    "content": {
         ]"type": "function_divide",
        "content": [
          },  {
                  "operatortype": "inAttributefunction_sum",
                }
 "content": [
          ]         }     }
}
sort_null_1
Code Block
titlesort_null_1
{
 
  "name": "sort_null_1",     "type": "metric",     "content": {         "type": "function_plusproperty",
        "content": [                {
"value": "transactions.value"
               "type": "function_ifnull",    }
            "content": [   ]
            },
    {        {
                "type": "function_sumnumber",
                        "content"value": [1000.0
            }
        ]
    }
}
arithm_2
Code Block
titlearithm_2
{
    "name": "arithm_2",
    "type": "metric",
    "content": {
              "type": "propertyfunction_minus",
        "content": [
            {
                "valuetype": "transactions.valuenumber",
                "value": 625.45
          }  },
            {
         ],       "type": "function_multiply",
                "optionscontent": {[
                    {
       "filterBy": [                "type": "function_sum",
               {         "content": [
                          "property": "transactions.store_id",
   {
                                 "valuetype": 101,
   "property",
                                "operatorvalue": "eqtransactions.value"
                                }

                           ]
                        }
                    },
                    {
                        "type": "number",
                        "value": 01.021
                    }
                ]
            },
        ]
   { }
}
arithm_3
Code Block
titlearithm_3
{
      "name": "arithm_3",
    "type": "metric",
    "content": {
        "type": "function_multiply",
        "content": [
            {
                "type": "function_sum",
                "content": [
                    {
                        "type": "property",
                        "value": "transactions.value"
                    }
                ],
            },
       "options": {    {
                "filterBytype": ["number",
                "value": 1.21
       {     },
            {
                "propertytype": "transactions.storefunction_idcount",
                "content": [
               "value": 102,    {
                        "operatortype": "eqproperty",
                        }"value": "transactions.store_id"
                    ]}
                }]
            }
        ]
    }
}

...

variable_

...

1
Code Block
titlesortvariable_null_21
{
    "name": "sortvariable_null_21",
    "type": "metric",
    "content": {
        "type": "function_percentiledivide",
        "content": [
            {
                "type": "function_plussum",
                "content": [
                    {
                        "type": "function_ifnullproperty",
                        "contentvalue": ["transactions.value"
                    }
       {         ]
                       "type": "function_sum"},
            {
                   "contenttype": ["variable",
                "value": "number_1000"
            }
     {   ]
    }
}
variable_2
Code Block
titlevariable_2
{
    "name": "variable_2",
    "type": "metric",
        "content": {
         "type": "propertyfunction_minus",
        "content": [
            {
                 "valuetype": "transactions.valuevariable",
                "value": "number_625"
            },
     }       {
                "type": "function_multiply",
       ],          "content": [
                     "options": {
                                    "filterBy": ["type": "function_sum",
                        "content": [
                {            {
                                "propertytype": "transactions.store_idproperty",
         
                                  "value": 101,"transactions.value"
                            }
               "operator": "eq"                   ]
                     },
                    {
               ]         "type": "variable",
                      }      "value": "number_121"
                      },
                ]
           { }
        ]
    }
}
variable_3
Code Block
titlevariable_3
{
    "name": "variable_3",
         "type": "numbermetric",
    "content": {
          "type": "function_multiply",
               "value"content": 0.0[
            {
               } "type": "function_sum",
                "content": [
    ]                {
    },                     {"type": "property",
                        "typevalue": "function_sum",transactions.value"
                        "content": [}
                ]
            {},
            {
                   "type": "propertyvariable",

                               "value": "transactions.valuenumber_121"
            },
            {
  }              "type": "function_count",
         ],       "content": [
                "options": {   {
                         "filterBytype": ["property",
                        "value": "transactions.store_id"
      {              }
                ]
     "property": "transactions.store_id",       }
        ]
    }
}
round_1
Code Block
titleround_1
{
    "name": "round_1",
    "type": "metric",
   "value "content": {
        "type": 102"function_round",
        "content": [
            {
                "operatortype": "eqfunction_avg",
                "content": [
              }      {
                        ]"type": "property",
                         }"value": "transactions.value"
                    }
                ]
            }
        ],
        "options": {
            "sortplaces": "desc"1
        }
    }
}

...

round_

...

2
Code Block
titlesortround_null_32
{
    "name": "sortround_null_32",
    "type": "metric",
    "content": {
        "type": "function_rankround",
        "content": [
            {
                "type": "function_plusavg",
                "content": [
                    {
                        "type": "function_ifnullproperty",
                        "contentvalue": [ "transactions.value"
                    }
              {  ]
            }
        ],
        "typeoptions": "function_sum",{
            "places": -2
        }
    }
}
round_3
Code Block
titleround_3
{
    "contentname": ["round_3",
    "type": "metric",
    "content": {
        "type": "function_avg",
        "content": [
      {      {
                "type": "function_round",
                "typecontent": "property", [
                    {
                        "valuetype": "transactions.valueproperty",
                        "value": "transactions.value"
          }          }
                ],
     ],           "options": {
                    "optionsplaces": {1
                }
            }
      "filterBy": [ ]
    }
}
round_4
Code Block
titleround_4
{
    "name": "round_4",
    "type": "metric",
    "content": {
        "type": "function_round",
    {    "content": [
            {
                   "type": "function_divide",
                "propertycontent": "transactions.store_id",[
                    {
                        "valuetype": 101"function_sum",
                            "content": [
               "operator": "eq"            {
                            }    "type": "property",
                               ] "value": "transactions.value"
                            }
 }                       ]
     },               },
             {       {
                         "type": "number",
      
                         "value": 01000.0
       
                    }
                ]
       ]     }
        ],
      },  "options": {
            "places": 1
   {     }
    }
}
round_5
Code Block
titleround_5
{
      "name": "round_5",
     "type": "function_summetric",
    "content": {
        "type": "function_divide",
        "content": [
            {
               { "type": "function_round",
                "content": [
            "type": "property",        {
                        "valuetype": "transactions.value"function_sum",
                        "content": [
  }                         ], {
                       "options": {        "type": "property",
                   "filterBy": [            "value": "transactions.value"
                   {         }
                        ]
  "property": "transactions.store_id",                 }
                ],
  "value": 102,             "options": {
                      "operatorplaces": "eq"1
                }
            },
  }          {
                "type": "number",
]                "value": 1000.0
       }     }
        ]
    }
 }
round_property_1
Code Block
titleround_property_1
{
    "name": "round_property_1",
    "type": "metric",
   ] "content": {
          }
        ]"type": "function_round",
        "optionscontent": {[
            "sort": "desc"{
         }
    } }
permission_aggregate_zsjd_1
Code Block
titlepermission_aggregate_zsjd_1
{     "nametype": "permission_aggregate_zsjd_1function_divide",
    "type": "metric",            "content": {
[
       "type": "function_sum",         "content": [   {
         {                 "type": "property",
                        "value": "transactions.value"
                    },
             ]     } } 
permission_aggregate_zsjd_2
Code Block
titlepermission_aggregate_zsjd_2
{
    "name": "permission_aggregate_zsjd_2",                    "type": "metricnumber",
     "content": {                   "value": 1000.0
         "type": "function_count",         "content": [}
            {    ]
            "type": "property",}
        ],
        "valueoptions": "transactions.store_id"{
            "places": }1
        ]}
    }
}

...

round_

...

property_

...

2
Code Block
titlepermissionround_aggregateproperty_zsjd_32
{
    "name": "permissionround_aggregateproperty_zsjd_32",
    "type": "metric",
    "content": {
        "type": "function_count_distsum",
        "content": [
            {
                "type": "property",
                "value": "transactions.store_idvalue"
            }
        ]
    }
}

...

round_

...

property_

...

count_

...

1
Code Block
titlepermissionround_aggregateproperty_zsjdcount_41
{
    "name": "permissionround_aggregateproperty_zsjdcount_41",
    "type": "metric",
    "content": {
        "type": "function_avground",
        "content": [
            {
                "type": "property",
                "value": "transactionscustomers.valuelat"
            }
        ],
      }
}
permission_aggregate_zsjd_5
Code Block
titlepermission_aggregate_zsjd_5
{  "options": {
            "nameplaces": "permission_aggregate_zsjd_5"1,
    "type": "metric",        "filterBy": [
               "content": {
        "type            "property": "function_maxtransactions.value",
           "content": [        "value": 10,
   {                 "typeoperator": "propertygte",
                "value": "transactions.value"}
            ]
}        }
]     }
}

...

round_

...

property_

...

count_

...

2
Code Block
titlepermissionround_aggregateproperty_zsjdcount_62
{
    "name": "permissionround_aggregateproperty_zsjdcount_62",
    "type": "metric",
    "content": {
        "type": "function_minround",
        "content": [
            {
                "type": "property",
                "value": "transactionscustomers.valuelng"
            }
        ],
    }
}
permission_aggregate_zsjd_7
Code Block
titlepermission_aggregate_zsjd_7
{    "options": {
            "nameplaces": "permission_aggregate_zsjd_7"1,
    "type": "metric",        "filterBy": [
               "content": {
         "type           "property": "function_stddev_samptransactions.value",
           "content": [        "value": 10,
   {                 "typeoperator": "propertygte",
                "value": "transactions.value"}
             }]
        ]}
    }
}

...

round_

...

property_

...

count_3
Code Block
titleaggrround_sumproperty_of_max_multiply_number_1count_3
{
    "name": "aggrround_sumproperty_of_max_multiply_number_1count_3",
    "type": "metric",
    "content": {
        "type": "function_sum",
        "content": [
            {
                "type": "function_multiplyproperty",
                "contentvalue": ["transactions.value"
            }
       { ]
                       "type": "number",
                        "value": 1000.0
                    },
                    {
                        "type": "function_max",
                        "content": [
                            {
                                "type": "property",
                                "value": "transactions.value"
                            }
                        ],
                        "options": {
                            "aggregateBy": [
                                "transactions.store_id"
                            ]
                        }
                    }
                ]
            }
        ]
    }
}
filter_by_function_1
Code Block
titlefilter_by_function_1
{
    "name": "filter_by_function_1",
    "type": "metric",
    "content": {
        "type": "function_sum",
        "content": [
            {
                "type": "property",
                "value": "transactions.value"
            }
        ]
    }
}
filter_by_attribute_nested_1
Code Block
titlefilter_by_attribute_nested_1
{
    "name": "filter_by_attribute_nested_1",
    "type": "metric",
    "content": {
        "type": "function_multiply",
        "content": [
            {
                "type": "function_sum",
                "content": [
                    {
                        "type": "property",
                        "value": "transactions.value"
                    }
                ],
                "options": {
                    "withoutFilters": [
                        "transactions.store_id"
                    ],
                    "filterBy": [
                        {
                            "property": "zsj_desc.kod_zsj_d",
                            "query": {
                                "properties": [
                                    {
                                        "id": "kod_zsj_d",
                                        "type": "property",
                                        "value": "zsj_desc.kod_zsj_d"
                                    }
                                ]
                            },
                            "operator": "inAttribute"
                        },
                        {
                            "property": "transactions.value",
                            "value": 50,
                            "operator": "gte"
                        }
                    ]
                }
            },
            {
                "id": "nested_in_attribute",
                "type": "number",
                "value": 13.0
            }
        ]
    }
}
aggr_sum_of_max_accept_aggr_by_1
Code Block
titleaggr_sum_of_max_accept_aggr_by_1
{
    "name": "aggr_sum_of_max_accept_aggr_by_1",
    "type": "metric",
    "content": {
        "type": "function_sum",
        "content": [
            {
                "type": "function_max",
                "content": [
                    {
                        "type": "property",
                        "value": "transactions.value"
                    }
                ],
                "options": {
                    "aggregateBy": [
                        "transactions.store_id"
                    ],
                    "acceptAggregateBy": [
                        "transactions"
                    ]
                }
            }
        ]
    }
}
aggr_sum_of_max_by_store_customer_1
Code Block
titleaggr_sum_of_max_by_store_customer_1
{
    "name": "aggr_sum_of_max_by_store_customer_1",
    "type": "metric",
    "content": {
        "type": "function_sum",
        "content": [
            {
                "type": "function_max",
                "content": [
                    {
                        "type": "property",
                        "value": "transactions.value"
                    }
                ],
                "options": {
                    "aggregateBy": [
                        "transactions.store_id",
                        "transactions.customer_id"
                    ]
                }
            }
        ]
    }
}
one_metric_two_attrs_1
Code Block
titleone_metric_two_attrs_1
{
    "name": "one_metric_two_attrs_1",
    "type": "metric",
    "content": {
        "type": "function_sum",
        "content": [
            {
                "type": "property",
                "value": "transactions.value"
            }
        ]
    }
}
rank_of_arithm_1
Code Block
titlerank_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
Code Block
titlerank_of_arithm_2
{
    "name": "rank_of_arithm_2",
    "type": "metric",
    "content": {
        "type": "function_divide",
        "content": [
            {
                "type": "function_sum",
                "content": [
                    {
                        "type": "property",
                        "value": "transactions.value"
                    }
                ]
            },
            {
                "type": "function_count",
                "content": [
                    {
                        "type": "property",
                        "value": "transactions.identifier"
                    }
                ]
            }
        ]
    }
}
percentile_1
Code Block
titlepercentile_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
Code Block
titlepercentile_2
{
    "name": "percentile_2",
    "type": "metric",
    "content": {
        "type": "function_sum",
        "content": [
            {
                "type": "property",
                "value": "transactions.value"
            }
        ]
    }
}
filter_by_date_1
Code Block
titlefilter_by_date_1
{
    "name": "filter_by_date_1",
    "type": "metric",
    "content": {
        "type": "function_sum",
        "content": [
            {
                "type": "property",
                "value": "transactions.value"
            }
        ]
    }
}
aggr_by_null_filter_1
Code Block
titleaggr_by_null_filter_1
{
    "name": "aggr_by_null_filter_1",
    "type": "metric",
    "content": {
        "type": "function_divide",
        "content": [
            {
                "type": "function_count",
                "content": [
                    {
                        "type": "property",
                        "value": "transactions.customer_id"
                    }
                ]
            },
            {
                "type": "function_count",
                "content": [
                    {
                        "type": "property",
                        "value": "transactions.customer_id"
                    }
                ],
                "options": {
                    "aggregateBy": [
                        null
                    ]
                }
            }
        ]
    }
}
accept_aggr_by_null_1
Code Block
titleaccept_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
Code Block
titleaccept_aggr_by_null_2
{
    "name": "accept_aggr_by_null_2",
    "type": "metric",
    "content": {
        "type": "function_count",
        "content": [
            {
                "type": "property",
                "value": "transactions.identifier"
            }
        ],
        "options": {
            "acceptAggregateBy": [
                null
            ]
        }
    }
}
sort_null_asc_1
Code Block
titlesort_null_asc_1
{
    "name": "sort_null_asc_1",
    "type": "metric",
    "content": {
        "type": "function_plus",
        "content": [
            {
                "type": "function_ifnull",
                "content": [
                    {
                        "type": "function_sum",
                        "content": [
                            {
                                "type": "property",
                                "value": "transactions.value"
                            }
                        ],
                        "options": {
                            "filterBy": [
                                {
                                    "property": "transactions.store_id",
                                    "value": 101,
                                    "operator": "eq"
                                }
                            ]
                        }
                    },
                    {
                        "type": "number",
                        "value": 0.0
                    }
                ]
            },
            {
                "type": "function_sum",
                "content": [
                    {
                        "type": "property",
                        "value": "transactions.value"
                    }
                ],
                "options": {
                    "filterBy": [
                        {
                            "property": "transactions.store_id",
                            "value": 102,
                            "operator": "eq"
                        }
                    ]
                }
            }
        ]
    }
}
sort_null_asc_2
Code Block
titlesort_null_asc_2
{
    "name": "sort_null_asc_2",
    "type": "metric",
    "content": {
        "type": "function_percentile",
        "content": [
            {
                "type": "function_plus",
                "content": [
                    {
                        "type": "function_ifnull",
                        "content": [
                            {
                                "type": "function_sum",
                                "content": [
                                    {
                                        "type": "property",
                                        "value": "transactions.value"
                                    }
                                ],
                                "options": {
                                    "filterBy": [
                                        {
                                            "property": "transactions.store_id",
                                            "value": 101,
                                            "operator": "eq"
                                        }
                                    ]
                                }
                            },
                            {
                                "type": "number",
                                "value": 0.0
                            }
                        ]
                    },
                    {
                        "type": "function_sum",
                        "content": [
                            {
                                "type": "property",
                                "value": "transactions.value"
                            }
                        ],
                        "options": {
                            "filterBy": [
                                {
                                    "property": "transactions.store_id",
                                    "value": 102,
                                    "operator": "eq"
                                }
                            ]
                        }
                    }
                ]
            }
        ],
        "options": {
            "sort": "desc"
        }
    }
}
sort_null_asc_3
Code Block
titlesort_null_asc_3
{
    "name": "sort_null_asc_3",
    "type": "metric",
    "content": {
        "type": "function_rank",
        "content": [
            {
                "type": "function_plus",
                "content": [
                    {
                        "type": "function_ifnull",
                        "content": [
                            {
                                "type": "function_sum",
                                "content": [
                                    {
                                        "type": "property",
                                        "value": "transactions.value"
                                    }
                                ],
                                "options": {
                                    "filterBy": [
                                        {
                                            "property": "transactions.store_id",
                                            "value": 101,
                                            "operator": "eq"
                                        }
                                    ]
                                }
                            },
                            {
                                "type": "number",
                                "value": 0.0
                            }
                        ]
                    },
                    {
                        "type": "function_sum",
                        "content": [
                            {
                                "type": "property",
                                "value": "transactions.value"
                            }
                        ],
                        "options": {
                            "filterBy": [
                                {
                                    "property": "transactions.store_id",
                                    "value": 102,
                                    "operator": "eq"
                                }
                            ]
                        }
                    }
                ]
            }
        ],
        "options": {
            "sort": "desc"
        }
    }
}
having_filter_count_by_decimal_1
Code Block
titlehaving_filter_count_by_decimal_1
{
    "name": "having_filter_count_by_decimal_1",
    "type": "metric",
    "content": {
        "type": "function_count",
        "content": [
            {
                "type": "property",
                "value": "transactions.identifier"
            }
        ]
    }
}
accept_without_filters_1
Code Block
titleaccept_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
Code Block
titleaccept_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
Code Block
titleaccept_without_filters_3
{
    "name": "accept_without_filters_3",
    "type": "metric",
    "content": {
        "type": "function_sum",
        "content": [
            {
                "type": "property",
                "value": "transactions.value"
            }
        ],
        "options": {
            "withoutFilters": [
                "customers.*",
                "transactions.store*"
            ],
            "filterBy": [
                {
                    "property": "transactions.store_id",
                    "value": 100,
                    "operator": "eq"
                },
                {
                    "property": "transactions.value",
                    "value": 50,
                    "operator": "gte"
                }
            ]
        }
    }
}
percentile_same_values_1
Code Block
titlepercentile_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
Code Block
titlepercentile_same_values_2
{
    "name": "percentile_same_values_2",
    "type": "metric",
    "content": {
        "type": "function_count",
        "content": [
            {
                "type": "property",
                "value": "transactions.customer_id"
            }
        ]
    }
}
round_property_1
Code Block
titleround_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
Code Block
titleround_property_2
{
    "name": "round_property_2",
    "type": "metric",
    "content": {
        "type": "function_sum",
        "content": [
            {
                "type": "property",
                "value": "transactions.value"
            }
        ]
    }
}
permission_filter_by_attribute_nested_1
Code Block
titlepermission_filter_by_attribute_nested_1
{
    "name": "permission_filter_by_attribute_nested_1",
    "type": "metric",
    "content": {
        "type": "function_multiply",
        "content": [
            {
                "type": "function_sum",
                "content": [
                    {
                        "type": "property",
                        "value": "transactions.value"
                    }
                ],
                "options": {
                    "withoutFilters": [
                        "transactions.store_id"
                    ],
                    "filterBy": [
                        {
                            "property": "zsj_desc.kod_zsj_d",
         }
}
round_property_count_4
Code Block
titleround_property_count_4
{
    "name": "round_property_count_4",
    "type": "metric",
    "content": {
        "type": "function_count",
        "querycontent": {[
             {
                  "propertiestype": ["property",
                "value": "customers.identifier"
            }
     {   ]
    }
}
filter_by_1
Code Block
titlefilter_by_1
{
    "name": "filter_by_1",
    "type": "metric",
    "content":  {
           "idtype": "kodfunction_zsj_dsum",
        "content": [
             {
                "type": "property",
                "value": "transactions.value"
            }
        ]
"value": "zsj_desc.kod_zsj_d"   }
}
filter_by_in_1
Code Block
titlefilter_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
Code Block
titlefilter_by_extern_property_1
{
      "operatorname": "inAttribute"filter_by_extern_property_1",
    "type": "metric",
    "content": {
            }"type": "function_sum",
                        {"content": [
            {
                 "propertytype": "transactions.valueproperty",
                "value": "zsj_desc.population"
          "value": 50, }
        ]
    }
}
having_just_one_zsjd_1
Code Block
titlehaving_just_one_zsjd_1
{
    "name": "having_just_one_zsjd_1",
     "operatortype": "gtemetric",
    "content": {
        "type": "function_divide",
        }"content": [
            {
      ]          "type": "function_sum",
     }           "content": [
},             {        {
        "id": "nested_in_attribute",                 "type": "numberproperty",
                "value": 13.0       "value": "transactions.value"
    }           ]     }
} 
ntile_1
Code Block
titlentile_1
{     "name": "ntile_1",     "type": "metric",   ]
 "content": {         "type": "function_ntile",
      },
  "content": [             {
                "type": "function_sum",
                "content": [
                    {
                        "type": "property",
                        "value": "transactions.value"
                    }
                ],
                }"options": {
       ],         "options": {   "aggregateBy": [
        "sort": "desc",             "buckets": 3 null
       }     } } 
ntile_2
Code Block
titlentile_2
{     "name": "ntile_2" ],
    "type": "metric",     "content": {         "typewithoutFilters": "function_sum", [
           "content": [            "transactions.store_id"
{                 "type": "property",  ]
              "value": "transactions.value"  }
            }
        ]
    }
}

...

having_percent_turnover_1
Code Block
titleroundhaving_percent_turnover_1
{
    "name": "roundhaving_percent_turnover_1",
    "type": "metric",
    "content": {
        "type": "function_rounddivide",
        "content": [
            {
                "type": "function_avgsum",
                "content": [
                    {
                        "type": "property",
                        "value": "transactions.value"
                    }
                ]
            },
        ],    {
                "optionstype": { "number",
                "placesvalue": 1 1000.0
            }
        ]
    }
}

...

having_percent_turnover_2
Code Block
titleroundhaving_percent_turnover_2
{
    "name": "roundhaving_percent_turnover_2",
    "type": "metric",
    "content": {
        "type": "function_roundsum",
        "content": [
            {
                "type": "function_avgproperty",
                "contentvalue": ["transactions.value"
            }
       { ],
        "options": {
             "typefilterBy": "property",[
                {
          "value": "transactions.value"         "property": "transactions.store_id",
          }          "value": 100,
     ]             }  "operator": "eq"
     ],         "options": { }
           "places": -2 ]
        }
    }
}

...

having_percent_turnover_3
Code Block
titleroundhaving_percent_turnover_3
{
    "name": "roundhaving_percent_turnover_3",
    "type": "metric",
    "content": {
        "type": "function_avgdivide",
        "content": [
            {
                "type": "function_roundsum",
                "content": [
                    {
                        "type": "property",
                        "value": "transactions.value"
                    }
      
         ],                 "options": {
                    "places": 1
                }
            }
        ]
    }
}
round_4
Code Block
titleround_4
{     "name": "round_4",  }
  "type": "metric",     "content": {       ]
 "type": "function_round",         "content": [ },
            {
                "type": "function_dividesum",
                "content": [
                    {
                        "type": "function_sumproperty",
                        "contentvalue": [ "transactions.value"
                    }
                ],
{                "options": {
                    "typeaggregateBy": "property",[
                        null
       "value": "transactions.value"            ]
                }
            }
        ]
    ]}
}
local_filter_1
Code Block
titlelocal_filter_1
{
    "name": "local_filter_1",
    "type": "metric",
    "content": {
   },     "type": "function_sum",
        "content": [
    {        {
                "type": "numberproperty",
                "value": "transactions.value"
            "value": 1000.0}
        ],
        "options": {
   }         "filterBy": [
      ]          {
  }         ],         "optionsproperty": { "transactions.store_id",
                    "placesvalue": 1100,
        }     } } 
round_5
Code Block
titleround_5
{     "nameoperator": "round_5"eq"
                },
    "type": "metric",           "content": {
         "type": "function_divide",           "contentproperty": ["transactions.value",
            {        "value": 35.2,
       "type": "function_round",            "operator": "gt"
   "content": [            }
        {    ]
        }
    }
}
local_filter_2
Code Block
titlelocal_filter_2
{
    "typename": "functionlocal_filter_sum2",
    "type": "metric",
         "content": {
        "contenttype": ["function_sum",
        "content": [
            {
     {                "type": "property",
                "typevalue": "propertytransactions.value",
            }
        ]
    }
}
without_1
Code Block
titlewithout_1
{
    "valuename": "transactions.value"without_1",
    "type": "metric",
    "content": {
        "type": "function_sum",
      }  "content": [
            {
        ]        "type": "property",
           }     "value": "transactions.value"
          ],  }
        ]
    }
"options": }
without_2
Code Block
titlewithout_2
{
    "name": "without_2",
         "type": "metric",
    "placescontent": 1{
          "type": "function_sum",
     }   "content": [
        },             {
                "type": "numberproperty",
                "value": 1000"transactions.0value"
            }
        ],
      }
}
filter_by_attribute_sum_of_max_1
Code Block
titlefilter_by_attribute_sum_of_max_1
{  "options": {
            "namewithoutFilters": "filter_by_attribute_sum_of_max_1", [
        "type": "metric",     "content": { "transactions.store_id"
       "type": "function_sum",    ],
    "content": [       "filterBy": [
    {            {
    "type": "property",                 "valueproperty": "zsj_desc.population"transactions.store_id",
            }        "value": ]100,

       "options": {             "withoutFiltersoperator": ["eq"
                "transactions.store_id"}
            ],
        }
    "filterBy": [
}
}
without_3
Code Block
titlewithout_3
{
    "name": "without_3",
    "type": "metric",
   { "content": {
        "type": "function_sum",
        "propertycontent": "zsj_desc.kod_zsj_d",[
            {
        "query": {       "type": "property",
                "propertiesvalue": ["transactions.value"
            }
        ],
      {  "options": {
            "withoutFilters": [
               "id": "kod_zsj_d",trans*.*_id"
            ],
            "filterBy": [
     "type": "property",           {
                     "valueproperty": "zsj_desctransactions.kodstore_zsj_did",
                    "value": 100,
      },              "operator": "eq"
             {   }
            ]
        }
    }
}
without_all_filters_1
Code Block
titlewithout_all_filters_1
{
    "idname": "transactionwithout_sumall_maxfilters_customer1",
    "type": "metric",
    "content": {
        "type": "function_sum",
          "typecontent": "function_sum",[
               {
                "contenttype": ["property",
                    "value": "transactions.value"
            }
  {      ]
    }
}
without_all_filters_2
Code Block
titlewithout_all_filters_2
{
    "name": "without_all_filters_2",
    "type": "metric",
    "content": {
         "type": "function_maxsum",
        "content": [
            {
                "type": "contentproperty":,
[                "value": "transactions.value"
            }
        ],
      {  "options": {
            "withoutFilters": [
                "transactions.*"
            ],
 "type": "property",          "filterBy": [
                {
                    "valueproperty": "transactions.value"store_id",
                    "value": 100,
                    "operator": "eq"
             }   },
                {
                    ]"property": "transactions.value",
                    "value": 35.2,
                    "optionsoperator": {"gt"
                }
            ]
        }
    }
"aggregateBy": [}
ntile_1
Code Block
titlentile_1
{
    "name": "ntile_1",
    "type": "metric",
    "content": {
        "type": "function_ntile",
        "content": [
          "transactions.customer_id"  {
                "type": "function_sum",
                "content": [
      ]              {
                        "type": "property",
}                        "value": "transactions.value"
           }         }
                ]
      ]      }
        ],
        "options": {
     }       "sort": "desc",
            "buckets": 3
  ],      }
    }
}
ntile_2
Code Block
titlentile_2
{
    "name": "ntile_2",
     "havingtype": ["metric",
    "content": {
        "type": "function_sum",
        "content": [
  {          {
                      "propertyId"type": "transaction_sum_max_customerproperty",
                                "value": 65,"value": "transactions.value"
            }
        ]
    }
}
ntile_filter_by_1
Code Block
titlentile_filter_by_1
{
    "operatorname": "gte"ntile_filter_by_1",
    "type": "metric",
    "content": {
        "type": "function_ntile",
      }  "content": [
            {
        ]        "type": "function_sum",
           },     "content": [
              "operator": "inAttribute"     {
           },             "type": "property",
   {                     "propertyvalue": "transactions.store_idvalue",
                    "value": 101,}
                ]
    "operator": "ne"       }
        ],
}        "options": {
   ]         }
"sort": "desc",
   } } 
aggregate_zsjd_1
Code Block
titleaggregate_zsjd_1
{     "name": "aggregate_zsjd_1",
    "typebuckets": "metric"3,
    "content": {         "typefilterBy": "function_sum",[
        "content": [         {
   {                 "typeproperty": "propertyzsj_desc.kod_zsj_d",
                    "value": "transactions.value"11111,
                    }
"operator": "eq"
       ]     } }
aggregate_zsjd_2
Code Block
titleaggregate_zsjd_2
{
   },
   "name": "aggregate_zsjd_2",     "type": "metric",     "content": {
        "type            "property": "function_counttransactions.value",
        "content": [            "value": 35.2,
   {                 "typeoperator": "propertygte",
                "value": "transactions.store_id"}
            ]
}         ]}
    }
}

...

ntile_filter_

...

by_

...

2
Code Block
titleaggregatentile_filter_zsjdby_32
{
    "name": "aggregatentile_filter_zsjdby_32",
    "type": "metric",
    "content": {
        "type": "function_count_distsum",
        "content": [
            {
                "type": "property",
                "value": "transactions.store_idvalue"
            }
        ]
    }
}

...

ntile_partition_

...

by_

...

1
Code Block
titleaggregatentile_partition_zsjdby_41
{
    "name": "aggregatentile_partition_zsjdby_41",
    "type": "metric",
    "content": {
        "type": "function_avgntile",
        "content": [
            {
                "type": "propertyfunction_sum",
                "valuecontent": "transactions.value"[
            }         ]
    }
}
aggregate_zsjd_5
Code Block
titleaggregate_zsjd_5
{
    "name": "aggregate_zsjd_5",     "type": "metric",     "content": {         "type": "function_maxproperty",
        "content": [             {  "value": "transactions.value"
             "type": "property",      }
          "value": "transactions.value"     ]
       }     }
   ]     }],
} 
aggregate_zsjd_6
Code Block
titleaggregate_zsjd_6
{     "name": "aggregate_zsjd_6",     "typeoptions": "metric",{
    "content": {         "typesort": "function_mindesc",
        "content": [       "buckets": 8,
     {                 "type": "property",
"partitionBy": [
               "value": "transactions.valuekod_zsj_d"
            }]
        ]}
    }
}

...

ntile_partition_

...

by_

...

2
Code Block
titleaggregatentile_partition_zsjdby_72
{
    "name": "aggregatentile_partition_zsjdby_72",
    "type": "metric",
    "content": {
        "type": "function_stddev_sampsum",
        "content": [
            {
                "type": "property",
                "value": "transactions.value"
            }
        ]
    }
}

...

Code Block
titlerank_2
{
    "name": "rank_2",
    "type": "metric",
    "content": {
        "type": "function_sum",
        "content": [
            {
                "type": "property",
                "value": "transactions.value"
            }
        ]
    }
}
rank_partition_by_1
Code Block
titlerank_partition_by_1
{
    "name": "rank_partition_by_1",
    "type": "metric",
    "content": {
        "type": "function_rank",
        "content": [
            {
                "type": "function_sum",
                "content": [
    "type": "function_sum",         "content": [     {
       {                 "type": "property",
                        "value": "transactions.value"
            }        }
  ]      } } 
sort_1
Code Block
titlesort_1
{     "name": "sort_1", ]
    "type": "metric",     "content": { }
       "type": "function_sum" ],
        "contentoptions": [{
            {"partitionBy": [
               "type": "propertykod_zsj_d",
            ],
   "value": "transactions.value"        "sort": "desc"
   }         ]}
    }
}

...

rank_partition_by_

...

2
Code Block
titlefilterrank_partition_by_function_today_12
{
    "name": "filterrank_partition_by_function_today_12",
    "type": "metric",
    "content": {
        "type": "function_sum",
        "content": [
            {
                "type": "property",
                "value": "transactions.value"
            }
        ]
    }
}

...

rank_

...

with_filter_1
Code Block
titleaggrrank_sum_of_max_plus_minwith_filter_1
{
    "name": "aggrrank_sumwith_of_max_plus_min_filter_1",
    "type": "metric",
    "content": {
        "type": "function_plusrank",
        "content": [
            {
                "type": "function_sum",
                "content": [
                    {
                        "type": "function_max",
                        "content": [
                            {
                                "type": "property",
  
                             "value": "transactions.value"
                            }
       
                ],
                        "options": {
        {
                    "aggregateBywithoutFilters": [
       
                        "transactions*.store_id*"
                    ]
       ]         }
            }
  }      ],
        "options": {
     }       "sort": "desc",
        ]    "filterBy": [
       },         {
   {                 "typeproperty": "functiontransactions.store_minid",
                    "contentvalue": [
                    {    100,
                    "type": "property",   101
                     "value": "transactions.value"],
                     }"operator": "in"
                ]}
            }]
        ]}
    }
}

...

rank_

...

with_

...

filter_

...

2
Code Block
titlefilterrank_bywith_booleanfilter_12
{
    "name": "filterrank_bywith_booleanfilter_12",
    "type": "metric",
    "content": {
        "type": "function_sum",
        "content": [
            {
                "type": "property",
                "value": "transactions.value"
            }
        ],
       } }
having_just_one_zsjd_1
Code Block
titlehaving_just_one_zsjd_1
"options": {
    "name": "having_just_one_zsjd_1",        "withoutFilters": [
          "type": "metric",     "content": {*.*"
           "type": "function_divide", ],
            "contentfilterBy": [
                {
                    "typeproperty": "functiontransactions.store_sumid",
                    "contentvalue": [
                    {    100,
                    "type": "property",   101
                    ],
"value": "transactions.value"                   "operator": "in"
}                }
]            ]
},        }
    {}
}
rank_with_filter_3
Code Block
titlerank_with_filter_3
{
         "name": "rank_with_filter_3",
    "type": "function_summetric",
    "content": {
          "content": [      "type": "function_sum",
        "content": [
    {        {
                "type": "property",
                        "value": "transactions.value"
            }
       } ]
    }
}
can_2694_1
Code Block
titlecan_2694_1
{
        ]"name": "can_2694_1",
    "type": "metric",
          "options"content": {
        "type": "function_divide",
          "aggregateBycontent": [
            {
           null                     ],
"type": "function_sum",
                   "withoutFilterscontent": [
                    {
   "transactions.store_id"                     ]
"type": "property",
               }         "value": "transactions.value"
  }         ]     } } 
filter_by_boolean_without_filters_1
Code Block
titlefilter_by_boolean_without_filters_1
{
    "name": "filter_by_boolean_without_filters_1",
  }
   "type": "metric",     "content": {      ]
  "type": "function_sum",         "content": [},
             {
                "type": "propertynumber",
                "value": "transactions1000.value"0
            }
        ]
    }
}

...

can_2694_2
Code Block
titlefilter_by_boolean_without_filters_can_2694_2
{
    "name": "filtercan_by_boolean_without_filters_2694_2",
    "type": "metric",
    "content": {
        "type": "function_sum",
        "content": [
            {
                "type": "property",
                "value": "transactions.value"
            }
        ],
        "options": {
            "withoutFilters": [ "transactions.value"
            }
     "trans*.va*"   ],
         ],"options": {
            "filterBy": [
                {
                    "operatorproperty": "ortransactions.store_id",
                    "contentvalue": [100,
                    "operator": "eq"
  {              }
            ]
 "property": "transactions.value",      }
    }
}
can_2694_3
Code Block
titlecan_2694_3
{
    "name": "can_2694_3",
         "valuetype": 20"metric",
    "content": {
                      "operator"type": "ltefunction_divide",
        "content": [
            {
 },               "type": "function_sum",
        {        "content": [
                   "property": "transactions.value", {
                            "valuetype": 80"property",
                            "operatorvalue": "gte"
   transactions.value"
                    }

                   ]
                },
            ]
{
       }     }
}
aggr_sum_by_store_of_max_by_customer_1
Code Block
titleaggr_sum_by_store_of_max_by_customer_1
{     "nametype": "aggrfunction_sum_by_store_of_max_by_customer_1",
          "type": "metric",     "content": {[
        "type": "function_sum",         "content": [  {
          {                 "type": "function_maxproperty",
                "content": [        "value": "transactions.value"
               {     }
                ],
  "type": "property",             "options": {
          "value": "transactions.value"         "aggregateBy": [
          }              null
  ],                 "options": { ],
                    "aggregateBywithoutFilters": [
                        "transactions.store_idzsj_desc.kod_zsj_d"
                    ]
                }
            }
        ]
    }
}

...

can_

...

2751_

...

1
Code Block
titlefiltercan_by_attribute2751_variable_1
{
    "name": "filter_by_attribute_variablecan_2751_1",
    "type": "metric",
    "content": {
        "type": "function_sum",
        "content": [
            {
                "type": "property",
                "value": "zsj_desctransactions.populationvalue"
            }
        ],
        "options": {
            "withoutFiltersfilterBy": [
                "transactions.store_id"{
            ],             "filterByproperty": [
         "transactions.store_id",
      {                     "property"value": "zsj_desc.kod_zsj_d"100,
                    "queryoperator": {"eq"
                }
       "properties": [    ]
        }
    }
}
can_2751_2
Code Block
titlecan_2751_2
{
    "name": "can_2751_2",
  {  "type": "metric",
    "content": {
        "type": "function_sum",
             "idcontent": "kod_zsj_d",[
             {
                  "type": "property",
               
                "value": "zsj_desc.kod_zsj_dpopulation"
            }
        ]
    }
 },

can_3062_1
Code Block
titlecan_3062_1
{
    "name": "can_3062_1",
    "type": "metric",
               "content": {
            "type": "function_sum",
                   "id"content": "transaction_sum",[
            {
                   "type": "function_multiply",
        property",
                "value": "transactions.value"
     "content": [      }
        ],
        "options": {
           { "filterBy": [
                {
                     "typeproperty": "function_sumtransactions.value",
                    "value": 100,
                    "contentoperator": ["gt"
                }
            ]
        },
     {   "_comment": "match only store=102"
    }
}
can_3062_2
Code Block
titlecan_3062_2
{
    "name": "can_3062_2",
    "type": "metric",
    "content": {
        "type": "function_sum",
        "typecontent": "property",[
            {
                  "type": "property",
                "value": "transactions.value"
            }
        ],
        "options": {
            }"filterBy": [
                {
                    "property":  ]"transactions.value",
                    "value": 75,
                    "operator": "gt"
 },               }
            ]
        {},
        "_comment": "match stores=[100,102]"
    }
}
can_3062_3
Code Block
titlecan_3062_3
{
    "name": "can_3062_3",
    "type": "metric",
    "content": {
        "type": "variablefunction_sum",
        "content": [
             {
                "valuetype": "number_100property",
                "value": "transactions.value"
            }
     }   ],
        "options": {
            "filterBy": [
     ]           {
                 }   "property": "transactions.value",
                    "value": ]50,
   
                    "havingoperator": ["gt"
                }
           { ]
        },
        "_comment": "match stores=[100,102]"
    }
  }
filter_property_in_limit_1
Code Block
titlefilter_property_in_limit_1
{
    "propertyIdname": "transaction_sumfilter_property_in_limit_1",
    "type": "metric",
    "content": {
        "type": "function_sum",
          "valuecontent": 700,[
            {
                   "operatortype": "gtproperty",
                "value": "transactions.value"
          }  }
        ],
        "options": {
   ]         "withoutFilters": [
          },      "zsj_desc.*"
              "operator": "inAttribute"],
                 },"filterBy": [
                {
                    "property": "transactions.store_id",
                    "value": 101,[
                    "operator": "ne"   100
             }             ],
        }     } } 
aggr_by_null_1
Code Block
titleaggr_by_null_1
{     "nameoperator": "aggr_by_null_1",in"
    "type": "metric",     "content": {         "type": "function_sum"},
        "content": [       {
     {                 "type": "property",
                "value": "transactions.valuestore_id",
            }         ],"value": [
        "options": {             "aggregateBy": [ 100,
               null         102
   ]         }     } } 
aggr_by_null_2
Code Block
titleaggr_by_null_2
{
    "name": "aggr_by_null_2" ],
    "type": "metric",       "content": {         "typeoperator": "function_countin",
        "content": [       },
     {           {
     "type": "property",                 "valueproperty": "transactions.identifier"zsj_desc.kod_zsj_d",
            }        "value": ]22222,

       "options": {             "aggregateByoperator": ["lte"
                null}
            ]
        }
    }
}

...

filter_property_

...

in_

...

limit_

...

2
Code Block
titleaggrfilter_property_byin_nulllimit_32
{
    "name": "aggrfilter_property_byin_nulllimit_32",
    "type": "metric",
    "content": {
        "type": "function_countsum",
        "content": [
            {
                "type": "property",
                "value": "transactions.store_idvalue"
            }
        ],
        "options": {
            "aggregateBywithoutFilters": [
                null
      
     ]         }
    } } 
aggr_by_customer_1
Code Block
titleaggr_by_customer_1
{
    "name": "aggr_by_customer_1","transactions.store_id"
    "type": "metric",     "content": { ],
       "type": "function_sum",
        "contentfilterBy": [
            {            {
    "type": "property",                 "valueproperty": "transactions.valuestore_id",
            }         ],"value": [
        "options": {             "aggregateBy": [ 100,
               "transactions.customer_id"         102
   ]         }     } } 
aggr_by_customer_2
Code Block
titleaggr_by_customer_2
{
    "name": "aggr_by_customer_2" ],
    "type": "metric",     "content": {         "typeoperator": "function_sum",
  in"
     "content": [          },
  {              {
  "type": "property",                 "valueproperty": "transactions.value"zsj_desc.kod_zsj_d",
            }        "value": ]22222,
        "options": {             "aggregateByoperator": ["lte"
                "transactions.store_id"}
            ]
        }
    }
}

...

rank_

...

of_

...

arithm_

...

1
Code Block
titleaggrrank_byof_customerarithm_31
{
    "name": "aggrrank_byof_customerarithm_31",
    "type": "metric",
    "content": {
        "type": "function_sumrank",
        "content": [
            {
                "type": "propertyfunction_divide",
                "valuecontent": [
"transactions.value"             }       {
 ],         "options": {             "aggregateBytype": [
                null
  "function_sum",
         ]         }     } }
variable_1
Code Block
titlevariable_1
{
    "name"content": "variable_1",[
    "type": "metric",     "content": {         "type": "function_divide",       {
 "content": [             {                 "type": "function_sum",
                "content": [
       property",
            {                         "typevalue": "propertytransactions.value",
                        "value": "transactions.value"   }
                 }       ]
         ]             },
            {         {
       "type": "variable",                 "valuetype": "numberfunction_1000count",
            }         ]     }
}
variable_2
Code Block
titlevariable_2
{
    "name"content": "variable_2",[
    "type": "metric",     "content": {         "type": "function_minus",       {
 "content": [             {                 "type": "variableproperty",
                "value": "number_625"             },  "value": "transactions.identifier"
         {                 "type": "function_multiply", }
               "content": [        ]
            {        }
                "type": "function_sum",]
            }
        ],
   "content": [    "options": {
            "sort": "desc"
        }
{    }
}
rank_of_arithm_2
Code Block
titlerank_of_arithm_2
{
    "name": "rank_of_arithm_2",
    "type": "metric",
    "content": {
        "type": "propertyfunction_divide",
        "content": [
            {
                "valuetype": "transactions.value"function_sum",
                "content": [
          }          {
                        ]"type": "property",
                    },    "value": "transactions.value"
               {     }
                ]
  "type": "variable",         },
            {
  "value": "number_121"             "type": "function_count",
      }          "content": [
     ]             }  {
      ]     } } 
variable_3
Code Block
titlevariable_3
{     "name": "variable_3",     "type": "metricproperty",
    "content": {         "type": "function_multiply",         "contentvalue": ["transactions.identifier"
               {     }
           "type": "function_sum",    ]
            "content":}
[        ]
    }
}
filter_by_attribute_1
Code Block
titlefilter_by_attribute_1
{
     {"name": "filter_by_attribute_1",
    "type": "metric",
    "content": {
            "type": "propertyfunction_sum",
        "content": [
            {
 "value": "transactions.value"              "type": "property",
     }           "value": "zsj_desc.population"
    ]        }
    },    ]
    }
   }
filter_by_attribute_2
Code Block
titlefilter_by_attribute_2
{
    "name": "filter_by_attribute_2",
          "type": "variablemetric",
    "content": {
          "valuetype": "numberfunction_121sum",
            },"content": [
             {
                "type": "function_countproperty",
                "contentvalue": ["zsj_desc.population"
            }
       { ],
        "options": {
             "typewithoutFilters": "property",
 [
                      "value": "transactions.store_id"
            ],
       }     "filterBy": [
          ]      {
      }         ]     }
}
accept_filters_1
Code Block
titleaccept_filters_1
{"property": "zsj_desc.kod_zsj_d",
        "name": "accept_filters_1",     "type": "metric",     "contentquery": {
        "type": "function_sum",                "contentproperties": [
            {                {
  "type": "property",                 "value": "transactions.value"           "id":  }"kod_zsj_d",
         ],         "options": {             "acceptFilterstype": ["property",
                    "transactions.*"             ],"value": "zsj_desc.kod_zsj_d"
            "filterBy": [               }
 {                     "property": "transactions.store_id",
 ]
                   "value": 100},
                    "operator": "eqinAttribute"
                },
                {
                    "property": "transactions.valuestore_id",
                    "value": 50101,
                    "operator": "gtene"
                }
            ]
        }
    }
}

...

filter_by_

...

attribute_

...

3
Code Block
titleacceptfilter_by_filtersattribute_23
{
    "name": "acceptfilter_by_filtersattribute_23",
    "type": "metric",
    "content": {
        "type": "function_sum",
        "content": [
            {
                "type": "property",
                "value": "transactionszsj_desc.valuepopulation"
            }
        ],
        "options": {
            "acceptFilterswithoutFilters": [
                "transactions.store_id"
            ],
            "filterBy": [
                {
                    "property": "transactions.store_id",
                    "value": 100,
                    "operator": "eq"
                }zsj_desc.kod_zsj_d",
                {
                    "property": "transactions.value",
                    "value": 50,
                    "operator": "gte"
                }
            ]
        }
    }
}
accept_filters_3
Code Block
titleaccept_filters_3
{
    "name": "accept_filters_3",
    "type": "metric",      "contentquery": {
        "type": "function_sum",                "contentproperties": [
            {                {
  "type": "property",                 "value": "transactions.value"           "id":  }"kod_zsj_d",
         ],         "options": {             "acceptFilterstype": ["property",
                    "customers.*"             ],"value": "zsj_desc.kod_zsj_d"
            "filterBy": [               }
 {                     "property": "transactions.store_id",
 ]
                   "value": 100},
                    "operator": "eqinAttribute"
                },
                {
                    "property": "transactions.valuestore_id",
                    "value": 50101,
                    "operator": "gtene"
                },
            ]    {
    }     } } 
big_numbers_1
Code Block
titlebig_numbers_1
{     "name": "big_numbers_1",     "typeproperty": "metrictransactions.store_id",
    "content": {         "type": "function_sum",         "contentvalue": [101,
            {                 "type"operator": "function_multiplyne",
                "content":}
[            ]
        {}
    }
}
filter_by_attribute_4
Code Block
titlefilter_by_attribute_4
{
            "name": "filter_by_attribute_4",
    "type": "propertymetric",
    "content": {
                  "value"type": "transactions.value"function_sum",
                    },
       "content": [
            {

                       "type": "numberproperty",
       
                "value": 1.0E9"zsj_desc.population"
            }
       } ],
        "options": {
     ]       "withoutFilters": [
    }         ]     }
}
big_numbers_2
Code Block
titlebig_numbers_2
{"transactions.store_id"
     "name": "big_numbers_2",     "type": "metric" ],
    "content": {
        "typefilterBy": "function_multiply",[
        "content": [        {
    {                 "typeproperty": "function_sumzsj_desc.kod_zsj_d",
                    "contentquery": [{
                      {  "properties": [
                     "type": "property",      {
                  "value": "transactions.value"             "id": "kod_zsj_d",
      }                 ]         "type": "property",
  },             {                 "typevalue": "number",zsj_desc.kod_zsj_d"
                "value": 4.56789123435E9           },
 }         ],         "_comment": "returns the first 12 digits, without decimal part" {
   } } 
big_numbers_3
Code Block
titlebig_numbers_3
{     "name": "big_numbers_3",     "type": "metric",     "content": {         "typeid": "functiontransaction_multiplysum",
    
   "content": [             {                 "type": "function_sum",
                                "content": [
                        {            {
              "type": "property",                         "valuetype": "transactions.value"property",
                          }              "value": "transactions.value"
 ]               },             {       }
         "type": "number",                 "value": 6.789123435E7    ]
        }         ],         "_comment": "returns the}
first 12 digits, with decimal part"     } } 
ntile_filter_by_1
Code Block
titlentile_filter_by_1
{     "name": "ntile_filter_by_1",     "type": "metric" ],
    "content": {         "type": "function_ntile",         "contenthaving": [
            {                {
 "type": "function_sum",                 "content": [            "propertyId": "transaction_sum",
       {                         "typevalue": "property",70,
                                "valueoperator": "transactions.valuegt"
                    }        }
        ]             }   ]
     ],         "options": {     },
       "sort": "desc",            "operator": "bucketsinAttribute":
  3,             "filterBy": [ },
                {
                    "property": "zsj_desctransactions.kodstore_zsj_did",
                    "value": 11111101,
                    "operator": "eqne"
                },
            ]
   {     }
    }
     }
filter_by_attribute_5
Code Block
titlefilter_by_attribute_5
{
    "propertyname": "transactions.valuefilter_by_attribute_5",
    "type": "metric",
    "content": {
        "valuetype": 35.2,
       "function_sum",
            "operatorcontent": "gte"[
            {
   }             ]
"type": "property",
       }     } } 
ntile_filter_by_2
Code Block
titlentile_filter_by_2
{
    "namevalue": "ntile_filter_by_2",zsj_desc.population"
    "type": "metric",     "content": { }
       "type": "function_sum" ],
        "contentoptions": [{
            {"withoutFilters": [
                "type": "property",transactions.store_id"
            ],
            "valuefilterBy": "transactions.value" [
                }{
        ]     } } 
filter_by_metric_inherit_granularities_1
Code Block
titlefilter_by_metric_inherit_granularities_1
{     "nameproperty": "filterzsj_bydesc.kod_metric_inherit_granularities_1zsj_d",
     "type": "metric",               "contentquery": {
          "type": "function_sum",              "contentproperties": [
            {                {
             "type": "property",                   "valueid": "transactions.value"kod_zsj_d",
              }         ],         "optionstype": {"property",
              "withoutFilters": [                 "transactions.processed_at"value": "zsj_desc.kod_zsj_d"
                        ]    },
            "filterBy": [                {
           {                     "propertyid": "transactions.processedtransaction_atsum",
                     "query":  {         "type": "function_sum",
              "properties": [                 "content": [
          {                          {
      "id": "max_date",                                 "type": "function_maxproperty",
                                "content": [       "value": "transactions.value"
                            {        }
                                "type": "property"],
                                "options": {
      "value": "transactions.processed_at"                               "withoutFilters": [
        }                                 ],"transactions.store_id"
                                 "options": {  ]
                                }
 "acceptAggregateBy": [                          }
              "transactions"          ],
                        "having": [
]                            {
    }                             }"propertyId": "transaction_sum",
                        ]        "value": 70,
           },                     "operator": "inAttributegt"
                },            }
    {                     "property": "transactions.processed_at",]
                    "value": "2015-11-01"},
                    "operator": "gteinAttribute"
                },
                {
                    "property": "transactions.processedstore_atid",
                    "value": "2015-11-07"101,
                    "operator": "ltne"
                }
            ]
        }
    }
}
filter_by_attribute_

...

variable_1
Code Block
titlefilter_by_attribute_combinedvariable_1
{
    "name": "filter_by_attribute_combinedvariable_1",
    "type": "metric",
    "content": {
        "type": "function_sum",
        "content": [
            {
                "type": "property",
                "value": "transactionszsj_desc.valuepopulation"
            }
        ],
        "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": [                             {
                                "propertyid": "transactions.valuetransaction_sum",
                                "valuetype": 45"function_multiply",
                                "operatorcontent": "gte"[
                            }                         ]
{
                   },                     "operatortype": "inAttribute"
                }function_sum",
                {                     "property": "transactions.value",
                    "value"content": 25,[
                    "operator": "gte"                 },                 {
           
        "property": "transactions.store_id",
                    "value": 101,                     "operatortype": "neproperty",
                }             ]         }     } } 
filter_by_boolean_nor_1
Code Block
titlefilter_by_boolean_nor_1
{
    "namevalue": "filter_by_boolean_nor_1",transactions.value"
     "type": "metric",     "content": {         "type": "function_sum",         "content": [            }
{                 "type": "property",                 "value": "transactions.value"    ]
        }         ]     } } 
aggr_sum_of_count_by_store_1
Code Block
titleaggr_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": "variable",
               {                         "typevalue": "property",
  number_100"
                     "value": "transactions.identifier"                     }
                ],                ]
"options": {                     "aggregateBy": [     }
                   "transactions.store_id"     ],
               ]         "having": [
      }             }         ]{
    } } 
filter_by_attribute_two_filters_nested_1
Code Block
titlefilter_by_attribute_two_filters_nested_1
{     "name": "filter_by_attribute_two_filters_nested_1",     "type": "metric",     "content": {         "typepropertyId": "functiontransaction_sum",
        "content": [                  {      "value": 700,
         "type": "property",                       "valueoperator": "transactions.valuegt"
            }          ]     } }
row_number_zsjd_store_by_revenue_1
Code Block
titlerow_number_zsjd_store_by_revenue_1
{
    "name": "row_number_zsjd_store_by_revenue_1",     "type": "metric",     "content": {        ]
"type": "function_row_number",         "content": [         },
   {                 "typeoperator": "function_suminAttribute",
                "content": [},
                {
    {                "property": "transactions.store_id",
       "type": "property",            "value": 101,
           "value": "transactions.value"         "operator": "ne"
            }    }
            ]
        }
    }
}
filter_by_attribute_global_1
Code Block
titlefilter_by_attribute_global_1
{
    "name": "filter_by_attribute_global_1",
 ],   "type": "metric",
    "optionscontent": {
        "type": "function_sum",
        "partitionBycontent": [
            {
    "kod_zsj_d"             ]"type": "property",
                "sortvalue": "zsj_desc.population"
            }
      }
}
rank_partition_by_1
Code Block
titlerank_partition_by_1
{  ],
        "options": {
      "name": "rank_partition_by_1",     "typewithoutFilters": "metric",[
     "content": {         "type": "functiontransactions.store_rank",id"
            ],
            "contentfilterBy": [
                {
                    "typeproperty": "functiontransactions.store_sumid",
                    "contentvalue": 101,
 [                   "operator": "ne"
{                },
          "type": "property",     {
                    "valueproperty": "transactions.value"zsj_desc.kod_zsj_d",
                    "query": {
     }                 ]  "properties": [
         }         ],         "options": {
            "partitionBy": [                    "id": "kod_zsj_d",
            ],                    "sorttype": "desc"property",
                    }     } } 
rank_partition_by_2
Code Block
titlerank_partition_by_2
{     "namevalue": "rankzsj_partitiondesc.kod_byzsj_2d",
     "type": "metric",     "content": {         "type": "function_sum",      },
  "content": [             {            {
    "type": "property",                 "value": "transactions.value"         "id": "transaction_sum",
  }          ]     } } 
aggr_sum_of_max_by_store_1
Code Block
titleaggr_sum_of_max_by_store_1
{     "name": "aggr_sum_of_max_by_store_1",        "type": "metricfunction_multiply",
            "content": {         "type": "function_sum",         "content": [
            {                 "type": "function_max",       {
         "content": [                     {         "type": "function_sum",
              "type": "property",                         "valuecontent": "transactions.value" [
                                     }       {
         ],                 "options": {                     "aggregateBytype": ["property",
                             "transactions.store_id"                   "value": "transactions.value"
]                 }             }         ]     }
       } 
having_boolean_two_metrics_1
Code Block
titlehaving_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
Code Block
titlehaving_boolean_two_metrics_2
{     "name": "having_boolean_two_metrics_2",     "type": "metric",     "content": {         "type": "function_countvariable",
        "content":  [             {                 "typevalue": "propertynumber_100",
                "value": "transactions.identifier"             }      }
  ]     } }
filter_by_extern_property_1
Code Block
titlefilter_by_extern_property_1
{              "name": "filter_by_extern_property_1",     "type": "metric",   ]
 "content": {         "type": "function_sum",         "content": [      }
      {                 "type": "property" ],
                "value        "having": "zsj_desc.population"[
            }         ]     } } 
filter_by_attribute_two_filters_one_skippable_1
Code Block
titlefilter_by_attribute_two_filters_one_skippable_1
{{
      "name": "filter_by_attribute_two_filters_one_skippable_1",          "type": "metric",     "content": {         "typepropertyId": "functiontransaction_sum",
        "content": [                    {    "value": 700,
           "type": "property",                     "valueoperator": "transactions.valuegt"
            }         ],       }
 "options": {             "filterBy": [        ]
        {            },
        "property": "zsj_desc.kod_zsj_d",           "operator": "inAttribute"
        "query": {       }
            ]
    "properties": [   }
    }
}
filter_by_attribute_combined_1
Code Block
titlefilter_by_attribute_combined_1
{
    "name": "filter_by_attribute_combined_1",
    "type": "metric",
    "content": {
{        "type": "function_sum",
        "content": [
            {
"id": "kod_zsj_d",               "type": "property",
                "typevalue": "propertytransactions.value",
            }
        ],
          "valueoptions": "zsj_desc.kod_zsj_d"{
            "withoutFilters": [
                "transactions.store_id"
  },          ],
            "filterBy": [
    {            {
                    "idproperty": "populationzsj_wheredesc.kod_store_id_ne_101zsj_d",
                    "query": {
          "type": "function_sum",             "properties": [
                  "content": [         {
                           {     "id": "kod_zsj_d",
                                  "type": "property",
     
                                  "value": "zsj_desc.populationkod_zsj_d"
                            }
       }                 ],
               ],         "filterBy": [
                      "options":  {    {
                                "filterByproperty": ["transactions.value",
                                "value": 45,
           {                     "operator": "gte"
                        "property": "zsj_desc.kod_zsj_d",   }
                        ]
                "query": {   },
                    "operator": "inAttribute"
                },
      "properties": [         {
                    "property": "transactions.value",
                     {"value": 25,
                    "operator": "gte"
                },
                {
"id": "kod_zsj_d",                   "property": "transactions.store_id",
                    "value": 101,
              "type": "property",     "operator": "ne"
                }
            ]
        }
    }
}
filter_by_attribute_nested_1
Code Block
titlefilter_by_attribute_nested_1
{
    "valuename": "zsj_desc.kod_zsj_d"filter_by_attribute_nested_1",
    "type": "metric",
    "content": {
        "type": "function_multiply",
        "content": [
            {
       },         "type": "function_sum",
                     "content": [
                    {
                        "type": "property",
                              "id"value": "aux_metric",transactions.value"
                    }
                  ],
                "typeoptions": "function_count",{
                          "withoutFilters": [
                             "content": ["transactions.store_id"
                    ],
                    "filterBy": [
                  {      {
                            "property": "zsj_desc.kod_zsj_d",
                            "typequery": "property",{
                                "properties": [
                              "value": "zsj_desc.kod_zsj_d"     {
                                        "id": "kod_zsj_d",
             }                           "type": "property",
                            ],            "value": "zsj_desc.kod_zsj_d"
                                    }
      "options": {                         ]
                            },
      "withoutFilters": [                     "operator": "inAttribute"
                        },
                 "*.*"       {
                            "property": "transactions.value",
                       ]     "value": 50,
                            "operator": "gte"
                    }    }
                    ]
                }
            },
            {
                "id": "nested_in_attribute",
                 ]"type": "number",
                "value": 13.0
            }
        ]
    },
}
ifnull_1
Code Block
titleifnull_1
{
    "name": "ifnull_1",
    "type": "metric",
    "content": {
             "type": "function_plus",
          "operatorcontent": "inAttribute",[
            {
                "type": "function_ifnull",
                "_commentcontent": "this[
attribute filter shloud be skipped, it has no filters"             {
                        "type": "function_sum",
 }                       "content": [
            ]                {
                }                "type": "property",
           }                     "value": "transactions.value"
  ],                         "having": [}
                        ],
   {                     "options": {
          "propertyId": "population_where_store_id_ne_101",                 "filterBy": [
              "value": 500,                 {
               "operator": "gte"                    "property": "transactions.store_id",
       }                         ]    "value": 101,
               },                     "operator": "inAttributeeq"
                }             ]   }
     }     } } 
filter_by_metric_1
Code Block
titlefilter_by_metric_1
{     "name": "filter_by_metric_1",     "type": "metric",    ]
"content": {         "type": "function_sum",         "content": [   }
         {           },
     "type": "property",              {
  "value": "transactions.value"             }         ]"type": "number",
        "options": {                "withoutFiltersvalue": [0.0
                "transactions.processed_at"    }
        ],        ]
    "filterBy": [        },
        {    {
                "propertytype": "transactions.processedfunction_atsum",
                "content": [
  "query": {                  {
          "properties": [             "type": "property",
              {          "value": "transactions.value"
                     "id": "max_date",}
                ],
                "typeoptions": "function_max",{
                    "filterBy": [
          "content": [             {
                       {     "property": "transactions.store_id",
                                  "type"value": "property"102,
                            "operator": "eq"
          "value": "transactions.processed_at"             }
                    ]
  }              }
            }
     ]   ]
    }
}
filter_by_boolean_1
Code Block
titlefilter_by_boolean_1
{
    "name": "filter_by_boolean_1",
    "type": "metric",
    "content": {
}        "type": "function_sum",
        "content": [
     ]       {
             },   "type": "property",
                "operatorvalue": "inAttributetransactions.value"
            }
   },     ]
    }
}
filter_by_boolean_nor_1
Code Block
titlefilter_by_boolean_nor_1
{
     {"name": "filter_by_boolean_nor_1",
    "type": "metric",
    "content": {
        "propertytype": "transactions.processedfunction_atsum",
        "content": [
          "value  {
                "type": "2015-11-01property",
                    "operatorvalue": "gtetransactions.value"
            }
   },     ]
    }
}
filter_by_boolean_or_and_1
Code Block
titlefilter_by_boolean_or_and_1
{
    { "name": "filter_by_boolean_or_and_1",
    "type": "metric",
    "content": {
        "propertytype": "transactions.processedfunction_atsum",
        "content": [
          "value": "2015-11-07",
    {
                "operatortype": "ltproperty",
                 }"value": "transactions.value"
            ]}
        }]
    }
}

...

filter_by_

...

boolean_

...

without_

...

filters_1
Code Block
titleaggrfilter_by_countboolean_bywithout_customerfilters_1
{
    "name": "aggrfilter_by_countboolean_bywithout_customerfilters_1",
    "type": "metric",
    "content": {
        "type": "function_countsum",
        "content": [
            {
                "type": "property",
                "value": "transactions.identifiervalue"
            }
        ],
    }
   "options": }
filter_by_boolean_without_filters_2
Code Block
titlefilter_by_boolean_without_filters_2
{
    "name": "filter_by_boolean_without_filters_2",
      "aggregateBytype": ["metric",
    "content": {
         "type": "transactions.customerfunction_idsum",
        "content": [
  ]         } {
   } } 
percentile_partition_by_1
Code Block
titlepercentile_partition_by_1
{     "name": "percentile_partition_by_1",     "type": "metricproperty",
    "content": {            "typevalue": "function_percentile",transactions.value"
            }
"content": [       ],
     {   "options": {
            "typewithoutFilters": "function_sum",[
                "contenttrans*.va*":
[            ],
        {    "filterBy": [
                {
  "type": "property",                 "operator": "or",
      "value": "transactions.value"             "content": [
      }                 ] {
           }         ],        "property": "options": {transactions.value",
              "partitionBy": [             "value": 20,
  "kod_zsj_d"             ],             "sortoperator": "desclte"
        }     } } 
percentile_partition_by_2
Code Block
titlepercentile_partition_by_2
{
    "name": "percentile_partition_by_2",     "type": "metric" },
    "content": {         "type": "function_sum",         "content": [
{
           {                 "typeproperty": "propertytransactions.value",
                "value": "transactions.value"           "value": 80,
}          ]     } } 
row_number_zsjd_store_avg_transaction_1
Code Block
titlerow_number_zsjd_store_avg_transaction_1
{     "name": "row_number_zsjd_store_avg_transaction_1",     "typeoperator": "metricgte",
    "content": {         "type": "function_row_number",         "content":}
[             {       ]
         "type": "function_divide",      }
          "content": [ ]
        }
    }
}
having_boolean_1
Code Block
titlehaving_boolean_1
{
   { "name": "having_boolean_1",
    "type": "metric",
    "content":  {
         "type": "function_sum",
        "content": [
            {
 "content": [              "type": "property",
             {   "value": "transactions.value"
            }
        ]
    }
 "type": "property",}
having_boolean_two_metrics_1
Code Block
titlehaving_boolean_two_metrics_1
{
       "name": "having_boolean_two_metrics_1",
    "type": "metric",
    "content": {
             "valuetype": "transactions.value"function_sum",
        "content": [
            {
     }           "type": "property",
            ],    "value": "transactions.value"
            }
      "options": { ]
    }
}
having_boolean_two_metrics_2
Code Block
titlehaving_boolean_two_metrics_2
{
    "name": "having_boolean_two_metrics_2",
    "type": "metric",
        "filterBycontent": [{
        "type": "function_count",
        "content": [
            {
                "type": "property",
                  "propertyvalue": "transactions.valueidentifier",
            }
        ]
    }
}
filter_by_boolean_and_attribute_1
Code Block
titlefilter_by_boolean_and_attribute_1
{
       "valuename": 0"filter_by_boolean_and_attribute_1",
    "type": "metric",
              "content": {
               "operator"type": "gtefunction_sum",
        "content": [
            {
         }       "type": "property",
                "value": "zsj_desc.population"
  ]          }
        ],
     }   "options": {
            "withoutFilters": [
  },              "transactions.store_id"
      {      ],
                  "type"filterBy": "function_count",[
                {
       "content": [            "operator": "and",
               {     "content": [
                          "type": "property",     {
                            "valueproperty": "transactions.identifier"zsj_desc.kod_zsj_d",
                            }"query": {
                       ]         "properties": [
          }                      ]    {
        }         ],         "options": {             "partitionByid": ["kod_zsj_d",
                "kod_zsj_d"
            ],             "sorttype": "descproperty",
        }     }
}
aggr_max_sum_accept_aggregate_by_store_1
Code Block
titleaggr_max_sum_accept_aggregate_by_store_1
{     "name": "aggr_max_sum_accept_aggregate_by_store_1",     "type": "metric",     "content": {         "typevalue": "function_max",zsj_desc.kod_zsj_d"
                  "content": [             {    },
            "type": "function_divide",                 "content": [     {
               {                         "typeid": "functiontransaction_sum",
                        "content": [               "type": "function_sum",
            {                                 "typecontent": [
"property",                                 "value": "transactions.value"          {
                  }                         ],     "type": "property",
                  "options": {                             "aggregateByvalue": ["transactions.value"
                                 "transactions.store_id"           }
                 ]                       ]
 }                     },              }
      {                         "type": "function_sum" ],
                        "content": [       "having": [
                     {               {
                 "type": "property",                      "propertyId": "transaction_sum",
         "value": "transactions.value"                             } "value": 120,
                      ],                  "operator": "lte"
     "options": {                             "aggregateBy": [}
                                "transactions.store_id"]
                            ]},
                            "acceptAggregateByoperator": ["inAttribute"
                        },
       "transactions"                 {
           ]                 "property": "zsj_desc.kod_zsj_d",
      }                     } "query": {
              ]             }     "properties": [
  ]     } } 
aggr_count_dist_by_customer_1
Code Block
titleaggr_count_dist_by_customer_1
{     "name": "aggr_count_dist_by_customer_1",     "type": "metric",     "content": {         "type": "function_count",{
         "content": [             {                 "typeid": "propertykod_zsj_d",
                "value": "transactions.processed_at"                }         ]"type": "property",
        "options": {             "aggregateBy": [                 "transactions.customer_idvalue": "zsj_desc.kod_zsj_d"
            ]         }     } } 
round_property_count_1
Code Block
titleround_property_count_1
{     "name": "round_property_count_1",  },
  "type": "metric",     "content": {         "type": "function_round",         "content": [       {
     {                 "type": "property",                 "valueid": "customers.lat"transaction_sum",
            }         ],         "options": {             "placestype": 1,
     "function_sum",
      "filterBy": [                 {                     "propertycontent": "transactions.value",
[
                   "value": 10,                     "operator": "gte"  {
              }             ]         }     } } 
round_property_count_2
Code Block
titleround_property_count_2
{     "nametype": "round_property_count_2",
    "type": "metric",       "content": {         "type": "function_round",         "content": [             {   "value": "transactions.value"
            "type": "property",                 "value": "customers.lng"             }
        ],            "options": {             "places": 1,     ]
       "filterBy": [                 {           }
         "property": "transactions.value",                     "value": 10],
                    "operator": "gte"           "having": [
    }             ]         }     } } 
round_property_count_3
Code Block
titleround_property_count_3
{   {
 "name": "round_property_count_3",     "type": "metric",     "content": {         "type": "function_sum",         "content": [      "propertyId": "transaction_sum",
     {                 "type": "property",                 "value": "transactions.value"95,
             }         ]     } } 
round_property_count_4
Code Block
titleround_property_count_4
{     "name": "round_property_count_4",     "typeoperator": "metricgte",
    "content": {         "type": "function_count",         "content": [             {}
                "type": "property",               ]
 "value": "customers.identifier"             }         ]     },
} 
having_boolean_1
Code Block
titlehaving_boolean_1
{     "name": "having_boolean_1",     "type": "metric",     "content": {         "typeoperator": "function_sum",inAttribute"
            "content": [           }
 {                 "type": "property", ]
               "value": "transactions.value" }
            }]
        ]}
    }
}
filter_by_

...

boolean_

...

or_

...

attribute_1
Code Block
titlefilter_by_attributeboolean_combinedor_cacheattribute_1
{
    "name": "filter_by_attributeboolean_combinedor_cacheattribute_1",
    "type": "metric",
    "content": {
        "type": "function_sum",
        "content": [
            {
                "type": "property",
                "value": "transactionszsj_desc.valuepopulation"
            }
        ],
        "options": {
            "withoutFilters": [
                "transactions.store_id"
            ],
            "filterBy": [
                {
                    "propertyoperator": "zsj_desc.kod_zsj_dor",
                    "query": {
                        "propertiescontent": [
                            {
                                "id": "kod_zsj_d",
                                "type": "property",
                                "value": "zsj_desc.kod_zsj_d"
,
                           }                         ],
                        "filterBy": [
                            {
"query": {
                               "property": "transactions.valueproperties",: [
                               "value": 45,    {
                            "operator": "gte"           "id": "kod_zsj_d",
                }                         ]
"type": "property",
                   },                     "operatorvalue": "inAttributezsj_desc.kod_zsj_d"
                },                   { },
                   "property": "transactions.value",                {
    "value": 25,                     "operator": "gte"             "id": "transaction_sum",
  },                 {                     "propertytype": "transactions.storefunction_idsum",
                    "value": 101,                     "operatorcontent": "ne" [
                           }             ]    {
    }     } } 
filter_by_1
Code Block
titlefilter_by_1
{     "name": "filter_by_1",     "type": "metric",     "content": {         "type": "function_sum",         "contenttype": ["property",
             {                 "type": "property",                 "value": "transactions.value"
            }         ]     } } 
filter_by_attribute_combined_1
Code Block
titlefilter_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"             ],
"having": [
           "filterBy": [                 {       {
             "property": "zsj_desc.kod_zsj_d",                     "query": {    "propertyId": "transaction_sum",
                   "properties": [                    "value": 72,
       {                                 "idoperator": "kod_zsj_d",lte"
                                  "type": "property", }
                               "value": "zsj_desc.kod_zsj_d" ]
                            },
                        ],    "operator": "inAttribute"
                   "filterBy": [    },
                        {
  
                             "property": "transactions.valuezsj_desc.kod_zsj_d",
                                "valuequery": 45,{
                                "operatorproperties": "gte" [
                                }    {
                    ]                     }"id": "kod_zsj_d",
                    "operator": "inAttribute"                     },"type": "property",
                   {                     "propertyvalue": "transactions.value",zsj_desc.kod_zsj_d"
                                   "value": 25},
                    "operator": "gte"                {
  },                 {                     "propertyid": "transactions.storetransaction_idsum",
                            "value            "type": 101"function_sum",
                    "operator": "ne"                 }  "content": [
         ]         }     } } 
aggr_sum_by_zsjd_of_max_plus_min_1
Code Block
titleaggr_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_sumproperty",
                "content": [                     {          "value": "transactions.value"
             "type": "function_max",                         "content": [    }
                        {                ]
                "type": "property",                   }
             "value": "transactions.value"                  ],
          }                      "having": [
 ],                         "options": {         {
                   "aggregateBy": [                    "propertyId": "transaction_sum",
           "transactions.store_id"                             ]
"value": 160,
                       }                 "operator": "gte"
  }                 ]             },    }
        {                 "type": "function_min",      ]
          "content": [                 },
   {                         "typeoperator": "propertyinAttribute",
                        "value": "transactions.value"}
                    ]
}                }
]            ]
}         ]}
    }
}

...

percentile_

...

1
Code Block
titlecan_2694percentile_1
{
    "name": "canpercentile_2694_1",
    "type": "metric",
    "content": {
        "type": "function_dividepercentile",
        "content": [
            {
                "type": "function_sum",
                "content": [
                    {
                        "type": "property",
                        "value": "transactions.value"
                    }
                ]
            }
        ],
        "options": {
            "sort": "desc"
        }
    }
}
percentile_2
Code Block
titlepercentile_2
{
    "name": "percentile_2",
    "type": "metric",
    "content": {
        "type": "function_sum",
           },"content": [
            {
                "type": "numberproperty",
                "value": 1000"transactions.0value"
            }
        ]
    }
}

...

percentile_

...

arithm_

...

1
Code Block
titlecanpercentile_2694arithm_21
{
    "name": "canpercentile_2694arithm_21",
    "type": "metric",
    "content": {
        "type": "function_sumpercentile",
        "content": [
            {
                "type": "propertyfunction_ifnull",
                "valuecontent": "transactions.value"
     [
      }         ],         "options": {
            "filterBy": [
            
   {                     "propertytype": "transactions.storefunction_iddivide",
                    "value": 100,   "content": [
                "operator": "eq"            {
    }             ]         }     } }
can_2694_3
Code Block
titlecan_2694_3
{
    "name"type": "canfunction_2694_3sum",
     "type": "metric",       "content": {         "type": "function_divide",         "content": [
            {                 "type": "function_sum",      {
          "content": [                     {        "type": "property",
               "type": "property",                         "value": "transactions.value"
                    }                }
]             },             {      ]
          "type": "function_sum",                 "content": [},
                     {       {
                 "type": "property",
                        "valuetype": "transactions.value"function_count",
                    }            "content": [
   ],                 "options": {               {
     "aggregateBy": [                         null                     ],
 "type": "property",
                  "withoutFilters": [                         "zsj_desc.kod_zsj_d"value": "transactions.customer_id"
                    ]                 }
            }         ]     } } 
can_2751_1
Code Block
titlecan_2751_1
{     "name": "can_2751_1",
    "type": "metric",]
       "content": {         "type": "function_sum",         "content": [}
            {            ]
    "type": "property",                 "value": "transactions.value"},
             }       {
 ],         "options": {             "filterBytype": ["number",
                {        "value": 0.0
           "property": "transactions.store_id",           }
         "value": 100,      ]
            }
 "operator": "eq"      ],
        "options": {
}             ]"sort": "desc"
        }
    }
}

...

percentile_

...

arithm_2
Code Block
titlecanpercentile_2751arithm_2
{
    "name": "canpercentile_2751arithm_2",
    "type": "metric",
    "content": {
        "type": "function_sumdivide",
        "content": [
            {
                "type": "propertyfunction_sum",
                "valuecontent": "zsj_desc.population" [
                  }  {
      ]     } } 
can_3062_1
Code Block
titlecan_3062_1
{     "name": "can_3062_1",     "type": "metricproperty",
    "content": {         "type": "function_sum",         "contentvalue": ["transactions.value"
             {       }
         "type": "property",      ]
          "value": "transactions.value" },
           } {
       ],         "optionstype": {"function_count",
                "filterBycontent": [
                    {
                        "propertytype": "transactions.valueproperty",
                        "value": "transactions.customer_id"
          "value": 100,         }
           "operator": "gt"    ]
            }
        ],
   ]     "options": {
  },          "_commentsort": "match only store=102"desc"
        }
    }
}

...

percentile_partition_

...

by_

...

1
Code Block
titlecanpercentile_partition_3062by_21
{
    "name": "canpercentile_partition_3062by_21",
    "type": "metric",
    "content": {
        "type": "function_sumpercentile",
        "content": [
            {
                "type": "propertyfunction_sum",
                "valuecontent": "transactions.value"[
             }       {
 ],         "options": {             "filterBytype": [
"property",
               {                     "property"value": "transactions.value",
                    "value": 75,}
                    "operator": "gt"
  ]
             }
 
          ]
        },
        "_commentoptions": "match stores=[100,102]"{
     } } 
can_3062_3
Code Block
titlecan_3062_3
{     "namepartitionBy": "can_3062_3",[
    "type": "metric",
    "content": {         "type": "functionkod_zsj_sumd",
        "content": [             {
                "type": "property",
],
               "valuesort": "transactions.valuedesc"
 
          }
    }
   ],
        "options": {
            "filterBy": [
    }
percentile_partition_by_2
Code Block
titlepercentile_partition_by_2
{
    "name": "percentile_partition_by_2",
    "type": "metric",
    "content": {
                    "property"type": "transactions.valuefunction_sum",
        "content":  [
         "value": 50,  {
                  "operatortype": "gtproperty",
                }
        "value": "transactions.value"
   ]         },

       "_comment": "match stores=[100,102]"
    }
}

...

percentile_same_

...

values_1
Code Block
titlecanpercentile_same_7610values_1
{
    "name": "canpercentile_same_7610values_1",
    "type": "metric",
    "content": {
        "type": "function_multiplypercentile",
        "content": [
            {
                "type": "function_sumcount",
                "content": [
                    {
                        "type": "property",
                        "value": "transactions.identifiercustomer_id"
                    }
                ]
            },
            {
     ],
          "typeoptions": "number",
 {
              "valuesort": 13.467
  "desc"
         }
        ]
    }
}

...

percentile_same_

...

values_2
Code Block
titlecanpercentile_same_7610values_2
{
    "name": "canpercentile_same_7610values_2",
    "type": "metric",
    "content": {
        "type": "function_pluscount",
        "content": [
            {
                "type": "numberproperty",
                "value": 13.467"transactions.customer_id"
            },
        ]
   { }
}
accept_filters_1
Code Block
titleaccept_filters_1
{
    "name": "accept_filters_1",
       "type": "function_summetric",
    "content": {
          "contenttype": ["function_sum",
        "content": [
          {  {
                      "type": "property",
                "value": "transactions.value"
      "value": "transactions.identifier"     }
        ],
      }  "options": {
             ]"acceptFilters": [
              }  "transactions.*"
      ]     } }
can_8366_1
Code Block
titlecan_8366_1
{],
      "name": "can_8366_1",     "typefilterBy": "metric",[
        "content": {       {
 "type": "function_max",         "content": [        "property": "transactions.store_id",
   {                 "typevalue": "property"100,
                    "valueoperator": "customers.identifiereq"
            }    },
    ]     } } 
can_8366_2
Code Block
titlecan_8366_2
{     "name": "can_8366_2", {
    "type": "metric",     "content": {         "typeproperty": "function_sumtransactions.value",
        "content": [            "value": 50,
   {                 "typeoperator": "propertygte",
                "value": "transactions.value"}
            ]
}         ]}
    }
}

...

accept_

...

filters_

...

2
Code Block
titlecanaccept_8477filters_12
{
    "name": "canaccept_8477filters_12",
    "type": "metric",
    "content": {
        "type": "function_dividesum",
        "content": [
            {
                "type": "function_sumproperty",
                "contentvalue": ["transactions.value"
            }
       { ],
        "options":  {
            "typeacceptFilters": "property",
        [
               "value": "transactions.valuestore_id"
                    }
                ]
            },
            {
                "type": "function_sum",
                "content": [
  "filterBy": [
                 {
                        "typeproperty": "property",
  transactions.store_id",
                     "value": "transactions.value" 100,
                     }"operator": "eq"
                ]},
                "options": {
                    "aggregateByproperty": ["transactions.value",
                    "value": 50,
  null                  "operator": "gte"
 ]                 }
            }]
        ]}
    }
}

...

accept_

...

filters_

...

3
Code Block
titleaggr_max_sum_accept_aggregatefilters_all_13
{
    "name": "aggr_max_sum_accept_aggregatefilters_all_13",
    "type": "metric",
    "content": {
        "type": "function_maxsum",
        "content": [
            {
                "type": "function_divideproperty",
                "contentvalue": ["transactions.value"
            }
       { ],
        "options": {
             "typeacceptFilters": [
              "function_sum",  "customers.*"
            ],
            "contentfilterBy": [
                {
           {         "property": "transactions.store_id",
                    "value": 100,
                    "typeoperator": "property",eq"
                },
                {
                    "valueproperty": "transactions.value",
                    "value": 50,
                    "operator": "gte"
                }
            ]
        }
    }
 ]}
accept_without_filters_1
Code Block
titleaccept_without_filters_1
{
    "name": "accept_without_filters_1",
    "type": "metric",
    "content": {
          "type": "function_sum",
        "optionscontent": {[
            {
                "aggregateBytype": ["property",
                "value": "transactions.value"
            }
 "transactions.store_id"       ],
        "options": {
           ] "acceptFilters": [
                "transactions.*"
     }       ],
             },"filterBy": [
                    {
                        "typeproperty": "functiontransactions.store_sumid",
                    "value": 100,
  "content": [                  "operator": "eq"
         {       },
                {
        "type": "property",           "property": "transactions.value",
                    "value": "transactions.value"50,
                    "operator": "gte"
      }          }
            ]
 ],       }
    }
}
accept_without_filters_2
Code Block
titleaccept_without_filters_2
{
    "name": "accept_without_filters_2",
    "optionstype": {"metric",
    "content": {
        "type": "function_sum",
            "aggregateBycontent": [
            {
                "type": "property",
    "transactions.store_id"            "value": "transactions.value"
            }
  ],      ],
        "options": {
            "acceptAggregateByacceptFilters": [
                "transactions.store_id"
            ],
  "*"          "filterBy": [
                {
]                    "property": "transactions.store_id",
   }                 "value": 100,
  }                 ] "operator": "eq"
          }      },
  ]      } } 
filter_pushdown_1
Code Block
titlefilter_pushdown_1
{     "name": "filter_pushdown_1", {
    "type": "metric",     "content": {         "typeproperty": "function_maxtransactions.value",
        "content": [            "value": 50,
   {                 "typeoperator": "propertygte",
                "value": "customers.identifier"}
            ]
}        }
]     }
}

...

accept_without_

...

filters_

...

3
Code Block
titlefilteraccept_without_pushdownfilters_23
{
    "name": "filteraccept_without_pushdownfilters_23",
    "type": "metric",
    "content": {
        "type": "function_sum",
        "content": [
            {
                "type": "property",
                "value": "transactions.value"
            }
        ],
      }
}
having_percent_turnover_1
Code Block
titlehaving_percent_turnover_1
{  "options": {
     "name": "having_percent_turnover_1",       "typewithoutFilters": "metric",[
     "content": {         "type": "function_dividecustomers.*",
        "content":  [      "transactions.store*"
      {      ],
            "typefilterBy": "function_sum",[
                "content":{
[                     {
  "property": "transactions.store_id",
                     "typevalue": "property"100,
                        "valueoperator": "transactions.valueeq"
                    },
                ]{
            },        "property": "transactions.value",
   {                 "typevalue": "number",50,
                    "valueoperator": 1000.0"gte"
                }
            ]
        }
    }
}

...

big_

...

numbers_

...

1
Code Block
titlehavingbig_percentnumbers_turnover_21
{
    "name": "havingbig_percentnumbers_turnover_21",
    "type": "metric",,
    "content": {
        "type": "function_sum",
        "content": [
            {
      "content": {         "type": "function_summultiply",
                "content": [
            {        {
        "type": "property",                 "valuetype": "transactions.value"property",
               }         "value": "transactions.value"
],         "options": {          },
  "filterBy": [                 {
                        "propertytype": "transactions.store_idnumber",
                        "value": 100,1.0E9
                    "operator": "eq"}
                ]
}            }
]         }]
    }
}

...

big_

...

numbers_

...

2
Code Block
titlehavingbig_percentnumbers_turnover_32
{
    "name": "havingbig_percentnumbers_turnover_32",
    "type": "metric",
    "content": {
        "type": "function_dividemultiply",
        "content": [
            {
                "type": "function_sum",
                "content": [
                    {
                        "type": "property",
                        "value": "transactions.value"
                    }
                ]
            },
            {
                "type": "number",
                "value": 4.56789123435E9
            }
        ],
        "_comment": "returns the first 12 digits, without decimal part"
    }
}
big_numbers_3
Code Block
titlebig_numbers_3
{
    "name": "big_numbers_3",
    "type": "metric",
    "content": {
      ]  "type": "function_multiply",
         },"content": [
            {
                "type": "function_sum",
                "content": [
                    {
                        "type": "property",
                        "value": "transactions.value"
                    }
                ],
            },
   "options": {        {
            "aggregateBy": [   "type": "number",
                "value": 6.789123435E7
  null          }
          ],
        "_comment": "returns the first 12 digits, with  }
            }
        ]decimal part"
      }
}

...

filter_by_

...

date_

...

1
Code Block
titleaggrfilter_max_by_store_by_clientdate_1
{
    "name": "aggrfilter_max_by_storedate_by_client_1",
    "type": "metric",
    "content": {
        "type": "function_maxsum",
        "content": [
            {
                "type": "function_divideproperty",
                "contentvalue": ["transactions.value"
            }
       { ]
    }
}
filter_by_not_in_attribute_1
Code Block
titlefilter_by_not_in_attribute_1
{
    "name": "filter_by_not_in_attribute_1",
          "type": "function_sum",
                  metric",
     "content": [
                            {
   
                            "type": "propertyfunction_sum",
                                "value"content": "transactions.value"[
                            }
              {
         ],       "type": "property",
                "optionsvalue": {"zsj_desc.population"
            }
        ],
        "aggregateByoptions": [{
            "withoutFilters": [
                  "transactions.store_id"
            ],
            "filterBy": [
 ]               {
         }           "property": "zsj_desc.kod_zsj_d",
        },            "query": {
       {                 "properties": [
      "type": "function_count",                     {
   "content": [                             {"id": "kod_zsj_d",
                                "type": "property",
                                "value": "transactions.identifierzsj_desc.kod_zsj_d"
                            }
                        ],
                    },
   "options": {                "operator": "notInAttribute"
           "aggregateBy": [    },
                {
           "zsj_desc.kod_zsj_d"         "property": "transactions.store_id",
                  ],  "value": 101,
                         "filterByoperator": ["eq"
                }
            ]
  {      }
    }
}
having_filter_count_by_decimal_1
Code Block
titlehaving_filter_count_by_decimal_1
{
    "name": "having_filter_count_by_decimal_1",
                 "property"type": "transactions.customer_idmetric",
    "content": {
        "type": "function_count",
        "content": [
          "value": 2002, {
                "type": "property",
                 "operatorvalue": "eqtransactions.identifier"
            }
        ]
    }
     }
}
filter_by_function_1
Code Block
titlefilter_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
Code Block
titlerankfilter_by_withfunction_filtertoday_1
{
    "name": "rankfilter_by_withfunction_filtertoday_1",
    "type": "metric",
    "content": {
        "type": "function_ranksum",
        "content": [
            {
                "type": "function_sumproperty",
                "contentvalue": ["transactions.value"
            }
       { ]
    }
}
filter_by_function_date_trunc_1
Code Block
titlefilter_by_function_date_trunc_1
{
       "name": "filter_by_function_date_trunc_1",
        "type": "propertymetric",
    "content": {
        "type": "function_sum",
        "valuecontent": "transactions.value"[
            {
       }                 ]"type": "property",
                "optionsvalue": {"transactions.value"
            }
       "withoutFilters": []
    }
}
filter_by_function_interval_1
Code Block
titlefilter_by_function_interval_1
{
    "name": "filter_by_function_interval_1",
    "type": "metric",
     "*.*content": {
        "type": "function_sum",
        "content": ][
            {
   }             }
"type": "property",
       ],         "optionsvalue": {"transactions.value"
            "sort": "desc",}
        ]
    "filterBy": [
      }
}
accept_aggr_by_1
Code Block
titleaccept_aggr_by_1
{
    "name": "accept_aggr_by_1",
   { "type": "metric",
    "content": {
            "propertytype": "transactions.storefunction_idsum",
           
        "valuecontent": [
            {
           100,     "type": "property",
                "value": "transactions.value"
101            }
        ],
        "options": {
            "operatoracceptAggregateBy": "in"[
                }"zsj_desc"
            ]
        }
    }
}

...

accept_

...

aggr_

...

by_2
Code Block
titlerankaccept_withaggr_filterby_2
{
    "name": "rankaccept_withaggr_filterby_2",
    "type": "metric",
    "content": {
        "type": "function_sumcount",
        "content": [
            {
                "type": "property",
                "value": "transactions.valueidentifier"
            }
        ],
        "options": {
            "withoutFiltersacceptAggregateBy": [
                "*.zsj*"
            ]
        }
    }
}
accept_aggr_by_3
Code Block
titleaccept_aggr_by_3
{
    "name": "accept_aggr_by_3",
    "type": "metric",
    "content": {
        "type": "function_count",
        "filterBycontent": [
            {
     {           "type": "property",
                "propertyvalue": "transactions.store_id",
            }
        ],
        "valueoptions": [{
            "dontAggregateBy": [
          100,      "customers"
            ]
     101   }
    }
}
accept_aggr_by_null_1
Code Block
titleaccept_aggr_by_null_1
{
    "name": "accept_aggr_by_null_1",
    "type": "metric",
    ],
"content": {
          "type": "function_sum",
        "operatorcontent": "in"[
            {
   }             ]
"type": "property",
       }     }
}
rank_with_filter_3
Code Block
titlerank_with_filter_3
{     "namevalue": "rank_with_filter_3",transactions.value"
    "type": "metric",     "content": { }
       "type": "function_sum" ],
        "contentoptions": [{
            {"acceptAggregateBy": [
               "type": "propertyzsj_desc",
                "value": "transactions.value"null
            ]
}         ]}
    }
}

...

accept_aggr_by_null_2
Code Block
titlelocal_filter_1accept_aggr_by_null_2
{
    "name": "local_filter_1accept_aggr_by_null_2",
    "type": "metric",
    "content": {
        "type": "function_sumcount",
        "content": [
            {
                "type": "property",
                "value": "transactions.valueidentifier"
            }
        ],
        "options": {
            "filterByacceptAggregateBy": [
                {null
            ]
       "property": "transactions.store_id", }
    }
}
filter_by_attribute_two_filters_nested_1
Code Block
titlefilter_by_attribute_two_filters_nested_1
{
    "name": "filter_by_attribute_two_filters_nested_1",
       "valuetype": 100"metric",
        "content": {
           "operatortype": "eqfunction_sum",
            "content": [
   },                 {
 
                  "propertytype": "transactions.valueproperty",
   
                "value": 35.2,
                    "operator": "gt"
              "transactions.value"
  }          }
  ]         }]
    }
}

...

filter_by_attribute_two_filters_nested_to_metric_1
Code Block
titlelocal_filter_2filter_by_attribute_two_filters_nested_to_metric_1
{
    "name": "local_filter_2filter_by_attribute_two_filters_nested_to_metric_1",
    "type": "metric",
    "content": {
        "type": "function_sum",
        "content": [
            {
                "type": "property",
                "value": "transactions.value"
            }
        ],
     }
}
sort_combined_1
Code Block
titlesort_combined_1
{   "options": {
            "namefilterBy": "sort_combined_1",[
         "type": "metric",     "content": {
                    "typeproperty": "function_sumzsj_desc.kod_zsj_d",
         "content           "query": [{
               {         "properties": [
      "type": "property",                    "value": "transactions.value" {
           }         ]     } } 
aggr_sum_of_max_by_store_filter_1
Code Block
titleaggr_sum_of_max_by_store_filter_1
{     "nameid": "aggrkod_sum_of_max_by_store_filter_1zsj_d",
      "type": "metric",     "content": {         "type": "function_sum",         "contenttype": ["property",
               {                 "typevalue": "function_max",zsj_desc.kod_zsj_d"
                            },
             "content":  [             {
       {                         "typeid": "propertypopulation_where_store_id_ne_101",
                        "value        "type": "transactions.value"function_sum",
                    }            "content": [
      ],                 "options": {            {
        "aggregateBy": [                         "transactions.store_id",      "type": "property",
                 "transactions.customer_id"                     ],  "value": "zsj_desc.population"
                 "filterBy": [                  }
      {                          ],
  "property": "transactions.store_id",                             "valueoptions": 102,{
                            "operator": "ne"       "filterBy":  [
               }                     ]    {
            }             }         ]     } } 
filter_by_metric_inherit_granularities_dont_1
Code Block
titlefilter_by_metric_inherit_granularities_dont_1
{     "nameproperty": "filterzsj_bydesc.kod_metric_inherit_granularities_dont_1zsj_d",
    "type": "metric",       "content": {         "type": "function_sum",         "content": [            "query": {
                "type": "property",                 "value": "transactions.value"             }"properties": [
       ],         "options": {             "withoutFilters": [                 "transactions.processed_at"      {
      ],             "filterBy": [                 {                     "propertyid": "transactions.processed_atkod_zsj_d",
                    "query": {                               "properties": [    "type": "property",
                       {                                 "idvalue": "max_date",zsj_desc.kod_zsj_d"
                                                 "type": "function_max",  },
                              "content": [                     {
               {                                         "typeid": "propertyaux_metric",
                                         "value               "type": "transactions.processedfunction_atcount",
                                    }                    "content": [
            ],                                 "options": {              {
                      "dontAggregateBy": [                                         "customers"type": "property",
                                    ]                            "value": "zsj_desc.kod_zsj_d"
   }                             }                         ]   }
                 },                     "operator": "inAttribute"                 }],
                {                     "property": "transactions.processed_at",
                    "valueoptions": "2015-11-01",{
                    "operator": "gte"                 },                 {     "withoutFilters": [
              "property": "transactions.processed_at",                     "value": "2015-11-07",                     "operator": "lt"     "*.*"
           }             ]         }     } } 
aggr_sum_of_max_multiply_min_1
Code Block
titleaggr_sum_of_max_multiply_min_1
{     "name": "aggr_sum_of_max_multiply_min_1",     "type": "metric",     "content": {  ],
      "type": "function_sum",         "content": [             {                 "type": "function_multiply",                 "contentfilterBy": [
                    {                         "type": "function_max",                  {
      "content": [                             {                                 "typeproperty": "propertytransactions.store_id",
    
                           "value": "transactions.value"                               }                        "value": ]101,
                         "options":  {                             "aggregateBy": [           "operator": "eq"
                    "zsj_desc.kod_zsj_d"                             ]               }
         }                     },                     {         ]
               "type": "function_min",                         "content": [              }
              {                                 "type": "property",    }
                            "value": "transactions.value"                   ]
         }                         ],          },
              "options": {                             "aggregateByoperator": ["inAttribute"
                                "transactions.store_id"        }
                    ]                ]
        }                     }   }
             ]             }  }
      ]     } }
sort_null_inverse_1
Code Block
titlesort_null_inverse_1
{     "name": "sort_null_inverse_1",     "type": "metric" ],
    "content": {         "type": "function_plus",         "contenthaving": [
            {                {
 "type": "function_ifnull",                 "content": [            "propertyId": "population_where_store_id_ne_101",
       {                         "typevalue": "function_sum"500,
                         "content       "operator": ["gte"
                            {}
                        ]
       "type": "property",            },
                    "valueoperator": "transactions.valueinAttribute"
                }
           } ]
        }
    }
}
filter_by_attribute_two_filters_one_skippable_1
Code Block
titlefilter_by_attribute_two_filters_one_skippable_1
{
       ],
            "name": "filter_by_attribute_two_filters_one_skippable_1",
    "type": "metric",
     "optionscontent": {
        "type": "function_sum",
        "content": [
        "filterBy": [   {
                "type": "property",
           {     "value": "transactions.value"
            }
        ],
        "propertyoptions": "transactions.store_id",{
            "filterBy": [
                {
     "value": 101,              "property": "zsj_desc.kod_zsj_d",
                     "operatorquery": {
"eq"                        "properties": [
       }                     {
        ]                         }"id": "kod_zsj_d",
                    },            "type": "property",
       {                         "typevalue": "number",zsj_desc.kod_zsj_d"
                        "value": 0.0   },
                 }           {
     ]             },             { "id": "population_where_store_id_ne_101",
              "type": "function_sum",                 "contenttype": ["function_sum",
                    {            "content": [
           "type": "property",                         {
  "value": "transactions.value"                     }                 ]"type": "property",
                "options": {                        "filterByvalue": ["zsj_desc.population"
                        {            }
                "property": "transactions.store_id",               ],
             "value": 102,                  "options": {
         "operator": "eq"                         } "filterBy": [
                  ]                 }     {
       }         ]     } } 
sort_null_inverse_2
Code Block
titlesort_null_inverse_2
{
    "name": "sort_null_inverse_2",
    "type": "metric",        "content": {         "typeproperty": "function_percentilezsj_desc.kod_zsj_d",
           "content": [                {                 "typequery": "function_plus", {
                       "content": [                     {   "properties": [
                    "type": "function_ifnull",                         "content": [     {
                       {                                 "typeid": "functionkod_zsj_sumd",
                                   "content": [                    "type": "property",
               {                                         "typevalue": "property",zsj_desc.kod_zsj_d"
                                                 "value": "transactions.value"  },
                                  }                  {
              ],                                 "options": {        "id": "aux_metric",
                           "filterBy": [                            "type": "function_count",
           {                                             "propertycontent": "transactions.store_id",[
                                            "value": 101,               {
                             "operator": "eq"                                  "type": "property",
     }                                     ]                      "value": "zsj_desc.kod_zsj_d"
         }                             },                      }
      {                                 "type": "number",                ],
                "value": 0.0                             }          "options": {
             ]                     },                     {     "withoutFilters": [
                  "type": "function_sum",                         "content": [                   "*.*"
         {                                 "type": "property",                 ]
               "value": "transactions.value"                             }           }
             ],                         "options": {             }
               "filterBy": [                                ]
{                                     "property": "transactions.store_id",        },
                            "value": 102,               "operator": "inAttribute",
                    "operator": "eq"                       "_comment": "this attribute filter shloud be skipped, it has no }filters"
                            ]            }
            }                     }   ]
             ]             }      }
  ],         "options": {             "sort": "asc"   }
     }     } } 
sort_null_inverse_3
Code Block
titlesort_null_inverse_3
{     "name": "sort_null_inverse_3",     "type": "metric" ],
    "content": {         "type": "function_rank",         "contenthaving": [
            {                {
"type": "function_plus",                   "content": [            "propertyId": "population_where_store_id_ne_101",
       {                         "typevalue": "function_ifnull"500,
                        "content        "operator": ["gte"
                            {}
                        ]
       "type": "function_sum",            },
                    "contentoperator": ["inAttribute"
                }
            ]
      {  }
    }
}
filter_by_attribute_two_filters_flat_1
Code Block
titlefilter_by_attribute_two_filters_flat_1
{
    "name": "filter_by_attribute_two_filters_flat_1",
    "type": "metric",
          "content": {
        "type": "propertyfunction_sum",
        "content": [
             {
                "valuetype": "transactions.valueproperty",
                "value": "transactions.value"
            }
     }   ],
        "options": {
            "filterBy": [
     ],            {
                    "optionsproperty": {
             "zsj_desc.kod_zsj_d",
                      "filterByquery": {
 [                       "properties": [
                {            {
                                "propertyid": "transactions.store_idkod_zsj_d",
                                "type": "property",
            "value": 101,                   "value": "zsj_desc.kod_zsj_d"
                        "operator": "eq"   },
                            {
        }                        "id": "population_where_store_id_ne_101",
           ]                     "type": "function_sum",
          }                      "content": [
     },                             {  {
                              "type": "number",         "type": "property",
                      "value": 0.0                 "value": "zsj_desc.population"
          }                         ] }
                   },             ],
       {                         "typeoptions": "function_sum",{
                        "content": [           "withoutFilters": [
                {                        "zsjd_desc.*"
        "type": "property",                           ]
     "value": "transactions.value"
                            }
                        ],    }
                    "options": {    ],
                        "filterByhaving": [
  
                             {
 
                                  "propertypropertyId": "transactions.population_where_store_id_ne_101",
                                    "value": 102500,
 
                                  "operator": "eqgte"
                            }
   }                     ]
       ]             },
           }         "operator": "inAttribute"
                },
                ]{
            }         ]"property": "zsj_desc.kod_zsj_d",
        "options": {             "sortquery": {
 "asc"         }     } }
filter_by_attribute_two_filters_nested_to_metric_1
Code Block
titlefilter_by_attribute_two_filters_nested_to_metric_1
{        "nameproperties": "filter_by_attribute_two_filters_nested_to_metric_1", [
                     "type": "metric",     "content": {
          "type": "function_sum",                      "contentid": [ "kod_zsj_d",
               {                 "type": "property",
                                "value": "transactions.value"zsj_desc.kod_zsj_d"
                }            ]},
        "options": {             "filterBy": [     {
           {                     "propertyid": "zsj_desc.kod_zsj_daux_metric",
                    "query": {           "type": "function_count",
             "properties":  [                 "content": [
          {                          {
      "id": "kod_zsj_d",                                 "type": "property",
                                        "value": "zsj_desc.kod_zsj_d"
                            },        }
                    {            ],
                    "id": "population_where_store_id_ne_101",           "options": {
                    "type": "function_sum",               "withoutFilters": [
                "content": [                       "zsjd_desc.*"
             {                       ]
                 "type": "property",              }
                          "value": "zsj_desc.population" }
                        ],
          }              "filterBy": [
                 ],           {
                     "options": {          "property": "transactions.store_id",
                         "filterBy":  [     "value": 101,
                                "operator": "eq"
{                            }
                "property": "zsj_desc.kod_zsj_d",        ]
                    },
                    "queryoperator": {"inAttribute"
                }
            ]
        }
    }
}
skip_in_attribute_filter_1
Code Block
titleskip_in_attribute_filter_1
{
    "propertiesname": ["skip_in_attribute_filter_1",
    "type": "metric",
    "content": {
        "type": "function_sum",
        "content": [
            {
         {       "type": "property",
                "value": "transactions.value"
            }
        ],
        "idoptions": "kod_zsj_d",{
            "filterBy": [
                     {
                    "typeproperty": "propertyzsj_desc.kod_zsj_d",
                    "query": {
                        "properties": [
        "value": "zsj_desc.kod_zsj_d"                   {
                                 }"id": "kod_zsj_d",
                                "type": "property",
                  {              "value": "zsj_desc.kod_zsj_d"
                            }
            "id": "aux_metric",           ]
                      },
                      "typeoperator": "function_countinAttribute",
                }
            ]
        }
    }
}
row_number_zsjd_store_by_revenue_1
Code Block
titlerow_number_zsjd_store_by_revenue_1
{
    "name": "row_number_zsjd_store_by_revenue_1",
    "contenttype": ["metric",
    "content": {
        "type": "function_row_number",
        "content": [
            {
                     {"type": "function_sum",
                "content": [
                    {
                         "type": "property",
                        "value": "transactions.value"
                    }
                ]
"value": "zsj_desc.kod_zsj_d"           }
        ],
        "options": {
            "partitionBy": [
                }"kod_zsj_d"
            ],
            "sort": "desc"
        }
    }
}
row_number_zsjd_store_avg_transaction_1
Code Block
titlerow_number_zsjd_store_avg_transaction_1
{
    "name": "row_number_zsjd_store_avg_transaction_1",
       ]"type": "metric",
    "content": {
        "type": "function_row_number",
        "content": [
            {
                "type": "options": {function_divide",
                "content": [
                    {
                        "withoutFilterstype": ["function_sum",
                        "content": [
                            {
         "*.*"                       "type": "property",
                                "value": "transactions.value"
  ],                          }
                        ],
         "filterBy": [              "options": {
                            "filterBy": [
                   {             {
                                    "property": "transactions.value",
                 "property": "transactions.store_id",                  "value": 0,
                                    "operator": "gte"
           "value": 101,                    }
                            ]
                   "operator": "eq"    }
                    },
                    {
                  }      "type": "function_count",
                        "content": [
                           ] {
                                "type": "property",
                     }           "value": "transactions.identifier"
                            }
             }           ]
                    }
                ]
            }
        ],
        "options": {
            },
 "partitionBy": [
                "kod_zsj_d"
            ],
            "operatorsort": "inAttributedesc"
        }
    }
}
row_number_store_by_transaction_count_1
Code Block
titlerow_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"
             "having": [      }
                ]
     {       }
        ],
                "propertyId": "population_where_store_id_ne_101","options": {
            "sort": "desc"
        }
    }
}
can_7610_1
Code Block
titlecan_7610_1
{
    "valuename": 500"can_7610_1",
    "type": "metric",
    "content": {
           "type": "function_multiply",
        "operatorcontent": "gte"[
            {
               } "type": "function_sum",
                "content": [
    ]                {
    },                     "operatortype": "inAttributeproperty",
                }        "value": "transactions.identifier"
   ]         }     } } 
without_1
Code Block
titlewithout_1
{
    "name": "without_1",
    "type": "metric", }
       "content": {        ]
"type": "function_sum",           "content": [ },
            {
                "type": "propertynumber",
                "value": "transactions13.value"467
            }
        ]
    }
}

...

can_7610_2
Code Block
titlewithoutcan_7610_2
{
    "name": "withoutcan_7610_2",
    "type": "metric",
    "content": {
        "type": "function_sumplus",
        "content": [
            {
                "type": "propertynumber",
                "value": "transactions13.value"467
            }
 ,
      ],      {
  "options": {             "withoutFilterstype": [
                "transactions.store_id""function_sum",
            ],    "content":  [
      "filterBy": [             {
   {                     "propertytype": "transactions.store_idproperty",
                        "value": 100,"transactions.identifier"
                    "operator": "eq"}
                ]
}             ]}
        }]
    }
}

...

filter_by_attribute_combined_1
Code Block
titlewithout_3filter_by_attribute_combined_1
{
    "name": "without_3filter_by_attribute_combined_1",
    "type": "metric",
    "content": {
        "type": "function_sum",
        "content": [
            {
                "type": "property",
                "value": "transactions.value"
            }
        ],
        "options": {
            "withoutFilters": [
                "trans*transactions.*store_id"
            ],
            "filterBy": [
                {
                    "property": "transactions.store_idzsj_desc.kod_zsj_d",
                    "valuequery": 100,{
                    "operator": "eq"    "properties": [
           }             ]    {
    }     }
}
skip_in_attribute_filter_1
Code Block
titleskip_in_attribute_filter_1
{     "name": "skip_in_attribute_filter_1",     "type": "metric",     "content": {         "typeid": "functionkod_zsj_sumd",
   
    "content": [             {                 "type": "property",
                "value": "transactions.value"             }         ],
        "options": {
            "filterBy": [
    "value": "zsj_desc.kod_zsj_d"
            {                   }
 "property": "zsj_desc.kod_zsj_d",                     "query": { ],
                        "propertiesfilterBy": [
                            {
                                "idproperty": "kod_zsj_dtransactions.value",
                                "typevalue": "property"45,
                                "valueoperator": "zsj_desc.kod_zsj_dgte"
                            }
                        ]
                    },
                    "operator": "inAttribute"
                },
               ] {
        }     } } 
filter_by_attribute_1
Code Block
titlefilter_by_attribute_1
{     "nameproperty": "filter_by_attribute_1transactions.value",
       "type             "value": "metric",25,
         "content":  {         "typeoperator": "function_sum",gte"
                 "content": [},
                {
                    "typeproperty": "propertytransactions.store_id",
                    "value": "zsj_desc.population"101,
                    "operator": "ne"
                }
            ]
        }
    }
}
filter_by_attribute_combined_cache_

...

1
Code Block
titlefilter_by_attribute_2combined_cache_1
{
    "name": "filter_by_attribute_2combined_cache_1",
    "type": "metric",
    "content": {
        "type": "function_sum",
        "content": [
            {
                "type": "property",
                "value": "zsj_desctransactions.populationvalue"
            }
        ],
        "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": [
               "operator": "inAttribute"                 },
 {
              {                     "property": "transactions.store_idvalue",
                    "value": 101,                     "operator"value": "ne"45,
                }             ]         }"operator": "gte"
    } }
filter_by_attribute_3
Code Block
titlefilter_by_attribute_3
{       "name": "filter_by_attribute_3",     "type": "metric",     "content": {     }
   "type": "function_sum",         "content": [          ]
  {                 "type": "property", },
                    "valueoperator": "zsj_desc.populationinAttribute"
                },
        ],        {
      "options": {             "withoutFiltersproperty": ["transactions.value",
                "transactions.store_id"    "value": 25,
       ],             "filterByoperator": [ "gte"
                },
                {
                    "property": "zsj_desctransactions.kodstore_zsj_did",
                    "queryvalue": {101,
                    "operator": "ne"
   "properties": [             }
            ]
        {}
    }
}
filter_pushdown_1
Code Block
titlefilter_pushdown_1
{
    "name": "filter_pushdown_1",
    "type": "metric",
    "content": {
        "idtype": "kodfunction_zsj_dmax",
        "content": [
            {
                "type": "property",
                "value": "customers.identifier"
            }
      "value": "zsj_desc.kod_zsj_d"  ]
    }
}
filter_pushdown_2
Code Block
titlefilter_pushdown_2
{
    "name": "filter_pushdown_2",
    "type": "metric",
    "content": {
    }    "type": "function_sum",
        "content": [
         ]   {
                 },
  "type": "property",
                 "operatorvalue": "inAttributetransactions.value"
            }
   },     ]
    }
}
filter_pushdown_2_1
Code Block
titlefilter_pushdown_2_1
{
    { "name": "filter_pushdown_2_1",
    "type": "metric",
    "content": {
        "propertytype": "transactions.storefunction_idsum",
        "content":  [
         "value": 101,    {
                "operatortype": "neproperty",
                 },"value": "customers.identifier"
            }
     {   ]
    }
}
filter_pushdown_2_2
Code Block
titlefilter_pushdown_2_2
{
    "name": "filter_pushdown_2_2",
    "propertytype": "transactions.store_idmetric",
    "content": {
        "type": "function_sum",
        "valuecontent": 101, [
            {
                "operatortype": "neproperty",
                }"value": "transactions.value"
            ]}
        }]
    }
}

...

aggr_by_

...

customer_

...

1
Code Block
titlefilteraggr_by_attributecustomer_41
{
    "name": "filteraggr_by_attributecustomer_41",
    "type": "metric",
    "content": {
        "type": "function_sum",
        "content": [
            {
                "type": "property",
                "value": "zsj_desctransactions.populationvalue"
            }
        ],
        "options": {
            "withoutFiltersaggregateBy": [
                "transactions.storecustomer_id"
            ],
   
        }
    }
}
aggr_by_customer_2
Code Block
titleaggr_by_customer_2
{
    "name": "aggr_by_customer_2",
    "type": "metric",
    "content": {
        "type": "function_sum",
        "filterBycontent": [
                {
  
                 "propertytype": "zsj_desc.kod_zsj_dproperty",
                "value": "transactions.value"
  "query": {          }
        ],
        "propertiesoptions": [{
            "aggregateBy": [
               { "transactions.store_id"
            ]
        }
    }
}
aggr_by_customer_3
Code Block
titleaggr_by_customer_3
{
    "idname": "kodaggr_by_zsjcustomer_d3",
    "type": "metric",
    "content": {
           "type": "function_sum",
        "typecontent": "property",[
            {
                   "valuetype": "zsj_desc.kod_zsj_d"property",
                "value": "transactions.value"
          },  }
        ],
                 "options": {
            "aggregateBy": [
                null
 "id": "transaction_sum",          ]
        }
    }
  }
aggr_sum_of_max_by_store_1
Code Block
titleaggr_sum_of_max_by_store_1
{
     "typename": "functionaggr_sum_of_max_by_store_1",
    "type": "metric",
    "content": {
           "type": "function_sum",
        "content": [
            {
                "type": "function_max",
     {           "content": [
                    {
       "type": "property",                "type": "property",
                        "value": "transactions.value"
                                    }
    
                           ]
    ],
                "options": {
     }               "aggregateBy": [
        ],                "transactions.store_id"
        "having": [           ]
                }
{            }
        ]
    }
}
aggr_sum_of_max_by_store_customer_1
Code Block
titleaggr_sum_of_max_by_store_customer_1
{
    "propertyIdname": "transactionaggr_sum_of_max_by_store_customer_1",
    "type": "metric",
    "content": {
           "type": "function_sum",
        "valuecontent": 70,[
            {
                   "operatortype": "gtfunction_max",
                "content": [
          }          {
              ]          "type": "property",
         },                     "operator"value": "inAttributetransactions.value"
                },    }
            {    ],
                "propertyoptions": "transactions.store_id",{
                    "valueaggregateBy": 101,[
                    "operator": "ne"   "transactions.store_id",
             }           "transactions.customer_id"
 ]         }     } } 
filter_by_attribute_5
Code Block
titlefilter_by_attribute_5
{   ]
 "name": "filter_by_attribute_5",     "type": "metric",     "content": {  }
      "type": "function_sum",     }
   "content": [    ]
    }
   }
aggr_sum_of_max_by_store_filter_1
Code Block
titleaggr_sum_of_max_by_store_filter_1
{
           "name": "aggr_sum_of_max_by_store_filter_1",
    "type": "propertymetric",
    "content": {
          "valuetype": "zsjfunction_desc.population"
            }
        ]sum",
        "optionscontent": {[
            "withoutFilters":{
[                "type": "transactions.storefunction_idmax",
            ],    "content": [
       "filterBy": [            {
    {                     "propertytype": "zsj_desc.kod_zsj_dproperty",
                    "query": {   "value": "transactions.value"
                    "properties":}
[                ],
            {    "options": {
                           "id"aggregateBy": "kod_zsj_d",
       [
                        "type": "property",transactions.store_id",
                        "transactions.customer_id"
        "value": "zsj_desc.kod_zsj_d"           ],
                 },   "filterBy": [
                        {

                               "idproperty": "transactiontransactions.store_sumid",
                                "typevalue": "function_sum"102,

                               "contentoperator": ["ne"
                        }
           {         ]
                }
            }
 "type": "property",      ]
    }
}
aggr_sum_by_store_of_max_by_customer_1
Code Block
titleaggr_sum_by_store_of_max_by_customer_1
{
                           "value": "transactions.value"
                   "name": "aggr_sum_by_store_of_max_by_customer_1",
    "type": "metric",
    "content": {
    }    "type": "function_sum",
        "content": [
            {
    ],               "type": "function_max",
                 "optionscontent": {[
                    {
               "withoutFilters": [        "type": "property",
                               "value": "transactions.store_idvalue"
                    }
                ],
                "options": {
              }      "aggregateBy": [
                     }   "transactions.store_id"
                     ],
                }
       "having": [    }
        ]
    }
          }
aggr_sum_of_max_by_zsjd_1
Code Block
titleaggr_sum_of_max_by_zsjd_1
{
    "name": "aggr_sum_of_max_by_zsjd_1",
    "type": "metric",
    "content": {
              "propertyId"type": "transactionfunction_sum",
        "content": [
            {
         "value": 70,                "type": "function_max",
                "operatorcontent": "gt"[
                    {
       }                 "type": "property",
      ]                  "value": "transactions.value"
 },                   }
 "operator": "inAttribute"               ],
 },               "options":  {
                    "propertyaggregateBy": "transactions.store_id",[
                        "value": 101,zsj_desc.kod_zsj_d"
                    ]
"operator": "ne"                 }
            ]}
        }]
    }
}
aggr_

...

sum_

...

of_

...

max_

...

multiply_

...

number_

...

1
Code Block
titleaggr_max_sum_acceptof_aggregate_by_store_one_aggmax_multiply_number_1
{
    "name": "aggr_max_sum_acceptof_aggregatemax_bymultiply_store_onenumber_agg_1",
    "type": "metric",
    "content": {
        "type": "function_maxsum",
        "content": [
            {
                "type": "function_summultiply",
                "content": [
                    {
                        "type": "propertynumber",
                        "value": "transactions1000.value"0
                    },
                ],              {
  "options": {                     "aggregateBytype": [
                        "transactions.store_id"
                "function_max",
   ],                     "acceptAggregateBycontent": [
                        "transactions"    {
                ]                 }"type": "property",
            }         ]     } }
aggr_max_sum_dont_aggregate_by_store_1
Code Block
titleaggr_max_sum_dont_aggregate_by_store_1
{     "namevalue": "aggr_max_sum_dont_aggregate_by_store_1",transactions.value"
    "type": "metric",     "content": {         "type": "function_max",       }
 "content": [             {          ],
      "type": "function_divide",                 "contentoptions": [
{
                   {                         "type"aggregateBy": "function_sum",[
                        "content": [       "transactions.store_id"
                     {       ]
                        }
"type": "property",                   }
             "value": "transactions.value"  ]
            }
        ]
    }
}
aggr_sum_of_max_multiply_min_1
Code Block
titleaggr_sum_of_max_multiply_min_1
{
        "name": "aggr_sum_of_max_multiply_min_1",
             ]"type": "metric",
    "content": {
        "type": "function_sum",
        "optionscontent": {[
            {
                "aggregateBytype": ["function_multiply",
                "content": [
              "transactions.store_id"      {
                      ]  "type": "function_max",
                     }   "content": [
                },             {
       {                         "type": "function_sumproperty",
                        "content": [       "value": "transactions.value"
                    {        }
                        "type": "property"],
                        "options": {
      "value": "transactions.value"                     "aggregateBy": [
      }                         ],
 "zsj_desc.kod_zsj_d"
                       "options": {    ]
                        "aggregateBy":}
[                    },
            "transactions.store_id"        {
                    ],    "type": "function_min",
                        "dontAggregateBycontent": [
                            {
   "zsj_*"                             "type": "property",
  ]                         }     "value": "transactions.value"
              }              }
  ]             }         ],
    }  } 
filter_property_in_limit_1
Code Block
titlefilter_property_in_limit_1
{     "name": "filter_property_in_limit_1",     "type": "metric",     "contentoptions": {
        "type": "function_sum",         "content": [         "aggregateBy": [
  {                 "type": "property",                 "value": "transactions.valuestore_id"
            }         ],         "options":]
{             "withoutFilters": [          }
      "zsj_desc.*"             ], }
           "filterBy": [    ]
            {}
        ]
    }
}
aggr_sum_by_customer_of_max_multiply_min_1
Code Block
titleaggr_sum_by_customer_of_max_multiply_min_1
{
    "propertyname": "transactions.store_idaggr_sum_by_customer_of_max_multiply_min_1",
    "type": "metric",
    "content": {
        "valuetype": "function_sum",
[        "content": [
            {
  100              "type": "function_multiply",
      ],          "content": [
               "operator": "in"    {
            },            "type": "function_max",
   {                     "propertycontent": "transactions.store_id",[
                          "value": [ {
                       100,         "type": "property",
              102                  "value": "transactions.value"
 ],                     "operator": "in"     }
           },             ],
   {                     "propertyoptions": "zsj_desc.kod_zsj_d", {
                            "valueaggregateBy": 22222,[
                    "operator": "lte"           "zsj_desc.kod_zsj_d"
     }             ]         } ]
   } } 
filter_property_in_limit_2
Code Block
titlefilter_property_in_limit_2
{     "name": "filter_property_in_limit_2",     "type": "metric",     "content": {  }
      "type": "function_sum",         "content": [   },
         {           {
     "type": "property",                   "valuetype": "transactions.value"function_min",
            }         ],   "content": [
    "options": {             "withoutFilters": [         {
       "transactions.store_id"             ],             "filterBytype": [
    "property",
           {                     "propertyvalue": "transactions.store_id",value"
                       "value": [    }
                    100,    ],
                    102    "options": {
               ],             "aggregateBy": [
      "operator": "in"                 },        "transactions.store_id"
        {                    ]
"property": "zsj_desc.kod_zsj_d",                     "value": 22222, }
                   "operator": "lte" }
                }]
            ]}
        }]
    }
}
aggr_sum_

...

of_max_

...

plus_min_1
Code Block
titleaggr_sum_by_customer_of_max_multiplyplus_min_1
{
    "name": "aggr_sum_by_customer_of_max_multiplyplus_min_1",
    "type": "metric",
    "content": {
        "type": "function_sumplus",
        "content": [
            {
                "type": "function_multiplysum",
                "content": [
                    {
                        "type": "function_max",
                        "content": [
                            {
                                "type": "property",
                                "value": "transactions.value"
                            }
                        ],
                        "options": {
                            "aggregateBy": [
                                "transactions.store_id"
                            ]
                        }
                    }
                ]
            },
            {
                "type": "function_min",
                "zsj_desc.kod_zsj_d"
content": [
                    {
      ]                  "type": "property",
     }                   "value": "transactions.value"
},                    }
{                ]
        "type": "function_min",   }
        ]
    }
}
aggr_sum_by_zsjd_of_max_plus_min_1
Code Block
titleaggr_sum_by_zsjd_of_max_plus_min_1
{
     "contentname": ["aggr_sum_by_zsjd_of_max_plus_min_1",
    "type": "metric",
    "content": {
        "type": "function_plus",
      {  "content": [
            {
                "type": "propertyfunction_sum",
                "content": [
              "value": "transactions.value"      {
                         }"type": "function_max",
                        "content": [
  ],                         "options": {
                                "aggregateBytype": ["property",
                                "value": "transactions.store_idvalue"
                            ]}
                        }],
                    }    "options": {
           ]             }    "aggregateBy": [
   ]     } } 
aggr_max_sum_accept_aggregate_by_store_two_agg_1
Code Block
titleaggr_max_sum_accept_aggregate_by_store_two_agg_1
{     "name": "aggr_max_sum_accept_aggregate_by_store_two_agg_1",     "type": "metric",     "content": {    "transactions.store_id"
    "type": "function_max",
        "content": [             {  ]
              "type": "function_plus",         }
       "content": [            }
        {        ]
            },
   "type": "function_sum",        {
                "contenttype": "function_min",
[                "content": [
           {         {
                        "type": "property",
    
                           "value": "transactions.value"
                    }
       }         ]
            }
  ],      ]
    }
}
aggr_sum_of_max_without_nested_1
Code Block
titleaggr_sum_of_max_without_nested_1
{
      "name": "aggr_sum_of_max_without_nested_1",
    "optionstype": {"metric",
    "content": {
        "type": "function_sum",
            "aggregateBycontent": [
            {
                "type":   "transactions.storefunction_idmax",
                "content": [
          ],          {
                        "acceptAggregateBytype": ["property",
                        "value": "transactions.value"
       "transactions"             }
                ],
                "options": {
            "filterBy": [       "aggregateBy": [
                        {"transactions.store_id"
                    ],
               "property": "zsj_desc.kod_zsj_d",    "withoutFilters": [
                        "transactions.*"
      "value": 11111,             ]
                }
      "operator": "eq"     }
        ]
    }
}
aggr_sum_of_max_accept_aggr_by_1
Code Block
titleaggr_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": "function_minproperty",
                        "contentvalue": ["transactions.value"
                    }
       {          ],
                      "type"options": "property",{
                    "aggregateBy": [
          "value": "transactions.value"              "transactions.store_id"
                 }   ],
                     ],"acceptAggregateBy": [
                        "optionstransactions":
{                    ]
        "aggregateBy": [       }
            }
        ]
   "transactions.store_id" }
}
filter_by_attribute_sum_of_max_1
Code Block
titlefilter_by_attribute_sum_of_max_1
{
    "name": "filter_by_attribute_sum_of_max_1",
    "type": "metric",
    "content": {
       ], "type": "function_sum",
        "content": [
            {
   "acceptAggregateBy": [              "type": "property",
                "value": "transactionszsj_desc.population"
            }
        ],
      ],  "options": {
            "withoutFilters": [
           "filterBy": [    "transactions.store_id"
            ],
            "filterBy": [
 {                {
                    "property": "zsj_desc.kod_zsj_d",
                    "query": {
              "value          "properties": 33333,[
                            {
            "operator": "ne"                   "id": "kod_zsj_d",
            }                    "type": "property",
       ]                         }
"value": "zsj_desc.kod_zsj_d"
                   }         },
       ]             }        {
]     } } 
arithm_1
Code Block
titlearithm_1
{     "name": "arithm_1",     "type": "metric",     "content": {         "typeid": "function_dividetransaction_sum_max_customer",
        "content": [             {                 "type": "function_sum",
                "content": [                "content": [
      {                         "type": "property",    {
                    "value": "transactions.value"                   "type": "function_max",
}                 ]             },          "content": [
 {                 "type": "number",                 "value": 1000.0       {
     }         ]     } } 
arithm_2
Code Block
titlearithm_2
{     "name": "arithm_2",     "type": "metric",     "content": {         "type": "function_minusproperty",
        "content": [             {                 "type": "number",        "value": "transactions.value"
       "value": 625.45             },             {          }
      "type": "function_multiply",                 "content": [               ],
     {                         "type": "function_sum",         "options": {
              "content": [                             {"aggregateBy": [
                               "type": "property",                "transactions.customer_id"
                "value": "transactions.value"                           ]
 }                         ]              }
      },                     {         }
               "type": "number",                ]
        "value": 1.21                     }
                ]          ],
  }         ]     } } 
arithm_3
Code Block
title