Versions Compared

Key

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

...

Code Block
titlewithout_all_filters_2
{
    "name": "without_all_filters_2",
    "type": "metric",
    "content": {
        "type": "function_sum",
        "content": [
            {
                "type": "property",
                "value": "transactions.value"
            }
        ],
        "options": {
            "withoutFilters": [
                "transactions.*"
            ],
            "filterBy": [
                {
                    "property": "transactions.store_id",
                    "value": 100,
                    "operator": "eq"
                },
                {
                    "property": "transactions.value",
                    "value": 35.2,
                    "operator": "gt"
                }
            ]
        }
    }
}

...

without_from_1
Code Block
titlentilewithout_from_1
{
    "name": "ntilewithout_from_1",
    "type": "metric",
    "content": {
        "type": "function_ntilesum",
        "content": [
            {
                "type": "function_sumproperty",
                "contentvalue": ["transactions.value"
            }
       { ]
    }
}
without_from_2
Code Block
titlewithout_from_2
{
    "name": "without_from_2",
          "type": "propertymetric",
    "content": {
        "type": "function_sum",
        "valuecontent": "transactions.value"[
            {
                }"type": "property",
                ]"value": "transactions.value"
            }
        ],
        "options": {
            "sortwithoutFilters": "desc", [
                "buckets": 3from:transactions"
            ],
}     } } 
ntile_2
Code Block
titlentile_2
{     "namefilterBy": "ntile_2", [
         "type": "metric",     "content": {
        "type            "property": "functiontransactions.store_sumid",
        "content": [            "value": 100,
   {                 "typeoperator": "propertyeq",
                "value": "transactions.value"}
            ]
}        }
]     }
}

...

without_

...

from_

...

3
Code Block
titlentilewithout_filterfrom_by_13
{
    "name": "ntilewithout_filterfrom_by_13",
    "type": "metric",
    "content": {
        "type": "function_ntilesum",
        "content": [
            {
                "type": "function_sumproperty",
                "contentvalue": ["transactions.value"
            }
       { ],
        "options": {
             "typewithoutFilters": "property",[
                "from:customers"
       "value": "transactions.value"    ],
            "filterBy": [
  }              {
  ]             }         ]"property": "transactions.store_id",
        "options": {             "sortvalue": "desc"100,
            "buckets": 3,       "operator": "eq"
      "filterBy": [         }
       {     ]
        }
    }
}
"property
ntile_1
Code Block
titlentile_1
{
    "name": "zsj_desc.kod_zsj_dntile_1",
    "type": "metric",
    "content": {
        "valuetype": 11111,
  "function_ntile",
        "content": [
            {
    "operator            "type": "eqfunction_sum",
                },"content": [
                    {
                        "propertytype": "transactions.valueproperty",
                        "value": 35.2,"transactions.value"
                    }
                ]
            }
        ],
        "operatoroptions": "gte"{
            "sort": "desc",
  }             ]"buckets": 3
        }
    }
}
ntile

...

_2
Code Block
titlentile_filter_by_2
{
    "name": "ntile_filter_by_2",
    "type": "metric",
    "content": {
        "type": "function_sum",
        "content": [
            {
                "type": "property",
                "value": "transactions.value"
            }
        ]
    }
}
ntile_

...

filter_by_1
Code Block
titlentile_partitionfilter_by_1
{
    "name": "ntile_partitionfilter_by_1",
    "type": "metric",
    "content": {
        "type": "function_ntile",
        "content": [
            {
                "type": "function_sum",
                "content": [
                    {
                        "type": "property",
                        "value": "transactions.value"
                    }
                ]
            }
        ],
        "options": {
            "sort": "desc",
            "buckets": 83,
            "partitionByfilterBy": [
                "kod_zsj_d"{
                     ]"property": "zsj_desc.kod_zsj_d",
        }     } } 
ntile_partition_by_2
Code Block
titlentile_partition_by_2
{     "namevalue": "ntile_partition_by_2"11111,
    "type": "metric",     "content": {         "typeoperator": "function_sumeq",
        "content": [       },
     {            {
    "type": "property",                 "valueproperty": "transactions.value",
            }         ]
    }
}
rank_1
Code Block
titlerank_1
{
    "name": "rank_1""value": 35.2,
    "type": "metric",     "content": {         "typeoperator": "function_rank",
        "content": [
            {
                "type": "function_sum",
                "content": [
                    {
                        "type": "property",
                        "value": "transactions.value"
   gte"
                }

               ]
  
         }
        ],
        "options": {
            "sort": "desc"
        }
    }
}

...

ntile_filter_by_2
Code Block
titlerankntile_filter_by_2
{
    "name": "rankntile_filter_by_2",
    "type": "metric",
    "content": {
        "type": "function_sum",
        "content": [
            {
                "type": "property",
                "value": "transactions.value"
            }
        ]
    }
}

...

ntile_partition_by_1
Code Block
titlerankntile_partition_by_1
{
    "name": "rankntile_partition_by_1",
    "type": "metric",
    "content": {
        "type": "function_rankntile",
        "content": [
            {
                "type": "function_sum",
                "content": [
                    {
                        "type": "property",
                        "value": "transactions.value"
                    }
                ]
            }
        ],
        "options": {
            "partitionBysort": ["desc",
                "kod_zsj_d"
"buckets": 8,
           ], "partitionBy": [
          "sort": "desc"     "kod_zsj_d"
            ]
        }
    }
}

...

ntile_partition_by_2
Code Block
titlerankntile_partition_by_2
{
    "name": "rankntile_partition_by_2",
    "type": "metric",
    "content": {
        "type": "function_sum",
        "content": [
            {
                "type": "property",
                "value": "transactions.value"
            }
        ]
    }
}
rank

...

_1
Code Block
titlerank_with_filter_1
{
    "name": "rank_with_filter_1",
    "type": "metric",
    "content": {
        "type": "function_rank",
        "content": [
            {
                "type": "function_sum",
                "content": [
                    {
                        "type": "property",
                        "value": "transactions.value"
                    }
                ],
            }
    "options": {   ],
        "options": {
       "withoutFilters": [    "sort": "desc"
        }
    }
}
rank_2
Code Block
titlerank_2
{
    "*.*name": "rank_2",
    "type": "metric",
    "content": {
       ] "type": "function_sum",
        "content": [
    }        {
    }         ],   "type": "property",
    "options": {             "sortvalue": "desctransactions.value",
            "filterBy":}
[        ]
    }
   }
rank_partition_by_1
Code Block
titlerank_partition_by_1
{
    "name": "rank_partition_by_1",
         "type": "metric",
    "propertycontent": "transactions.store_id",{
        "type": "function_rank",
          "valuecontent": [
            {
           100,     "type": "function_sum",
                "content": [
   101                 {
   ],                     "operatortype": "inproperty",
                }        "value": "transactions.value"
   ]         }     } } 
rank_with_filter_2
Code Block
titlerank_with_filter_2
{
 }
   "name": "rank_with_filter_2",     "type": "metric",     "content": { ]
       "type": "function_sum",    }
    "content": [   ],
        "options": {
                "type": "property",
                "value": "transactions.value"
            }
        ],
        "options": {
            "withoutFilters": "partitionBy": [
                "*.*"
            ],
            "filterBy": [
                {
                    "property": "transactions.store_id",
                    "value": [
                 kod_zsj_d"
      100,                         101
                    ],
  
                 "operatorsort": "indesc"
                }
          
 ]         }
    }
}
rank_

...

partition_

...

by_

...

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

...

rank_with_

...

filter_1
Code Block
titlecanrank_with_2694filter_1
{
    "name": "canrank_with_2694filter_1",
    "type": "metric",
    "content": {
        "type": "function_dividerank",
        "content": [
            {
                "type": "function_sum",
                "content": [
                    {
                        "type": "property",
                        "value": "transactions.value"
                    }
                ],
               },
 "options": {
           {         "withoutFilters": [
      "type": "number",                 "value": 1000.0*.*"
               }     ]
   ]     } } 
can_2694_2
Code Block
titlecan_2694_2
{     "name": "can_2694_2", }
    "type": "metric",     "content": { }
       "type": "function_sum" ],
        "contentoptions": [{
            {
"sort": "desc",
               "typefilterBy": "property",[
                "value": "transactions.value"{
             }         ]"property": "transactions.store_id",
        "options": {             "filterByvalue": [
                        {100,
                      "property": "transactions.store_id",
 101
                   "value": 100],
                    "operator": "eqin"
                }
            ]
        }
    }
}

...

rank_with_

...

filter_

...

2
Code Block
titlecanrank_with_2694filter_32
{
    "name": "canrank_with_2694filter_32",
    "type": "metric",
    "content": {
        "type": "function_dividesum",
        "content": [
            {
                "type": "function_sumproperty",
                "contentvalue": ["transactions.value"
            }
       { ],
        "options":  {
            "typewithoutFilters": "property",[
                "*.*"
       "value": "transactions.value"    ],
            "filterBy": [
  }              {
  ]             },     "property": "transactions.store_id",
      {                 "typevalue": "function_sum",[
                  "content": [     100,
               {         101
               "type": "property",    ],
                    "valueoperator": "transactions.valuein"
                    }
            ]
   ],     }
    }
}
rank_with_filter_3
Code Block
titlerank_with_filter_3
{
    "optionsname": {
"rank_with_filter_3",
    "type": "metric",
    "content": {
        "aggregateBytype": ["function_sum",
        "content": [
            {
 null                     ],
   "type": "property",
                "withoutFiltersvalue": [
                        "zsj_desc.kod_zsj_d"
       "transactions.value"
            ]
                }
            }
        ]
    }
}
can_

...

2694_1
Code Block
titlecan_27512694_1
{
    "name": "can_27512694_1",
    "type": "metric",
    "content": {
        "type": "function_sumdivide",
        "content": [
            {
                "type": "propertyfunction_sum",
                "valuecontent": "transactions.value" [
                    {
      }         ],         "optionstype": { "property",
                        "filterByvalue": ["transactions.value"
                {    }
                "property": "transactions.store_id",]
            },
       "value": 100,    {
                "operatortype": "eqnumber",
                } "value": 1000.0
            ]}
        }]
    }
}
can_

...

2694_2
Code Block
titlecan_27512694_2
{
    "name": "can_27512694_2",
    "type": "metric",
    "content": {
        "type": "function_sum",
        "content": [
            {
                "type": "property",
                "value": "zsj_desctransactions.populationvalue"
            }
        ],
    }
}
can_3062_1
Code Block
titlecan_3062_1
    "options": {
    "name": "can_3062_1",        "typefilterBy": "metric",[
        "content": {       {
 "type": "function_sum",         "content": [        "property": "transactions.store_id",
   {                 "typevalue": "property",100,
                    "valueoperator": "transactions.valueeq"
            }    }
     ],       ]
 "options": {      }
    }
 "filterBy": [}
can_2694_3
Code Block
titlecan_2694_3
{
    "name": "can_2694_3",
    "type": "metric",
    "content": {
  
                 "property"type": "transactions.valuefunction_divide",
        "content": [
          "value": 100, {
                   "operatortype": "gtfunction_sum",
                }"content": [
           ]         },{
        "_comment": "match only store=102"     } } 
can_3062_2
Code Block
titlecan_3062_2
{
    "name": "can_3062_2",     "type": "metricproperty",
    "content": {         "type": "function_sum",         "contentvalue": "transactions.value"
[             {       }
         "type": "property",      ]
          "value": "transactions.value" },
           } {
       ],         "optionstype": {"function_sum",
                "filterBycontent": [
                    {
                        "propertytype": "transactions.valueproperty",
                        "value": 75,"transactions.value"
                    "operator": "gt"}
                ],
}             ]   "options": {
    },         "_comment": "match stores=[100,102]"     }
}
can_3062_3
Code Block
titlecan_3062_3
{"aggregateBy": [
     "name": "can_3062_3",     "type": "metric",     "content": {       null
 "type": "function_sum",         "content": [         ],
   {                 "typewithoutFilters": "property",
                "value": "transactions.value"
            }
        ],
        "options": {
            "filterBy": [
                {                     "property": "transactions.value","zsj_desc.kod_zsj_d"
                    "value": 50,
]
                   "operator": "gt"
                }
    
       ]         },

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

...

can_

...

2751_

...

1
Code Block
titlefiltercan_property2751_in_limit_1
{
    "name": "filter_property_in_limitcan_2751_1",
    "type": "metric",
    "content": {
        "type": "function_sum",
        "content": [
            {
                "type": "property",
                "value": "transactions.value"
            }
        ],
        "options": {
            "withoutFiltersfilterBy": [
                "zsj_desc.*"{
            ],             "filterByproperty": ["transactions.store_id",
                {                     "property"value": "transactions.store_id"100,
                    "valueoperator": ["eq"
                }
       100     ]
        }
    }
 ],}
can_2751_2
Code Block
titlecan_2751_2
{
    "name": "can_2751_2",
        "type": "metric",
     "operatorcontent": "in"{
          "type": "function_sum",
     },   "content": [
            {
   
                "propertytype": "transactions.store_idproperty",
                    "value": ["value": "zsj_desc.population"
            }
        ]
    }
}
can_3062_1
Code Block
titlecan_3062_1
{
    "name": "can_3062_1",
     100"type": "metric",
    "content": {
        "type": "function_sum",
        "content": 102[
            {
       ],         "type": "property",
          "operator      "value": "in"transactions.value"
            }
      },  ],
        "options": {
            "filterBy": [
                {
                    "property": "zsj_desc.kod_zsj_dtransactions.value",
                    "value": 22222100,
                    "operator": "ltegt"
                }
            ]
        },
        "_comment": "match only store=102"
    }
}

...

can_

...

3062_

...

2
Code Block
titlefiltercan_property3062_in_limit_2
{
    "name": "filtercan_property_in3062_limit_2",
    "type": "metric",
    "content": {
        "type": "function_sum",
        "content": [
            {
                "type": "property",
                "value": "transactions.value"
            }
        ],
        "options": {
            "withoutFiltersfilterBy": [
                "transactions.store_id"{
            ],        "property": "transactions.value",
   "filterBy": [                 {"value": 75,
                    "propertyoperator": "transactions.store_id",gt"
                }
      "value": [     ]
        },
        "_comment": "match stores=[100,102]"
    }
}
can_3062_3
Code Block
titlecan_3062_3
{
    "name": "can_3062_3",
    "type": "metric",
    "content": 102{
        "type": "function_sum",
        "content": [
],            {
        "operator": "in"       "type": "property",
                "value": "transactions.value"
            }
        ],
        "options": {
            "filterBy": [
                {
                    "property": "zsj_desc.kod_zsj_dtransactions.value",
                    "value": 2222250,
                    "operator": "ltegt"
                }
            ]
        },
        "_comment": "match stores=[100,102]"
    }
}

...

filter_property_

...

in_

...

limit_1
Code Block
titlerankfilter_property_ofin_arithmlimit_1
{
    "name": "rankfilter_property_ofin_arithmlimit_1",
    "type": "metric",
    "content": {
        "type": "function_ranksum",
        "content": [
            {
                "type": "function_divideproperty",
                "contentvalue": ["transactions.value"
            }
       { ],
        "options":  {
            "typewithoutFilters": "function_sum",[
                "zsj_desc.*"
       "content": [    ],
            "filterBy": [
          {      {
                          "type"property": "propertytransactions.store_id",
                    "value": [
          "value": "transactions.value"               100
             }       ],
                 ]   "operator": "in"
                },
                    {
  
                     "typeproperty": "functiontransactions.store_countid",
 
                      "contentvalue": [
                        100,
   {                     102
           "type": "property",         ],
                       "valueoperator": "transactions.identifierin"
                },
           }     {
                   ] "property": "zsj_desc.kod_zsj_d",
                  }  "value": 22222,
             ]       "operator": "lte"
    }         ],   }
     "options": {             "sort": "desc"]
        }
    }
}

...

filter_

...

property_

...

in_limit_2
Code Block
titlerankfilter_property_ofin_arithmlimit_2
{
    "name": "rankfilter_property_ofin_arithmlimit_2",
    "type": "metric",
    "content": {
        "type": "function_dividesum",
        "content": [
            {
                "type": "function_sumproperty",
                "contentvalue": ["transactions.value"
            }
       { ],
        "options": {
             "typewithoutFilters": "property",
      [
                 "value": "transactions.valuestore_id"
            ],
       }     "filterBy": [
          ]             },{
            {                 "type"property": "functiontransactions.store_countid",
                    "contentvalue": [
                    {    100,
                    "type": "property",   102
                    ],
"value": "transactions.identifier"                   "operator":  }"in"
                },
   ]             }{
        ]     } } 
filter_by_attribute_1
Code Block
titlefilter_by_attribute_1
{     "nameproperty": "filterzsj_bydesc.kod_attributezsj_1d",
    "type": "metric",     "content": {         "typevalue": "function_sum",
        "content": [
       22222,
    {                 "typeoperator": "propertylte",
                "value": "zsj_desc.population"}
            ]
}         ]}
    }
}

...

rank_

...

of_

...

arithm_

...

1
Code Block
titlefilterrank_byof_attributearithm_21
{
    "name": "filterrank_byof_attributearithm_21",
    "type": "metric",
    "content": {
        "type": "function_sumrank",
        "content": [
            {
                "type": "propertyfunction_divide",
                "valuecontent": "zsj_desc.population" [
             }       {
 ],         "options": {             "withoutFilterstype": ["function_sum",
                        "transactions.store_idcontent": [
           ],             "filterBy": [     {
           {                     "propertytype": "zsj_desc.kod_zsj_dproperty",
                    "query": {            "value": "transactions.value"
              "properties":  [            }
                {        ]
                    },
   "id": "kod_zsj_d",                {
                "type": "property",       "type": "function_count",
                        "valuecontent": "zsj_desc.kod_zsj_d"[
                            }{
                        ]        "type": "property",
           },                     "operatorvalue": "inAttributetransactions.identifier"
                },            }
           {             ]
       "property": "transactions.store_id",            }
        "value": 101,       ]
            }
"operator": "ne"       ],
        "options": }{
            ]"sort": "desc"
        }
    }
}

...

rank_

...

of_

...

arithm_

...

2
Code Block
titlefilterrank_byof_attributearithm_32
{
    "name": "filterrank_byof_attributearithm_32",
    "type": "metric",
    "content": {
        "type": "function_sumdivide",
        "content": [
            {
                "type": "propertyfunction_sum",
                "valuecontent": "zsj_desc.population"[
             }       {
 ],         "options": {             "withoutFilterstype": ["property",
                   "transactions.store_id"     "value": "transactions.value"
      ],             "filterBy": [}
                {]
            },
       "property": "zsj_desc.kod_zsj_d",    {
                "querytype": {"function_count",
                "content": [
        "properties": [           {
                 {       "type": "property",
                        "idvalue": "kod_zsj_d",transactions.identifier"
                    }
           "type": "property",    ]
            }
        ]
    }
}
"value
filter_by_attribute_1
Code Block
titlefilter_by_attribute_1
{
    "name": "zsjfilter_desc.kodby_zsjattribute_d1",
    "type": "metric",
    "content": {
                }
                        ]
                    },
                    "operator": "inAttribute"
                },
                {
                    "property": "transactions.store_id",
       "type": "function_sum",
            "valuecontent": 101,
            [
       "operator": "ne"                 },
                {
  
                 "propertytype": "transactions.store_idproperty",
                    "value": 101,                     "operator": "ne"
    "zsj_desc.population"
            }
  
         ]
        }

   }
}
filter_by_attribute_

...

2
Code Block
titlefilter_by_attribute_42
{
    "name": "filter_by_attribute_42",
    "type": "metric",
    "content": {
        "type": "function_sum",
        "content": [
            {
                "type": "property",
                "value": "zsj_desc.population"
            }
        ],
        "options": {
            "withoutFilters": [
                "transactions.store_id"
            ],
            "filterBy": [
                {
                    "property": "zsj_desc.kod_zsj_d",
                    "query": {
                        "properties": [
                            {
                                "id": "kod_zsj_d",
                                "type": "property",
                                "value": "zsj_desc.kod_zsj_d"
                            },
                        ]
        {            },
                    "idoperator": "transaction_suminAttribute",
                },
               "type": "function_sum", {
                    "property": "transactions.store_id",
          "content": [         "value": 101,
                    "operator": "ne"
    {            }
            ]
        }
    }
}
filter_by_attribute_3
Code Block
titlefilter_by_attribute_3
{
    "name": "filter_by_attribute_3",
    "type": "propertymetric",
    "content": {
        "type": "function_sum",
        "content": [
            {
                "type": "property",
                "value": "transactionszsj_desc.valuepopulation"
            }
        ],
        "options": {
       }     "withoutFilters": [
                "transactions.store_id"
            ],
            "filterBy": [
                {
               }     "property": "zsj_desc.kod_zsj_d",
                     ],"query": {
                        "havingproperties": [
                            {
                                "propertyIdid": "transactionkod_zsj_sumd",
                                "valuetype": 70"property",
                                "operatorvalue": "gtzsj_desc.kod_zsj_d"
                            }
                        ]
                    },
                    "operator": "inAttribute"
                },
                {
                    "property": "transactions.store_id",
                    "value": 101,
                    "operator": "ne"
                },
            ]    {
    }     } } 
filter_by_attribute_5
Code Block
titlefilter_by_attribute_5
{     "name": "filter_by_attribute_5",
    "typeproperty": "metrictransactions.store_id",
    "content": {         "type": "function_sum",
        "contentvalue": [
  101,
         {                 "type"operator": "propertyne",
                "value": "zsj_desc.population"
       }
    }         ],
        "options":}
{    }
    }
filter_by_attribute_4
Code Block
titlefilter_by_attribute_4
{
    "withoutFiltersname": ["filter_by_attribute_4",
           "type": "metric",
    "transactions.store_idcontent": {
           ]"type": "function_sum",
            "filterBycontent": [
                {
   
                "propertytype": "zsj_desc.kod_zsj_dproperty",
                "value": "zsj_desc.population"
    "query": {       }
        ],
        "propertiesoptions": [{
            "withoutFilters": [
              {  "transactions.store_id"
            ],
            "filterBy": [
   "id": "kod_zsj_d",            {
                    "typeproperty": "property",
         zsj_desc.kod_zsj_d",
                      "valuequery": "zsj_desc.kod_zsj_d"{
                        "properties":  [
 },                             {
                                "id": "transactionkod_zsj_sumd",
                                "type": "function_sumproperty",
                                "contentvalue": ["zsj_desc.kod_zsj_d"
                            },
       {                       {
                 "type": "property",                                         "value"id": "transactions.value"transaction_sum",
                                "type": "function_sum",
  }                              "content": [
 ],                                  "options": {
                                        "withoutFilterstype": "property",
[                                        "value": "transactions.store_idvalue"
                                    ]}
                                }]
                            }
                        ],
                        "having": [
                            {
                                "propertyId": "transaction_sum",
                                "value": 70,
                                "operator": "gt"
                            }
                        ]
                    },
                    "operator": "inAttribute"
                },
                {
                    "property": "transactions.store_id",
                    "value": 101,
                    "operator": "ne"
                }
            ]
        }
    }
}
filter_by_attribute_

...

5
Code Block
titlefilter_by_attribute_variable_15
{
    "name": "filter_by_attribute_variable_15",
    "type": "metric",
    "content": {
        "type": "function_sum",
        "content": [
            {
                "type": "property",
                "value": "zsj_desc.population"
            }
        ],
        "options": {
            "withoutFilters": [
                "transactions.store_id"
            ],
            "filterBy": [
                {
                    "property": "zsj_desc.kod_zsj_d",
                    "query": {
                        "properties": [
                            {
                                "id": "kod_zsj_d",
                                "type": "property",
                                "value": "zsj_desc.kod_zsj_d"
                            },
                            {
                                "id": "transaction_sum",
                                "type": "function_multiplysum",
                                "content": [
                                    {
                                        "type": "function_sumproperty",
                                        "contentvalue": ["transactions.value"
                                    }
       {                         ],
                       "type": "property",                                                 "value": "transactions.value"
                                            }
                                        ]
                                    },
                                    {
   "options": {
                                    "typewithoutFilters": "variable",[
                                        "value": "number_100transactions.store_id"
                                    }]
                                ]}
                            }
                        ],
                        "having": [
                            {
                                "propertyId": "transaction_sum",
                                "value": 70070,
                                "operator": "gt"
                            }
                        ]
                    },
                    "operator": "inAttribute"
                },
                {
                    "property": "transactions.store_id",
                    "value": 101,
                    "operator": "ne"
                }
            ]
        }
    }
}
filter_by_attribute_

...

variable_1
Code Block
titlefilter_by_attribute_globalvariable_1
{
    "name": "filter_by_attribute_globalvariable_1",
    "type": "metric",
    "content": {
        "type": "function_sum",
        "content": [
            {
                "type": "property",
                "value": "zsj_desc.population"
            }
        ],
        "options": {
            "withoutFilters": [
                "transactions.store_id"
            ],
            "filterBy": [
                {
                    "property": "transactions.store_idzsj_desc.kod_zsj_d",
                    "valuequery": 101, {
                        "operatorproperties": "ne"[
                      },      {
          {                      "propertyid": "zsj_desc.kod_zsj_d",
                    "query": {            "type": "property",
                           "properties": [    "value": "zsj_desc.kod_zsj_d"
                       {     },
                           "id": "kod_zsj_d", {
                                "typeid": "propertytransaction_sum",
                                "valuetype": "zsj_desc.kod_zsj_d"function_multiply",
                            },    "content": [
                       {             {
                   "id": "transaction_sum",
                                "type": "function_multiplysum",
  
                             "content": [          "content": [
                         {                   {
                     "type": "function_sum",                                         "content": ["type": "property",
                                              {  "value": "transactions.value"
                                            }
"type": "property",                                       ]
         "value": "transactions.value"                          },
                  }                  {
                      ]                  "type": "variable",
                 },                       "value": "number_100"
            {                        }
                "type": "variable",               ]
                         "value": "number_100"  }
                        ],
         }               "having": [
                ]            {
                }                "propertyId": "transaction_sum",
       ],                         "havingvalue": [700,
                            {    "operator": "gt"
                           "propertyId": "transaction_sum", }
                        ]
       "value": 700,            },
                    "operator": "gtinAttribute"
                },
             }   {
                     ]"property": "transactions.store_id",
                    "value": }101,
                    "operator": "inAttributene"
                }
            ]
        }
    }
}
filter_by_attribute_

...

global_1
Code Block
titlefilter_by_attribute_combinedglobal_1
{
    "name": "filter_by_attribute_combinedglobal_1",
    "type": "metric",
    "content": {
        "type": "function_sum",
        "content": [
            {
                "type": "property",
                "value": "transactionszsj_desc.valuepopulation"
            }
        ],
        "options": {
            "withoutFilters": [
                "transactions.store_id"
            ],
            "filterBy": [
                {
                    "property": "zsj_desctransactions.kodstore_zsj_did",
                    "queryvalue": {
101,
                       "propertiesoperator": ["ne"
                },
           {     {
                           "id"property": "zsj_desc.kod_zsj_d",
                    "query": {
          "type": "property",                 "properties": [
               "value": "zsj_desc.kod_zsj_d"            {
                }                "id": "kod_zsj_d",
       ],                         "filterBytype": ["property",
                            {    "value": "zsj_desc.kod_zsj_d"
                           "property": "transactions.value" },
                             {
  "value": 45,                                 "operatorid": "gtetransaction_sum",
                            }    "type": "function_multiply",
                   ]             "content": [
      },                     "operator": "inAttribute"            {
    },                 {                     "propertytype": "transactions.valuefunction_sum",

                   "value": 25,                     "operatorcontent": "gte"[
                },                 {           {
         "property": "transactions.store_id",                     "value": 101,                     "operatortype": "neproperty",
                }             ]         }     } } 
filter_by_attribute_nested_1
Code Block
titlefilter_by_attribute_nested_1
{     "namevalue": "filter_by_attribute_nested_1",transactions.value"
             "type": "metric",     "content": {         "type": "function_multiply",         "content": [    }
        {                 "type": "function_sum",              ]
  "content": [                     {            },
            "type": "property",                       {
 "value": "transactions.value"                     }                 ],"type": "variable",
                 "options":  {                     "withoutFiltersvalue": ["number_100"
                         "transactions.store_id"           }
         ],                     "filterBy": [ ]
                       {     }
                       "property": "zsj_desc.kod_zsj_d" ],
                        "having": [
  "query": {                         {
       "properties": [                        "propertyId": "transaction_sum",
           {                     "value": 700,
                  "id              "operator": "kod_zsj_dgt",
                            }
           "type": "property",            ]
                    },
       "value": "zsj_desc.kod_zsj_d"            "operator": "inAttribute"
                }
      }      ]
        }
    }
}
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": [
 },            {
                "operatortype": "inAttributeproperty",
                "value": "transactions.value"
      },      }
        ],
        "options": {
            "withoutFilters": [
              "property":  "transactions.value",store_id"
            ],
            "filterBy": [
       "value": 50,        {
                    "operatorproperty": "gte"zsj_desc.kod_zsj_d",
                    "query": {
      }                  "properties": [
 ]                 }          {
  },             {                 "id": "nestedkod_inzsj_attributed",
                "type": "number",                 "valuetype": 13.0"property",
            }         ]     } } 
ifnull_1
Code Block
titleifnull_1
{     "namevalue": "ifnull_1",zsj_desc.kod_zsj_d"
    "type": "metric",     "content": {         "type": "function_plus",       }
 "content": [             {         ],
       "type": "function_ifnull",                 "contentfilterBy": [
                            {
                                "typeproperty": "function_sumtransactions.value",
                        "content        "value": [45,
                            {    "operator": "gte"
                           "type": "property", }
                        ]
         "value": "transactions.value"          },
                  }  "operator": "inAttribute"
                },
    ],            {
            "options": {       "property": "transactions.value",
                    "filterByvalue": 25,
  [                  "operator": "gte"
             {   },
                {
                    "property": "transactions.store_id",
                    "value": 101,
              "value": 101,     "operator": "ne"
                }
            ]
"operator": "eq"       }
    }
}
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": "numberproperty",
                        "value": 0"transactions.0value"
                    }
                ],
            },    "options": {
       {             "withoutFilters": [
  "type": "function_sum",                 "content": [   "transactions.store_id"
                 {    ],
                    "typefilterBy": "property", [
                        {
  "value": "transactions.value"                     }    "property": "zsj_desc.kod_zsj_d",
           ],                 "optionsquery": {
                    "filterBy": [            "properties": [
                  {                  {
          "property": "transactions.store_id",                             "valueid": 102"kod_zsj_d",
                            "operator": "eq"
            "type": "property",
                       }                 "value": "zsj_desc.kod_zsj_d"
      ]                 }             }
               ]     } } 
filter_by_boolean_1
Code Block
titlefilter_by_boolean_1
{     "name": "filter_by_boolean_1",    ]
"type": "metric",     "content": {         "type": "function_sum",         "content": [ },
           {                 "typeoperator": "propertyinAttribute",
                  "value": "transactions.value"     },
       }          ]     } } 
filter_by_boolean_nor_1
Code Block
titlefilter_by_boolean_nor_1
{
    "name": "filter_by_boolean_nor_1",        "type": "metric",     "content": {         "typeproperty": "function_sumtransactions.value",
         "content": [             {     "value": 50,
          "type": "property",                 "valueoperator": "transactions.value"gte"
               }         }
    ]      } } 
filter_by_boolean_or_and_1
Code Block
titlefilter_by_boolean_or_and_1
{     "name": "filter_by_boolean_or_and_1",  ]
  "type": "metric",     "content": {       }
 "type": "function_sum",         "content": [ },
            {
                "typeid": "propertynested_in_attribute",
                "valuetype": "transactions.valuenumber",
            }
    "value": 13.0
       ]     }
}

...

        ]
    }
}
ifnull_1
Code Block
titlefilter_by_boolean_without_filtersifnull_1
{
    "name": "filter_by_boolean_without_filtersifnull_1",
    "type": "metric",
    "content": {
        "type": "function_sumplus",
        "content": [
            {
                "type": "propertyfunction_ifnull",
                "valuecontent": "transactions.value" [
                  }  {
      ]     } } 
filter_by_boolean_without_filters_2
Code Block
titlefilter_by_boolean_without_filters_2
{     "name": "filter_by_boolean_without_filters_2",     "type": "metricfunction_sum",
    "content": {         "type": "function_sum",         "content": [
                        {    {
            "type": "property",                    "valuetype": "transactions.valueproperty",
             }          ],         "optionsvalue": { "transactions.value"
                "withoutFilters": [           }
     "trans*.va*"             ],      ],
      "filterBy": [                 "options": {
                      "operator": "or",     "filterBy": [
              "content": [                 {
       {                             "property": "transactions.valuestore_id",
                                    "value": 20101,
                                    "operator": "lteeq"
                            },    }
                            ]
  {                      }
      "property": "transactions.value",             },
               "value": 80,    {
                        "operatortype": "gtenumber",
                        "value": 0.0
}                    }
  ]              ]
  }          },
  ]         } {
   } } 
having_boolean_1
Code Block
titlehaving_boolean_1
{     "name": "having_boolean_1",     "type": "metricfunction_sum",
    "content": {            "typecontent": "function_sum", [
              "content": [     {
       {                 "type": "property",
                        "value": "transactions.value"
                    }
                ],
     }     } 
having_boolean_two_metrics_1
Code Block
titlehaving_boolean_two_metrics_1
{     "nameoptions": "having_boolean_two_metrics_1",{
                    "typefilterBy": "metric", [
                       "content": { {
                            "typeproperty": "functiontransactions.store_sumid",
                     "content       "value": [102,
            {                 "typeoperator": "property",
eq"
                        }
                    ]
               "value": "transactions.value" }
            }
        ]
    }
}

...

filter_by_boolean_

...

1
Code Block
titlehavingfilter_by_boolean_two_metrics_21
{
    "name": "havingfilter_by_boolean_two_metrics_21",
    "type": "metric",
    "content": {
        "type": "function_countsum",
        "content": [
            {
                "type": "property",
                "value": "transactions.identifiervalue"
            }
        ]
    }
}
filter_by_boolean_

...

nor_1
Code Block
titlefilter_by_boolean_and_attributenor_1
{
    "name": "filter_by_boolean_andnor_attribute_1",
    "type": "metric",
    "content": {
        "type": "function_sum",
        "content": [
            {
                "type": "property",
                "value": "zsj_desctransactions.populationvalue"
            }
        ],
    }
}
filter_by_boolean_or_and_1
Code Block
titlefilter_by_boolean_or_and_1
{
    "optionsname": {
 "filter_by_boolean_or_and_1",
    "type": "metric",
    "withoutFilterscontent": [{
                "transactions.store_id"
            ]"type": "function_sum",
            "filterBycontent": [
                {
                    "operatortype": "andproperty",
   
                "contentvalue": ["transactions.value"
            }
        ]
  {  }
       }
filter_by_boolean_without_filters_1
Code Block
titlefilter_by_boolean_without_filters_1
{
                  "property"name": "zsj_desc.kod_zsj_dfilter_by_boolean_without_filters_1",
    "type": "metric",
    "content": {
        "type": "function_sum",
        "querycontent": {[
             {
                  "propertiestype": ["property",
                "value": "transactions.value"
            }
     {   ]
    }
}
filter_by_boolean_without_filters_2
Code Block
titlefilter_by_boolean_without_filters_2
{
    "name": "filter_by_boolean_without_filters_2",
    "type": "metric",
        "content": {
         "idtype": "kodfunction_zsj_dsum",
        "content": [
            {
                 "type": "property",
                "value": "transactions.value"
            }
        ],
        "valueoptions": "zsj_desc.kod_zsj_d"{
            "withoutFilters": [
                "trans*.va*"
      },      ],
            "filterBy": [
                {
                    "operator": "or",
                    "idcontent": "transaction_sum",[
                        {
               "type": "function_sum",            "property": "transactions.value",
                            "contentvalue": [20,
                            "operator": "lte"
              {          },
                        {
             "type": "property",              "property": "transactions.value",
                                 "value": "transactions.value"80,
                            "operator": "gte"
              }          }
                    ]
         ]       }
            ]
        }
    }
}
 }
having_boolean_1
Code Block
titlehaving_boolean_1
{
    "name": "having_boolean_1",
    "type": "metric",
    "content": {
        "type": "function_sum",
      ],  "content": [
            {
                "havingtype": ["property",
                "value": "transactions.value"
            }
     {   ]
    }
}
having_boolean_two_metrics_1
Code Block
titlehaving_boolean_two_metrics_1
{
    "name": "having_boolean_two_metrics_1",
    "type": "metric",
       "content": {
          "propertyIdtype": "transactionfunction_sum",
        "content": [
            {
                 "valuetype": 120"property",
                "value": "transactions.value"
            }
        ]
"operator": "lte"   }
}
having_boolean_two_metrics_2
Code Block
titlehaving_boolean_two_metrics_2
{
    "name": "having_boolean_two_metrics_2",
    "type": "metric",
    "content": {
        "type": "function_count",
   }     "content": [
            {
             ]   "type": "property",
                "value": "transactions.identifier"
            }
        ]
    }
}
filter_by_boolean_and_attribute_1
Code Block
titlefilter_by_boolean_and_attribute_1
{
    "name": "filter_by_boolean_and_attribute_1",
    "type": "metric",
    "content": {
        "type": "function_sum",
      "operator  "content": [
            {
                "type": "inAttributeproperty",
                "value": "zsj_desc.population"
            }
        ],
        "options": {
            "withoutFilters": [
                "transactions.store_id"
            ],
            "filterBy": [
                {
                    "operator": "and",
                    "content": [
                        {
                            "property": "zsj_desc.kod_zsj_d",
                            "query": {
                                "properties": [
                                    {
                                        "id": "kod_zsj_d",
                                        "type": "property",
                                        "value": "zsj_desc.kod_zsj_d"
                                    },
                                    {
                                        "id": "transaction_sum",
                                        "type": "function_sum",
                                        "content": [
                                            {
                                                "type": "property",
                                                "value": "transactions.value"
                                            }
                                        ]
                                    }
                                ],
                                "having": [
                                    {
                                        "propertyId": "transaction_sum",
                                        "value": 95120,
                                        "operator": "gtelte"
                                    }
                                ]
                            },
                            "operator": "inAttribute"
                        },
                    ]    {
            }             ]   "property": "zsj_desc.kod_zsj_d",
    }     } } 
filter_by_boolean_or_attribute_1
Code Block
titlefilter_by_boolean_or_attribute_1
{     "name": "filter_by_boolean_or_attribute_1",     "type": "metric",     "contentquery": {
                   "type": "function_sum",             "contentproperties": [
                                    {
                      "type": "property",                 "valueid": "kod_zsj_desc.population"
 d",
          }         ],         "options": {             "withoutFilterstype": ["property",
                "transactions.store_id"             ],             "filterByvalue": ["zsj_desc.kod_zsj_d"
                {                    },
"operator": "or",                     "content": [             {
           {                             "propertyid": "zsj_desc.kod_zsj_d",
    transaction_sum",
                       "query": {                "type": "function_sum",
               "properties": [                        "content": [
           {                                 {
       "id": "kod_zsj_d",                                         "type": "property",
                                                "value": "zsj_desc.kod_zsj_d"transactions.value"
                                            },
                                    {    ]
                                    "id": "transaction_sum",}
                                ],
        "type": "function_sum",                       "having": [
                "content": [                   {
                         {               "propertyId": "transaction_sum",
                                "type": "property",       "value": 95,
                                        "valueoperator": "transactions.valuegte"
                                            }
 
                                      ]
                            },
       }                     "operator": "inAttribute"
          ],              }
                  "having": [ ]
                }
            ]
     {   }
    }
}
filter_by_boolean_or_attribute_1
Code Block
titlefilter_by_boolean_or_attribute_1
{
    "name": "filter_by_boolean_or_attribute_1",
    "type": "metric",
    "content": {
            "propertyIdtype": "transactionfunction_sum",
        "content": [
             {
                "valuetype": 72,
    "property",
                                   "operator"value": "ltezsj_desc.population"
            }
        ],
        "options": {
    }        "withoutFilters": [
                "transactions.store_id"
      ]      ],
            "filterBy": [
        },        {
                    "operator": "inAttributeor",
                    "content": [
  },                         {
                            "property": "zsj_desc.kod_zsj_d",
                            "query": {
                                "properties": [
                                    {
                                        "id": "kod_zsj_d",
                                        "type": "property",
                                        "value": "zsj_desc.kod_zsj_d"
                                    },
                                    {
                                        "id": "transaction_sum",
                                        "type": "function_sum",
                                        "content": [
                                            {
                                                "type": "property",
                                                "value": "transactions.value"
                                            }
                                        ]
                                    }
                                ],
                                "having": [
                                    {
                                        "propertyId": "transaction_sum",
                                        "value": 16072,
                                        "operator": "gtelte"
                                    }
                                ]
                            },
                            "operator": "inAttribute"
                        },
                    ]    {
            }             ]   "property": "zsj_desc.kod_zsj_d",
    }     } } 
percentile_1
Code Block
titlepercentile_1
{     "name": "percentile_1",     "type": "metric",     "contentquery": {
        "type": "function_percentile",         "content": [             {"properties": [
               "type": "function_sum",                 "content": [  {
                  {                         "typeid": "propertykod_zsj_d",
                        "value": "transactions.value"                "type": "property",
     }                 ]             }     "value": "zsj_desc.kod_zsj_d"
  ],         "options": {             "sort": "desc"           },
      }  } 
percentile_2
Code Block
titlepercentile_2
{     "name": "percentile_2",     "type": "metric",     "content": {         "type": "function_sum",{
         "content": [             {                 "typeid": "propertytransaction_sum",
                "value": "transactions.value"             }         ] "type": "function_sum",
  } } 
percentile_arithm_1
Code Block
titlepercentile_arithm_1
{     "name": "percentile_arithm_1",     "type": "metric",     "content": {         "type": "function_percentile",         "content": [
            {                 "type": "function_ifnull",               {
 "content": [                     {                         "type": "function_divideproperty",
                        "content": [                       "value": "transactions.value"
    {                                 "type": "function_sum",      }
                          "content": [             ]
                       {             }
                           "type": "property",       ],
                                 "valuehaving": "transactions.value"[
                                    {
}                                 ]       "propertyId": "transaction_sum",
                    },                    "value": 160,
       {                                 "typeoperator": "function_countgte",
                                "content": [   }
                                ]
{                            },
            "type": "property",               "operator": "inAttribute"
                        "value": "transactions.customer_id"}
                    ]
                }
            ]
        }
    }
}
percentile_1
Code Block
titlepercentile_1
{
   ] "name": "percentile_1",
    "type": "metric",
    "content": {
        "type": "function_percentile",
    }    "content": [
            {
      ]          "type": "function_sum",
             },   "content": [
                    {
                        "type": "numberproperty",
                        "value": 0"transactions.0value"
                    }
                ]
            }
        ],
        "options": {
            "sort": "desc"
        }
    }
}
percentile_

...

2
Code Block
titlepercentile_arithm_2
{
    "name": "percentile_arithm_2",
    "type": "metric",
    "content": {
        "type": "function_dividesum",
        "content": [
            {
                "type": "function_sumproperty",
                "contentvalue": [ "transactions.value"
            }
        ]
    }
}
percentile_arithm_1
Code Block
titlepercentile_arithm_1
{
    "name": "percentile_arithm_1",
    "type": "metric",
    "content": {
        "type": "propertyfunction_percentile",
        "content": [
            {
 "value": "transactions.value"              "type": "function_ifnull",
     }           "content": [
    ]             },     {
       {                 "type": "function_countdivide",
                "content": [       "content":  [
           {                 {
       "type": "property",                         "valuetype": "transactions.customerfunction_idsum",
                    }            "content": [
    ]             }         ],         "options": {
            "sort": "desc"         }     } } 
percentile_partition_by_1
Code Block
titlepercentile_partition_by_1
{     "name": "percentile_partition_by_1",     "type": "metricproperty",
    "content": {            "type": "function_percentile",         "content": [             {"value": "transactions.value"
                   "type": "function_sum",                }
"content": [                     {          ]
              "type": "property",             },
           "value": "transactions.value"                {
    }                 ]           "type": "function_count",
}         ],         "options": {             "partitionBycontent": [
                "kod_zsj_d"             ],       {
     "sort": "desc"         }     } }
percentile_partition_by_2
Code Block
titlepercentile_partition_by_2
{
    "name": "percentile_partition_by_2",
    "type": "metric",     "content": {         "type": "function_sumproperty",
        "content":  [             {                 "typevalue": "property",transactions.customer_id"
                      "value": "transactions.value"             }
             ]     } } 
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": "propertynumber",
                        "value": "transactions.customer_id"0.0
                    }
                ]
            }
        ],
        "options": {
            "sort": "desc"
        }
    }
}
percentile_

...

arithm_

...

2
Code Block
titlepercentile_same_valuesarithm_2
{
    "name": "percentile_samearithm_values_2",
    "type": "metric",
    "content": {
        "type": "function_countdivide",
        "content": [
            {
                "type": "propertyfunction_sum",
                "valuecontent": "transactions.customer_id" [
                  }  {
      ]     } } 
accept_filters_1
Code Block
titleaccept_filters_1
{     "name": "accept_filters_1",     "type": "metricproperty",
    "content": {         "type": "function_sum",         "contentvalue": ["transactions.value"
             {       }
         "type": "property",      ]
          "value": "transactions.value" },
           } {
       ],         "optionstype": { "function_count",
                "acceptFilterscontent": [
                   "transactions.*" {
           ],             "filterBytype": ["property",
                {                     "property": "transactions.store"value": "transactions.customer_id",
                    "value": 100,}
                ]
    "operator": "eq"        }
        }],
                {
    "options": {
               "propertysort": "transactions.valuedesc",
        }
    }
}
percentile_partition_by_1
Code Block
titlepercentile_partition_by_1
{
    "valuename": 50"percentile_partition_by_1",
    "type": "metric",
    "content": {
        "operatortype": "gtefunction_percentile",
        "content": [
      }      {
      ]         }     }
}
accept_filters_2
Code Block
titleaccept_filters_2
{"type": "function_sum",
    "name": "accept_filters_2",     "type": "metric",     "content": {[
        "type": "function_sum",         "content": [ {
           {
                "type": "property",
                        "value": "transactions.value"
            }        }
],         "options": {       ]
     "acceptFilters": [      }
        ],
 "transactions.store_id"       "options": {
    ],        "partitionBy": [
   "filterBy": [            "kod_zsj_d"
    {        ],
            "propertysort": "transactions.store_iddesc",
        }
    }
}
percentile_partition_by_2
Code Block
titlepercentile_partition_by_2
{
    "valuename": 100"percentile_partition_by_2",
    "type": "metric",
    "content": {
        "operatortype": "eq"function_sum",
        "content": [
         },   {
             {   "type": "property",
                "propertyvalue": "transactions.value",
            }
       "value": 50,
                    "operator": "gte"
                }
            ]
        }
 
  }
}

...

percentile_same_

...

values_

...

1
Code Block
titleacceptpercentile_same_filtersvalues_31
{
    "name": "acceptpercentile_same_filtersvalues_31",
    "type": "metric",
    "content": {
        "type": "function_sumpercentile",
        "content": [
            {
                "type": "propertyfunction_count",
                "valuecontent": "transactions.value"[
             }       {
 ],         "options": {             "acceptFilterstype": [                 "customers.*""property",
            ],            "value": "filterBytransactions.customer_id":
[                 {   }
                ]
"property": "transactions.store_id",           }
        ],
"value": 100,       "options": {
            "operatorsort": "eqdesc"
        }
    }
}
 },
percentile_same_values_2
Code Block
titlepercentile_same_values_2
{
    "name": "percentile_same_values_2",
    "type": "metric",
    "content": {
           
        "propertytype": "transactions.valuefunction_count",
        "content": [
          "value": 50, {
                   "operatortype": "gteproperty",
                }"value": "transactions.customer_id"
            ]}
        }]
    }
}
accept

...

_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_

...

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_

...

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": {
            "withoutFiltersacceptFilters": [
                "customers.*",
                "transactions.store*"
            ],
            "filterBy": [
                {
                    "property": "transactions.store_id",
                    "value": 100,
                    "operator": "eq"
                },
                {
                    "property": "transactions.value",
                    "value": 50,
                    "operator": "gte"
                }
            ]
        }
    }
}

...

accept_without_

...

filters_1
Code Block
titlebigaccept_numberswithout_filters_1
{
    "name": "bigaccept_without_numbersfilters_1",
    "type": "metric",
    "content": {
        "type": "function_sum",
        "content": [
            {
                "type": "function_multiplyproperty",
                "contentvalue": ["transactions.value"
            }
        ],
        "options": {
            "acceptFilters": [
                "type": "property",transactions.*"
            ],
            "filterBy": [
                {
                    "valueproperty": "transactions.store_id",
                    "value": 100,
                   }, "operator": "eq"
                },
            {    {
                    "typeproperty": "numbertransactions.value",
   
                    "value": 50,
1.0E9                     }"operator": "gte"
                ]}
            }]
        ]}
    }
}

...

accept_without_

...

filters_2
Code Block
titlebigaccept_without_numbersfilters_2
{
    "name": "bigaccept_without_numbersfilters_2",
    "type": "metric",
    "content": {
        "type": "function_multiplysum",
        "content": [
            {
                "type": "function_sumproperty",
                "contentvalue": ["transactions.value"
            }
       { ],
        "options":  {
            "typeacceptFilters": "property",[
                "transactions.store_id"
       "value": "transactions.value"    ],
            "filterBy": [
  }              {
  ]             },       "property": "transactions.store_id",
     {                 "typevalue": "number"100,
                    "valueoperator": 4.56789123435E9 "eq"
                },
        ],        {
"_comment": "returns the first 12 digits, without decimal part"     } } 
big_numbers_3
Code Block
titlebig_numbers_3
{     "nameproperty": "big_numbers_3transactions.value",
    "type": "metric"                "value": 50,
    "content": {                "typeoperator": "function_multiply",gte"
                "content":}
[            ]
{        }
    }
}
accept_without_filters_3
Code Block
titleaccept_without_filters_3
{
    "typename": "function_sumaccept_without_filters_3",
    "type": "metric",
    "content": {
    "content": [   "type": "function_sum",
        "content": [
      {       {
                 "type": "property",
                        "value": "transactions.value"
            }
       } ],
        "options": {
     ]       "withoutFilters": [
    },             {"customers.*",
                "type": "number",transactions.store*"
            ],
            "valuefilterBy": 6.789123435E7 [
                {
  }         ],         "_commentproperty": "returns the first 12 digits, with decimal part"transactions.store_id",
             } } 
filter_by_date_1
Code Block
titlefilter_by_date_1
{     "namevalue": "filter_by_date_1"100,
    "type": "metric",     "content": {         "typeoperator": "function_sum",eq"
                },
  "content": [             {
                    "typeproperty": "propertytransactions.value",
                    "value": "transactions.value50,
                    "operator": "gte"
                }
            ]
        }
    }
}

...

big_numbers_1
Code Block
titlefilterbig_by_not_in_attribute_numbers_1
{
    "name": "filterbig_by_not_in_attribute_numbers_1",
    "type": "metric",
    "content": {
        "type": "function_sum",
        "content": [
            {
                "type": "propertyfunction_multiply",
                "valuecontent": "zsj_desc.population" [
             }       {
 ],         "options": {             "withoutFilterstype": ["property",
                "transactions.store_id"        "value": "transactions.value"
   ],             "filterBy": [   },
             {       {
             "property": "zsj_desc.kod_zsj_d",          "type": "number",
         "query": {              "value": 1.0E9
         "properties": [          }
                ]
 {           }
        ]
    }
}
big_numbers_2
Code Block
titlebig_numbers_2
{
     "idname": "kodbig_zsjnumbers_d2",
    "type": "metric",
    "content": {
           "type": "function_multiply",
        "typecontent": "property",[
            {
                   "valuetype": "zsj_desc.kod_zsj_d"function_sum",
                "content": [
          }          {
              ]               "type": "property",
     },                     "operatorvalue": "notInAttributetransactions.value"
                    },
                {]
            },
       "property": "transactions.store_id",    {
                "valuetype": 101,
   "number",
                "operatorvalue": "eq"4.56789123435E9
            }
   }     ],
       ] "_comment": "returns the first 12 digits, without decimal }part"
    }
}

...

big_

...

numbers_3
Code Block
titlehavingbig_filter_count_by_decimal_1numbers_3
{
    "name": "havingbig_filter_count_by_decimal_1numbers_3",
    "type": "metric",
    "content": {
        "type": "function_countmultiply",
        "content": [
            {
                "type": "propertyfunction_sum",
                "valuecontent": "transactions.identifier"[
            }        {
]     }
}
filter_by_function_1
Code Block
titlefilter_by_function_1
{             "name": "filter_by_function_1",     "type": "metricproperty",
             "content":  {         "typevalue": "function_sum",transactions.value"
                    }
                ]
           "content": [ },
            {
                "type": "propertynumber",
                "value": "transactions6.value"789123435E7
            }
        ],
        "_comment": "returns the first 12 digits, with decimal part"
    }
}
filter_by_

...

date_

...

1
Code Block
titlefilter_by_function_todaydate_1
{
    "name": "filter_by_functiondate_today_1",
    "type": "metric",
    "content": {
        "type": "function_sum",
        "content": [
            {
                "type": "property",
                "value": "transactions.value"
            }
        ]
    }
}
filter_by_

...

not_

...

in_

...

attribute_1
Code Block
titlefilter_by_functionnot_datein_truncattribute_1
{
    "name": "filter_by_functionnot_datein_truncattribute_1",
    "type": "metric",
    "content": {
        "type": "function_sum",
        "content": [
            {
                "type": "property",
                "value": "transactionszsj_desc.valuepopulation"
            }
        ],
    }
}
filter_by_function_interval_1
Code Block
titlefilter_by_function_interval_1
{    "options": {
     "name": "filter_by_function_interval_1",       "typewithoutFilters": "metric",[
     "content": {         "type": "functiontransactions.store_sum"id"
            ],
            "contentfilterBy": [
                {
                    "typeproperty": "propertyzsj_desc.kod_zsj_d",
                    "valuequery": "transactions.value"{
             }         ]  "properties": [
 } } 
accept_aggr_by_1
Code Block
titleaccept_aggr_by_1
{     "name": "accept_aggr_by_1",             "type": "metric",     "content": {

       "type": "function_sum",         "content": [             { "id": "kod_zsj_d",
              "type": "property",                 "valuetype": "transactions.value"property",
              }         ],         "optionsvalue": {"zsj_desc.kod_zsj_d"
                      "acceptAggregateBy": [     }
           "zsj_desc"             ]
        }     } } 
accept_aggr_by_2
Code Block
titleaccept_aggr_by_2
{     "name": "accept_aggr_by_2"},
    "type": "metric",     "content": {         "typeoperator": "function_count",
 notInAttribute"
      "content": [         },
   {             {
   "type": "property",                 "valueproperty": "transactions.identifierstore_id",
            }        "value": ]101,
 
      "options": {             "acceptAggregateByoperator": ["eq"
                "zsj*"}
            ]
        }
    }
}

...

having_filter_

...

count_by_

...

decimal_1
Code Block
titleaccepthaving_filter_aggrcount_by_3decimal_1
{
    "name": "accepthaving_filter_aggrcount_by_3decimal_1",
    "type": "metric",
    "content": {
        "type": "function_count",
        "content": [
            {
                "type": "property",
                "value": "transactions.store_ididentifier"
            }
        ]
    }
}
filter_by_function_1
Code Block
titlefilter_by_function_1
{
    "name": "filter_by_function_1",
    "type": "metric",
    "optionscontent": {
        "type": "function_sum",
        "dontAggregateBycontent": [
            {
   "customers"             ]
"type": "property",
       }     }
}

...

    "value": "transactions.value"
            }
        ]
    }
}
filter_by_function_today_1
Code Block
titleacceptfilter_aggrby_byfunction_nulltoday_1
{
    "name": "acceptfilter_aggrby_byfunction_nulltoday_1",
    "type": "metric",
    "content": {
        "type": "function_sum",
        "content": [
            {
                "type": "property",
                "value": "transactions.value"
            }
        ],
        "options": {
            "acceptAggregateBy": [
                "zsj_desc",
                null
            ]
        }
    }
}

...

filter_by_

...

function_

...

date_

...

trunc_

...

1
Code Block
titleacceptfilter_by_aggrfunction_bydate_nulltrunc_21
{
    "name": "acceptfilter_by_aggrfunction_bydate_nulltrunc_21",
    "type": "metric",
    "content": {
        "type": "function_countsum",
        "content": [
            {
                "type": "property",
                "value": "transactions.identifiervalue"
            }
        ],
        "options": {
      
     "acceptAggregateBy": [
                null
            ]
        }
    }
}
filter_by_

...

function_

...

interval_

...

1
Code Block
titlefilter_by_attributefunction_twointerval_filters_nested_1
{
    "name": "filter_by_attributefunction_two_filtersinterval_nested_1",
    "type": "metric",
    "content": {
        "type": "function_sum",
        "content": [
            {
                "type": "property",
                "value": "transactions.value"
            }
        ]
    }
}

...

accept_aggr_by_

...

1
Code Block
titlefilteraccept_aggr_by_attribute_two_filters_nested_to_metric_1
{
    "name": "filteraccept_aggr_by_attribute_two_filters_nested_to_metric_1",
    "type": "metric",
    "content": {
        "type": "function_sum",
        "content": [
            {
                "type": "property",
                "value": "transactions.value"
            }
        ],
        "options": {
            "filterByacceptAggregateBy": [
                "zsj_desc"
     {
       ]
        }
    }
}
accept_aggr_by_2
Code Block
titleaccept_aggr_by_2
{
    "propertyname": "zsjaccept_desc.kodaggr_zsjby_d2",
    "type": "metric",
    "content": {
        "querytype": "function_count",
{        "content": [
            {
  "properties":  [            "type": "property",
               { "value": "transactions.identifier"
            }
        ],
        "idoptions": "kod_zsj_d",{
            "acceptAggregateBy": [
                  "typezsj*":
"property",            ]
        }
    }
}
accept_aggr_by_3
Code Block
titleaccept_aggr_by_3
{
    "valuename": "zsjaccept_desc.kodaggr_zsjby_d3",
    "type": "metric",
    "content": {
                }"type": "function_count",
        "content": [
            {
     {                "type": "property",
                "idvalue": "population_where_transactions.store_id_ne_101",
            }
        ],
          "typeoptions": "function_sum",{
               "dontAggregateBy": [
                "contentcustomers":
[            ]
        }
    }
}
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", {
                "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
            ]
        }
    }
}
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": {
        "type": "function_sum",
        "content": [
            {
                "type": "property",
                "value": "transactions.value"
            }
        ]
    }
}
filter_by_attribute_two_filters_nested_filters_1
Code Block
titlefilter_by_attribute_two_filters_nested_filters_1
{
    "name": "filter_by_attribute_two_filters_nested_filters_1",
    "type": "metric",
    "content": {
        "type": "function_sum",
        "content": [
            {
                "type": "property",
                "value": "transactions.value"
            }
        ]
    }
}
filter_by_attribute_two_filters_nested_to_metric_1
Code Block
titlefilter_by_attribute_two_filters_nested_to_metric_1
{
    "name": "filter_by_attribute_two_filters_nested_to_metric_1",
    "type": "metric",
    "content": {
        "type": "function_sum",
        "content": [
            {
                "type": "property",
                "value": "transactions.value"
            }
        ],
        "options": {
            "filterBy": [
                {
                    "property": "zsj_desc.kod_zsj_d",
                    "query": {
                        "properties": [
                            {
                                "id": "kod_zsj_d",
                                "type": "property",
                                "value": "zsj_desc.kod_zsj_d"
                            },
                            {
                                "id": "population_where_store_id_ne_101",
                                "type": "function_sum",
                                "content": [
                                    {
                                        "type": "property",
                                        "value": "zsj_desc.population"
                                    }
                                ],
                                "options": {
                                    "filterBy": [
                                        {
                                            "property": "zsj_desc.kod_zsj_d",
                                            "query": {
                                                "properties": [
                                                    {
                                                        "id": "kod_zsj_d",
                                                        "type": "property",
                                                        "value": "zsj_desc.kod_zsj_d"
                                                    },
                                                    {
                                                        "id": "aux_metric",
                                                        "type": "function_count",
                                                        "content": [
                                                            {
                                                                "type": "property",
                                                                "value": "zsj_desc.kod_zsj_d"
                                                            }
                                                        ],
                                                        "options": {
                                                            "withoutFilters": [
                                                                "*.*"
                                                            ],
                                                            "filterBy": [
                                                                {
                                                                    "property": "transactions.store_id",
                                                                    "value": 101,
                                                                    "operator": "eq"
                                                                }
                                                            ]
                                                        }
                                                    }
                                                ]
                                            },
                                            "operator": "inAttribute"
                                        }
                                    ]
                                }
                            }
                        ],
                        "having": [
                            {
                                "propertyId": "population_where_store_id_ne_101",
                                "value": 500,
                                "operator": "gte"
                            }
                        ]
                    },
                    "operator": "inAttribute"
                }
            ]
        }
    }
}
filter_by_attribute_two_filters_one_skippable_1
Code Block
titlefilter_by_attribute_two_filters_one_skippable_1
{
    "name": "filter_by_attribute_two_filters_one_skippable_1",
    "type": "metric",
    "content": {
        "type": "function_sum",
        "content": [
            {
                "type": "property",
                "value": "transactions.value"
            }
        ],
        "options": {
            "filterBy": [
                {
                    "property": "zsj_desc.kod_zsj_d",
                    "query": {
                        "properties": [
                            {
                                "id": "kod_zsj_d",
                                "type": "property",
                                "value": "zsj_desc.kod_zsj_d"
                            },
                            {
                                "id": "population_where_store_id_ne_101",
                                "type": "function_sum",
                                "content": [
                                    {
                                        "type": "property",
                                        "value": "zsj_desc.population"
                                    }
                                ],
                                "options": {
                                    "filterBy": [
                                        {
                                            "property": "zsj_desc.kod_zsj_d",
                                            "query": {
                                                "properties": [
                                                    {
                                                        "id": "kod_zsj_d",
                                                        "type": "property",
                                                        "value": "zsj_desc.kod_zsj_d"
                                                    },
                                                    {
                                                        "id": "aux_metric",
                                                        "type": "function_count",
                                                        "content": [
                                                            {
                                                                "type": "property",
                                                                "value": "zsj_desc.kod_zsj_d"
                                                            }
                                                        ],
                                                        "options": {
                                                            "withoutFilters": [
                                                                "*.*"
                                                            ]
                                                        }
                                                    }
                                                ]
                                            },
                                            "operator": "inAttribute",
                                            "_comment": "this attribute filter shloud be skipped, it has no filters"
                                        }
                                    ]
                                }
                            }
                        ],
                        "having": [
                            {
                                "propertyId": "population_where_store_id_ne_101",
                                "value": 500,
                                "operator": "gte"
                            }
                        ]
                    },
                    "operator": "inAttribute"
                }
            ]
        }
    }
}
filter_by_attribute_two_filters_flat_1
Code Block
titlefilter_by_attribute_two_filters_flat_1
{
    "name": "filter_by_attribute_two_filters_flat_1",
    "type": "metric",
    "content": {
        "type": "function_sum",
        "content": [
            {
                "type": "property",
                "value": "transactions.value"
            }
        ],
        "options": {
            "filterBy": [
                {
                    "property": "zsj_desc.kod_zsj_d",
                    "query": {
                        "properties": [
                            {
                                "id": "kod_zsj_d",
                                "type": "property",
                                "value": "zsj_desc.kod_zsj_d"
                            },
                            {
                                "id": "population_where_store_id_ne_101",
                                "type": "function_sum",
                                "content": [
                                    {
                                        "type": "property",
                                        "value": "zsj_desc.population"
                                    }
                                ],
                                "options": {
                                    "withoutFilters": [
                                        "zsjd_desc.*"
                                    ]
                                }
                            }
                        ],
                        "having": [
                            {
                                "propertyId": "population_where_store_id_ne_101",
                                "value": 500,
                                "operator": "gte"
                            }
                        ]
                    },
                    "operator": "inAttribute"
                },
                {
                    "property": "zsj_desc.kod_zsj_d",
                    "query": {
                        "properties": [
                            {
                                "id": "kod_zsj_d",
                                "type": "property",
                                "value": "zsj_desc.kod_zsj_d"
                            },
                            {
                                "id": "aux_metric",
                                "type": "function_count",
                                "content": [
                                    {
                                        "type": "property",
                                        "value": "zsj_desc.kod_zsj_d"
                                    }
                                ],
                                "options": {
                                    "withoutFilters": [
                                        "zsjd_desc.*"
                                    ]
                                }
                            }
                        ],
                        "filterBy": [
                            {
                                "property": "transactions.store_id",
                                "value": 101,
                                "operator": "eq"
                            }
                        ]
                    },
                    "operator": "inAttribute"
                }
            ]
        }
    }
}
skip_in_attribute_filter_1
Code Block
titleskip_in_attribute_filter_1
{
    "name": "skip_in_attribute_filter_1",
    "type": "metric",
    "content": {
        "type": "function_sum",
        "content": [
            {
                "type": "property",
                "value": "transactions.value"
            }
        ],
        "options": {
            "filterBy": [
                {
                    "property": "zsj_desc.kod_zsj_d",
                    "query": {
                        "properties": [
                            {
                                "id": "kod_zsj_d",
                                "type": "property",
                                "value": "zsj_desc.kod_zsj_d"
                            }
                        ]
                    },
                    "operator": "inAttribute"
                }
            ]
        }
    }
}
row_number_zsjd_store_by_revenue_1
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": [
            {
                "type": "function_sum",
                "content": [
                    {
                        "type": "property",
                        "value": "transactions.value"
                    }
                ]
            }
        ],
        "options": {
            "partitionBy": [
                "kod_zsj_d"
            ],
            "sort": "desc"
        }
    }
}
row_number_zsjd_store_avg_transaction_1
Code Block
titlerow_number_zsjd_store_avg_transaction_1
{
    "name": "row_number_zsjd_store_avg_transaction_1",
    "type": "metric",
    "content": {
        "type": "function_row_number",
        "content": [
            {
                "type": "function_divide",
                "content": [
                    {
                        "type": "function_sum",
                        "content": [
                            {
                                "type": "property",
                                "value": "transactions.value"
                            }
                        ],
                        "options": {
                            "filterBy": [
                                {
                                    "property": "transactions.value",
                                    "value": 0,
                                    "operator": "gte"
                                }
                            ]
                        }
                    },
                    {
                        "type": "function_count",
                        "content": [
                            {
                                "type": "property",
                                "value": "transactions.identifier"
                            }
                        ]
                    }
                ]
            }
        ],
        "options": {
            "partitionBy": [
                "kod_zsj_d"
            ],
            "sort": "desc"
        }
    }
}
row_number_store_by_transaction_count_1
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"
                    }
                ]
            }
        ],
        "options": {
            "sort": "desc"
        }
    }
}
can_7610_1
Code Block
titlecan_7610_1
{
    "name": "can_7610_1",
    "type": "metric",
    "content": {
        "type": "function_multiply",
        "content": [
            {
                "type": "function_sum",
                "content": [
                    {
                        "type": "property",
                        "value": "transactions.identifier"
                    }
                ]
            },
            {
                "type": "number",
                "value": 13.467
            }
        ]
    }
}
can_7610_2
Code Block
titlecan_7610_2
{
    "name": "can_7610_2",
    "type": "metric",
    "content": {
        "type": "function_plus",
        "content": [
            {
                "type": "number",
                "value": 13.467
            },
            {
                "type": "function_sum",
                "content": [
                    {
                        "type": "property",
                        "value": "transactions.identifier"
                    }
                ]
            }
        ]
    }
}
filter_by_attribute_combined_1
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"
            ],
            "filterBy": [
                {
                    "property": "zsj_desc.kod_zsj_d",
                    "query": {
                        "properties": [
                            {
                                "id": "kod_zsj_d",
                                "type": "property",
                                "value": "zsj_desc.kod_zsj_d"
                            }
                        ],
                        "filterBy": [
                            {
                                "property": "transactions.value",
                                "value": 45,
                                "operator": "gte"
                            }
                        ]
                    },
                    "operator": "inAttribute"
                },
                {
                    "property": "transactions.value",
                    "value": 25,
                    "operator": "gte"
                },
                {
                    "property": "transactions.store_id",
                    "value": 101,
                    "operator": "ne"
                }
            ]
        }
    }
}
filter_by_attribute_combined_cache_1
Code Block
titlefilter_by_attribute_combined_cache_1
{
    "name": "filter_by_attribute_combined_cache_1",
    "type": "metric",
    "content": {
        "type": "function_sum",
        "content": [
            {
                "type": "property",
                "value": "transactions.value"
            }
        ],
        "options": {
            "withoutFilters": [
                "transactions.store_id"
            ],
            "filterBy": [
                {
                    "property": "zsj_desc.kod_zsj_d",
                    "query": {
                        "properties": [
                            {
                                "id": "kod_zsj_d",
                                "type": "property",
                                "value": "zsj_desc.kod_zsj_d"
                            }
                        ],
                        "filterBy": [
                            {
                                "property": "transactions.value",
                                "value": 45,
                                "operator": "gte"
                            }
                        ]
                    },
                    "operator": "inAttribute"
                },
                {
                    "property": "transactions.value",
                    "value": 25,
                    "operator": "gte"
                },
                {
                    "property": "transactions.store_id",
                    "value": 101,
                    "operator": "ne"
                }
            ]
        }
    }
}
filter_pushdown_1
Code Block
titlefilter_pushdown_1
{
    "name": "filter_pushdown_1",
    "type": "metric",
    "content": {
        "type": "function_max",
        "content": [
            {
                "type": "property",
                "value": "customers.identifier"
            }
        ]
    }
}
filter_pushdown_2
Code Block
titlefilter_pushdown_2
{
    "name": "filter_pushdown_2",
    "type": "metric",
    "content": {
        "type": "function_sum",
        "content": [
            {
                "type": "property",
                "value": "transactions.value"
            }
        ]
    }
}
filter_pushdown_2_1
Code Block
titlefilter_pushdown_2_1
{
    "name": "filter_pushdown_2_1",
    "type": "metric",
    "content": {
        "type": "function_sum",
        "content": [
            {
                "type": "property",
                "value": "customers.identifier"
            }
        ]
    }
}
filter_pushdown_2_2
Code Block
titlefilter_pushdown_2_2
{
    "name": "filter_pushdown_2_2",
    "type": "metric",
    "content": {
        "type": "function_sum",
        "content": [
            {
                "type": "property",
                "value": "transactions.value"
            }
        ]
    }
}
aggr_by_customer_1
Code Block
titleaggr_by_customer_1
{
    "name": "aggr_by_customer_1",
    "type": "metric",
    "content": {
        "type": "function_sum",
        "content": [
            {
                "type": "property",
                "value": "transactions.value"
            }
        ],
        "options": {
            "aggregateBy": [
                "transactions.customer_id"
            ]
        }
    }
}
aggr_by_customer_2
Code Block
titleaggr_by_customer_2
{
    "name": "aggr_by_customer_2",
    "type": "metric",
    "content": {
        "type": "function_sum",
        "content": [
            {
                "type": "property",
                "value": "transactions.value"
            }
        ],
        "options": {
            "aggregateBy": [
                "transactions.store_id"
            ]
        }
    }
}
aggr_by_customer_3
Code Block
titleaggr_by_customer_3
{
    "name": "aggr_by_customer_3",
    "type": "metric",
    "content": {
        "type": "function_sum",
        "content": [
            {
                "type": "property",
                "value": "transactions.value"
            }
        ],
        "options": {
            "aggregateBy": [
                null
            ]
        }
    }
}
aggr_sum_of_max_by_store_1
Code Block
titleaggr_sum_of_max_by_store_1
{
    "name": "aggr_sum_of_max_by_store_1",
    "type": "metric",
    "content": {
        "type": "function_sum",
        "content": [
            {
                "type": "function_max",
                "content": [
                    {
                        "type": "property",
                        "value": "transactions.value"
                    }
                ],
                "options": {
                    "aggregateBy": [
                        "transactions.store_id"
                    ]
                }
            }
        ]
    }
}
aggr_sum_of_max_by_store_customer_1
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"
                    ]
                }
            }
        ]
    }
}
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": "metric",
    "content": {
        "type": "function_sum",
        "content": [
            {
                "type": "function_max",
                "content": [
                    {
                        "type": "property",
                        "value": "transactions.value"
                    }
                ],
                "options": {
                    "aggregateBy": [
                        "transactions.store_id",
                        "transactions.customer_id"
                    ],
                    "filterBy": [
                        {
                            "property": "transactions.store_id",
                            "value": 102,
                            "operator": "ne"
                        }
                    ]
                }
            }
        ]
    }
}
aggr_sum_by_store_of_max_by_customer_1
Code Block
titleaggr_sum_by_store_of_max_by_customer_1
{
    "name": "aggr_sum_by_store_of_max_by_customer_1",
    "type": "metric",
    "content": {
        "type": "function_sum",
        "content": [
            {
                "type": "function_max",
                "content": [
                    {
                        "type": "property",
                        "value": "transactions.value"
                    }
                ],
                "options": {
                    "aggregateBy": [
                        "transactions.store_id"
                    ]
                }
            }
        ]
    }
}
aggr_sum_of_max_by_zsjd_1
Code Block
titleaggr_sum_of_max_by_zsjd_1
{
    "name": "aggr_sum_of_max_by_zsjd_1",
    "type": "metric",
    "content": {
        "type": "function_sum",
        "content": [
            {
                "type": "function_max",
                "content": [
                    {
                        "type": "property",
                        "value": "transactions.value"
                    }
                ],
                "options": {
                    "aggregateBy": [
                        "zsj_desc.kod_zsj_d"
                    ]
                }
            }
        ]
    }
}
aggr_sum_of_max_multiply_number_1
Code Block
titleaggr_sum_of_max_multiply_number_1
{
    "name": "aggr_sum_of_max_multiply_number_1",
    "type": "metric",
    "content": {
        "type": "function_sum",
        "content": [
            {
                "type": "function_multiply",
                "content": [
                    {
                        "type": "number",
                        "value": 1000.0
                    },
                    {
                        "type": "function_max",
                        "content": [
                            {
                                "type": "property",
                                "value": "transactions.value"
                            }
                        ],
                        "options": {
                            "aggregateBy": [
                                "transactions.store_id"
                            ]
                        }
                    }
                ]
            }
        ]
    }
}
aggr_sum_of_max_multiply_min_1
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",
                "content": [
                    {
                        "type": "function_max",
                        "content": [
                            {
                                "type": "property",
                                "value": "transactions.value"
                            }
                        ],
                        "options": {
                            "aggregateBy": [
                                "zsj_desc.kod_zsj_d"
                            ]
                        }
                    },
                    {
                        "type": "function_min",
                        "content": [
                            {
                                "type": "property",
                                "value": "transactions.value"
                            }
                        ],
                        "options": {
                            "aggregateBy": [
                                "transactions.store_id"
                            ]
                        }
                    }
                ]
            }
        ]
    }
}
aggr_sum_by_customer_of_max_multiply_min_1
Code Block
titleaggr_sum_by_customer_of_max_multiply_min_1
{
    "name": "aggr_sum_by_customer_of_max_multiply_min_1",
    "type": "metric",
    "content": {
        "type": "function_sum",
        "content": [
            {
                "type": "function_multiply",
                "content": [
                    {
                        "type": "function_max",
                        "content": [
                            {
                                "type": "property",
                                "value": "transactions.value"
                            }
                        ],
                        "options": {
                            "aggregateBy": [
                                "zsj_desc.kod_zsj_d"
                            ]
                        }
                    },
                    {
                        "type": "function_min",
                        "content": [
                            {
                                "type": "property",
                                "value": "transactions.value"
                            }
                        ],
                        "options": {
                            "aggregateBy": [
                                "transactions.store_id"
                            ]
                        }
                    }
                ]
            }
        ]
    }
}
aggr_sum_of_max_plus_min_1
Code Block
titleaggr_sum_of_max_plus_min_1
{
    "name": "aggr_sum_of_max_plus_min_1",
    "type": "metric",
    "content": {
        "type": "function_plus",
        "content": [
            {
                "type": "function_sum",
                "content": [
                    {
                        "type": "function_max",
                        "content": [
                            {
                                "type": "property",
                                "value": "transactions.value"
                            }
                        ],
                        "options": {
                            "aggregateBy": [
                                "transactions.store_id"
                            ]
                        }
                    }
                ]
            },
            {
                "type": "function_min",
                "content": [
                    {
                        "type": "property",
                        "value": "transactions.value"
                    }
                ]
            }
        ]
    }
}
aggr_sum_by_zsjd_of_max_plus_min_1
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_sum",
                "content": [
                    {
                        "type": "function_max",
                        "content": [
                            {
                                "type": "property",
                                "value": "transactions.value"
                            }
                        ],
                        "options": {
                            "aggregateBy": [
                                "transactions.store_id"
                            ]
                        }
                    }
                ]
            },
            {
                "type": "function_min",
                "content": [
                    {
                        "type": "property",
                        "value": "transactions.value"
                    }
                ]
            }
        ]
    }
}
aggr_sum_of_max_without_nested_1
Code Block
titleaggr_sum_of_max_without_nested_1
{
    "name": "aggr_sum_of_max_without_nested_1",
    "type": "metric",
    "content": {
        "type": "function_sum",
        "content": [
            {
                "type": "function_max",
                "content": [
                    {
                        "type": "property",
                        "value": "transactions.value"
                    }
                ],
                "options": {
                    "aggregateBy": [
                        "transactions.store_id"
                    ],
                    "withoutFilters": [
                        "transactions.*"
                    ]
                }
            }
        ]
    }
}
aggr_sum_of_max_accept_aggr_by_1
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"
                    ]
                }
            }
        ]
    }
}
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": [
            {
                "type": "property",
                "value": "zsj_desc.population"
            }
        ],
        "options": {
            "withoutFilters": [
                "transactions.store_id"
            ],
            "filterBy": [
                {
                    "property": "zsj_desc.kod_zsj_d",
                    "query": {
                        "properties": [
                            {
                                "id": "kod_zsj_d",
                                "type": "property",
                                "value": "zsj_desc.kod_zsj_d"
                            },
                            {
                                "id": "transaction_sum_max_customer",
                                "type": "function_sum",
                                "content": [
                                    {
                                        "type": "function_max",
                                        "content": [
                                            {
                                                "type": "property",
                                                "value": "transactions.value"
                                            }
                                        ],
                                        "options": {
                                            "aggregateBy": [
                                                "transactions.customer_id"
                                            ]
                                        }
                                    }
                                ]
                            }
                        ],
                        "having": [
                            {
                                "propertyId": "transaction_sum_max_customer",
                                "value": 65,
                                "operator": "gte"
                            }
                        ]
                    },
                    "operator": "inAttribute"
                },
                {
                    "property": "transactions.store_id",
                    "value": 101,
                    "operator": "ne"
                }
            ]
        }
    }
}
aggr_max_by_zsjd_of_sum_by_store_1
Code Block
titleaggr_max_by_zsjd_of_sum_by_store_1
{
    "name": "aggr_max_by_zsjd_of_sum_by_store_1",
    "type": "metric",
    "content": {
        "type": "function_divide",
        "content": [
            {
                "type": "function_max",
                "content": [
                    {
                        "type": "function_sum",
                        "content": [
                            {
                                "type": "property",
                                "value": "transactions.value"
                            }
                        ],
                        "options": {
                            "aggregateBy": [
                                "transactions.store_id"
                            ]
                        }
                    }
                ]
            },
            {
                "type": "function_sum",
                "content": [
                    {
                        "type": "function_min",
                        "content": [
                            {
                                "type": "property",
                                "value": "zsj_desc.population"
                            }
                        ],
                        "options": {
                            "aggregateBy": [
                                "zsj_desc.kod_zsj_d"
                            ]
                        }
                    }
                ]
            }
        ]
    }
}
aggr_sum_of_count_by_store_1
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": "property",
                        "value": "transactions.identifier"
                    }
                ],
                "options": {
                    "aggregateBy": [
                        "transactions.store_id"
                    ]
                }
            }
        ]
    }
}
aggr_sum_of_count_dist_by_store_1
Code Block
titleaggr_sum_of_count_dist_by_store_1
{
    "name": "aggr_sum_of_count_dist_by_store_1",
    "type": "metric",
    "content": {
        "type": "function_sum",
        "content": [
            {
                "type": "function_count",
                "content": [
                    {
                        "type": "property",
                        "value": "zsj_desc.kod_zsj_d"
                    }
                ],
                "options": {
                    "aggregateBy": [
                        "transactions.customer_id"
                    ]
                }
            }
        ]
    }
}
aggr_count_by_customer_1
Code Block
titleaggr_count_by_customer_1
{
    "name": "aggr_count_by_customer_1",
    "type": "metric",
    "content": {
        "type": "function_count",
        "content": [
            {
                "type": "property",
                "value": "transactions.identifier"
            }
        ],
        "options": {
            "aggregateBy": [
                "transactions.customer_id"
            ]
        }
    }
}
aggr_count_dist_by_customer_1
Code Block
titleaggr_count_dist_by_customer_1
{
    "name": "aggr_count_dist_by_customer_1",
    "type": "metric",
    "content": {
        "type": "function_count",
        "content": [
            {
                "type": "property",
                "value": "transactions.processed_at"
            }
        ],
        "options": {
            "aggregateBy": [
                "transactions.customer_id"
            ]
        }
    }
}
can_8477_1
Code Block
titlecan_8477_1
{
    "name": "can_8477_1",
    "type": "metric",
    "content": {
        "type": "function_divide",
        "content": [
            {
                "type": "function_sum",
                "content": [
                    {
                        "type": "property",
                        "value": "transactions.value"
                    }
                ]
            },
            {
                "type": "function_sum",
                "content": [
                    {
                        "type": "property",
                        "value": "transactions.value"
                    }
                ],
                "options": {
                    "aggregateBy": [
                        null
                    ]
                }
            }
        ]
    }
}
aggr_max_sum_accept_aggregate_by_store_1
Code Block
titleaggr_max_sum_accept_aggregate_by_store_1
{
    "name": "aggr_max_sum_accept_aggregate_by_store_1",
    "type": "metric",
    "content": {
        "type": "function_max",
        "content": [
            {
                "type": "function_divide",
                "content": [
                    {
                        "type": "function_sum",
                        "content": [
                            {
                                "type": "property",
                                "value": "transactions.value"
                            }
                        ],
                        "options": {
                            "aggregateBy": [
                                "transactions.store_id"
                            ]
                        }
                    },
                    {
                        "type": "function_sum",
                        "content": [
                            {
                                "type": "property",
                                "value": "transactions.value"
                            }
                        ],
                        "options": {
                            "aggregateBy": [
                                "transactions.store_id"
                            ],
                            "acceptAggregateBy": [
                                "transactions"
                            ]
                        }
                    }
                ]
            }
        ]
    }
}
aggr_max_sum_dont_aggregate_by_store_1
Code Block
titleaggr_max_sum_dont_aggregate_by_store_1
{
    "name": "aggr_max_sum_dont_aggregate_by_store_1",
    "type": "metric",
    "content": {
        "type": "function_max",
        "content": [
            {
                "type": "function_divide",
                "content": [
                    {
                        "type": "function_sum",
                        "content": [
                            {
                                "type": "property",
                                "value": "transactions.value"
                            }
                        ],
                        "options": {
                            "aggregateBy": [
                                "transactions.store_id"
                            ]
                        }
                    },
                    {
                        "type": "function_sum",
                        "content": [
                            {
                                "type": "property",
                                "value": "transactions.value"
                            }
                        ],
                        "options": {
                            "aggregateBy": [
                                "transactions.store_id"
                            ],
                            "dontAggregateBy": [
                                "zsj_*"
                            ]
                        }
                    }
                ]
            }
        ]
    }
}
aggr_max_sum_accept_aggregate_all_1
Code Block
titleaggr_max_sum_accept_aggregate_all_1
{
    "name": "aggr_max_sum_accept_aggregate_all_1",
    "type": "metric",
    "content": {
        "type": "function_max",
        "content": [
            {
                "type": "function_divide",
                "content": [
                    {
                        "type": "function_sum",
                        "content": [
                            {
                                "type": "property",
                                "value": "transactions.value"
                            }
                        ],
                        "options": {
                            "aggregateBy": [
                                "transactions.store_id"
                            ]
                        }
                    },
                    {
                        "type": "function_sum",
                        "content": [
                            {
                                "type": "property",
                                "value": "transactions.value"
                            }
                        ],
                        "options": {
                            "aggregateBy": [
                                "transactions.store_id"
                            ],
                            "acceptAggregateBy": [
                                "*"
                            ]
                        }
                    }
                ]
            }
        ]
    }
}
aggr_max_by_store_by_client_1
Code Block
titleaggr_max_by_store_by_client_1
{
    "name": "aggr_max_by_store_by_client_1",
    "type": "metric",
    "content": {
        "type": "function_max",
        "content": [
            {
                "type": "function_divide",
                "content": [
                    {
                        "type": "function_sum",
                        "content": [
                            {
                                "type": "property",
                                "value": "transactions.value"
                            }
                        ],
                        "options": {
                            "aggregateBy": [
                                "transactions.store_id"
                            ]
                        }
                    },
                    {
                        "type": "function_count",
                        "content": [
                            {
                                "type": "property",
                                "value": "transactions.identifier"
                            }
                        ],
                        "options": {
                            "aggregateBy": [
                                "zsj_desc.kod_zsj_d"
                            ],
                            "filterBy": [
                                {
                                    "property": "transactions.customer_id",
                                    "value": "zsj_desc.population"2002,
                                    }
"operator": "eq"
                               ], }
                            ]
  "options": {                     }
               "filterBy": [    }
                ]
            }
      {  ]
    }
}
aggr_max_sum_accept_aggregate_by_store_one_agg_1
Code Block
titleaggr_max_sum_accept_aggregate_by_store_one_agg_1
{
    "name": "aggr_max_sum_accept_aggregate_by_store_one_agg_1",
    "type": "metric",
    "content": {
        "type": "function_max",
        "propertycontent": "zsj_desc.kod_zsj_d", [
            {
                "type": "function_sum",
                "querycontent": [
                    {
                        "type": "property",
                        "propertiesvalue": "transactions.value"
[                    }
                ],
                "options": {
                    "aggregateBy": [
                        "transactions.store_id"
         "id": "kod_zsj_d",          ],
                    "acceptAggregateBy": [
                        "type": "property",transactions"
                    ]
                }
            }
        ]
    }
}
aggr_max_sum_accept_aggregate_by_store_two_agg_1
Code Block
titleaggr_max_sum_accept_aggregate_by_store_two_agg_1
{
    "valuename": "zsj_desc.kod_zsj_d"
   aggr_max_sum_accept_aggregate_by_store_two_agg_1",
    "type": "metric",
    "content": {
        "type": "function_max",
        "content": [
            {
   },             "type": "function_plus",
                "content": [
                    {
                        "type": "function_sum",
                        "content": [
    "id": "aux_metric",                       {
                                 "type": "function_countproperty",
                                "value": "transactions.value"
                      "content": [     }
                        ],
                              "options": {
                            "aggregateBy": [
                                  "type": "property","transactions.store_id"
                                 ],
                               "valueacceptAggregateBy": "zsj_desc.kod_zsj_d"[
                                "transactions"
                           } ],
                            "filterBy":  [
                        ],                    {
                                    "optionsproperty": {"zsj_desc.kod_zsj_d",
                                    "value": 11111,
                      "withoutFilters": [             "operator": "eq"
                                }
                 "*.*"           ]
                        }
                        ]},
                                  {
                         "filterBytype": ["function_min",
                                   "content": [
                            {
                                "type": "property",
                                  "propertyvalue": "transactions.store_idvalue",
                            }
                                       "value": 101],
                            "options": {
                                       "operator"aggregateBy": "eq"[
                                "transactions.store_id"
                            ],
  }                          "acceptAggregateBy": [
                                "transactions"
]                                         ],
               }             "filterBy": [
                                {
     }                               "property": "zsj_desc.kod_zsj_d",
                ]                    "value": 33333,
                       },             "operator": "ne"
                              "operator": "inAttribute" }
                            ]
          }              }
                    }
 ]               ]
            }
    }    ]
    }
}
can_8366_1
Code Block
titlecan_8366_1
{
    "name": "can_8366_1",
    "type": "metric",
    "content": }{
        "type": "function_max",
        "content": [
    ],        {
                "havingtype": ["property",
                "value": "customers.identifier"
          {  }
        ]
    }
}
can_8366_2
Code Block
titlecan_8366_2
{
    "name": "can_8366_2",
    "type": "metric",
    "propertyIdcontent": "population_where_store_id_ne_101",{
        "type": "function_sum",
        "content": [
            {
"value": 500,               "type": "property",
                "operatorvalue": "gtetransactions.value"
            }
        ]
     }
}
one_metric_1
Code Block
titleone_metric_1
{
    "name": "one_metric_1",
    "type": "metric",
    "content": {
     ]   "type": "function_sum",
        "content": [
      },      {
                "operatortype": "inAttributeproperty",
                }"value": "transactions.value"
            ]}
        }]
    }
}

...

one_

...

metric_two_

...

attrs_1
Code Block
titlefilterone_bymetric_attribute_two_filters_one_skippableattrs_1
{
    "name": "filter_by_attribute_two_filters_one_skippableone_metric_two_attrs_1",
    "type": "metric",
    "content": {
        "type": "function_sum",
        "content": [
            {
                "type": "property",
                "value": "transactions.value"
            }
        ],
    }
   "options": {
       }
one_metric_two_primary_keys_1
Code Block
titleone_metric_two_primary_keys_1
{
    "filterByname": ["one_metric_two_primary_keys_1",
                {
                    "property"type": "zsj_desc.kod_zsj_d",
             metric",
      "querycontent": {
              "type": "function_sum",
         "propertiescontent": [
          
                 {
               
                "idtype": "kod_zsj_dproperty",
                                "type"value": "propertytransactions.value",
            }
        ]
    }
}
filter_by_metric_1
Code Block
titlefilter_by_metric_1
{
    "valuename": "zsjfilter_desc.kodby_zsjmetric_d1",
    "type": "metric",
    "content": {
                }"type": "function_sum",
        "content": [
            {
     {           "type": "property",
                    "idvalue": "population_where_store_id_ne_101",transactions.value"
            }
        ],
          "typeoptions": "function_sum",{
                          "withoutFilters": [
     "content": [             "transactions.processed_at"
            ],
          {  "filterBy": [
                {
                    "typeproperty": "propertytransactions.processed_at",
                    "query": {
                  "value": "zsj_desc.population"     "properties": [
                            {
 }                                 ]"id": "max_date",
                                "optionstype": {"function_max",
                                    "filterBycontent": [
                                        {
   
                                        "propertytype": "zsj_desc.kod_zsj_dproperty",
                                        "value": "transactions.processed_at"
   "query":  {                               }
                 "properties": [              ]
                            }
         {               ]
                    },
                    "idoperator": "kod_zsj_dinAttribute",
                },
                  {
                    "typeproperty": "propertytransactions.processed_at",
                                   "value": "2015-11-01",
                    "valueoperator": "zsj_desc.kod_zsj_dgte"
                },
                {
                  },  "property": "transactions.processed_at",
                    "value": "2015-11-07",
                    "operator": "lt"
     {           }
            ]
        }
    }
}
filter_by_metric_inherit_granularities_1
Code Block
titlefilter_by_metric_inherit_granularities_1
{
          "name": "filter_by_metric_inherit_granularities_1",
     "idtype": "aux_metric",
    "content": {
        "type": "function_sum",
        "content": [
             {
                "type": "function_countproperty",
                "value": "transactions.value"
            }
        ],
        "options": {
            "contentwithoutFilters": [
                "transactions.processed_at"
            ],
            "filterBy": [
                {
                    "property": "transactions.processed_at",
                    "query": {
                         "typeproperties": "property",[
                            {
                                   "valueid": "zsj_desc.kod_zsj_d"max_date",
                                "type": "function_max",
                          }      "content": [
                                    {
            ],                            "type": "property",
                           "options": {            "value": "transactions.processed_at"
                                    }
          "withoutFilters": [                     ],
                                           "*.*"
"options": {
                                    "acceptAggregateBy": [
                     ]                   "transactions"
                                    ]
}                                }
                    }        }
                        ]
               ]     },
                    "operator": "inAttribute"
                 },
                {
                           "operator"property": "inAttributetransactions.processed_at",
                      "value": "2015-11-01",
                     "_commentoperator": "this attributegte"
filter shloud be skipped, it has no filters"           },
                {
            }        "property": "transactions.processed_at",
                    "value": "2015-11-07",
     ]               "operator": "lt"
                }
            ]
        }
    }
 }
filter_by_metric_inherit_granularities_dont_1
Code Block
titlefilter_by_metric_inherit_granularities_dont_1
{
    "name": "filter_by_metric_inherit_granularities_dont_1",
    "type": "metric",
    "content": {
     ],   "type": "function_sum",
        "content": [
          "having": [ {
                "type": "property",
         {       "value": "transactions.value"
            }
           "propertyId": "population_where_store_id_ne_101",],
        "options": {
            "withoutFilters": [
         "value": 500,      "transactions.processed_at"
            ],
             "operatorfilterBy": "gte"[
                {
           }         "property": "transactions.processed_at",
               ]     "query": {
              },          "properties": [
         "operator": "inAttribute"                 } {
           ]         }     } } 
filter_by_attribute_two_filters_flat_1
Code Block
titlefilter_by_attribute_two_filters_flat_1
{     "nameid": "filter_by_attribute_two_filters_flat_1",max_date",
             "type": "metric",         "content": {         "type": "function_summax",
            "content": [                  {  "content": [
             "type": "property",                 "value": "transactions.value"    {
        }         ],         "options": {             "filterBytype": ["property",
                   {                     "propertyvalue": "zsj_desctransactions.kodprocessed_zsj_dat",
                    "query": {                  }
      "properties": [                         ],
   {                             "options": {
  "id": "kod_zsj_d",                                 "typedontAggregateBy": "property",[
                                "value": "zsj_desc.kod_zsj_d"       "customers"
                     },               ]
             {                   }
             "id": "population_where_store_id_ne_101",              }
                  "type": "function_sum",     ]
                    },
      "content": [             "operator": "inAttribute"
                },
     {                    {
                    "typeproperty": "propertytransactions.processed_at",
                       "value": "2015-11-01",
                    "valueoperator": "zsj_desc.populationgte"
                },
                {
  }                  "property": "transactions.processed_at",
             ],            "value": "2015-11-07",
                    "optionsoperator": {"lt"
                }
            ]
      "withoutFilters": [ }
    }
}
h3_grid_1
Code Block
titleh3_grid_1
{
    "name": "h3_grid_1",
    "type": "metric",
    "content": {
              "zsjd_desc.*""type": "function_h3_grid",
        "options": {
            "dataset": "customers",
            ]"resolution": 13
        },
        "content": [
            }{
                "type": "property",
          }      "value": "customers.lng"
            },
    ],        {
                "havingtype": ["property",
                "value": "customers.lat"
          {  }
        ]
    }
     }
h3_grid_2
Code Block
titleh3_grid_2
{
          "propertyId"name": "populationh3_where_store_id_ne_101grid_2",
    "type": "metric",
    "content": {
           "type": "function_sum",
        "valuecontent": 500,[
            {
                   "operatortype": "gteproperty",
                "value": "transactions.value"
          }  }
                      ]
    }
}
h3_grid_resultset_1
Code Block
titleh3_grid_resultset_1
{
    "name": "h3_grid_resultset_1",
       }"type": "metric",
          "content": {
         "operatortype": "inAttributefunction_h3_grid",
        "options": {
      },      "dataset": "customers",
         {   "resolution": 13
        },
        "propertycontent": "zsj_desc.kod_zsj_d", [
            {
        "query": {       "type": "property",
                "propertiesvalue": ["customers.lng"
            },
            {
  {              "type": "property",
                 "idvalue": "kod_zsj_d",customers.lat"
            }
        ]
    }
}
h3_grid_resultset_2
Code Block
titleh3_grid_resultset_2
{
    "typename": "propertyh3_grid_resultset_2",
    "type": "metric",
                "content": {
         "valuetype": "zsj_desc.kod_zsj_d"function_sum",
        "content": [
            {
       },         "type": "property",
                "value": "transactions.value"
{            }
        ]
    }
}
filter_by_function_h3_grid_1
Code Block
titlefilter_by_function_h3_grid_1
{
    "idname": "aux_metricfilter_by_function_h3_grid_1",
    "type": "metric",
    "content": {
           "type": "function_sum",
        "typecontent": "function_count",[
              {
                 "contenttype": ["property",
                "value": "transactions.value"
            }
     {   ]
    }
}
filter_by_function_h3_grid_eq_1
Code Block
titlefilter_by_function_h3_grid_eq_1
{
    "name": "filter_by_function_h3_grid_eq_1",
    "type": "metric",
    "content": {
            "type": "propertyfunction_sum",
        "content": [
            {
                 "valuetype": "zsj_desc.kod_zsj_d"property",
                   "value": "transactions.value"
                }
        ]
    }
}
filter_by_attribute_h3_grid_1
Code Block
titlefilter_by_attribute_h3_grid_1
{
    "name": "filter_by_attribute_h3_grid_1",
    "type": "metric",
    ],
"content": {
        "type": "function_sum",
        "content": [
           "options": {
                "type": "property",
                  "withoutFiltersvalue": ["transactions.value"
            }
        ]
    }
}
filter_by_attribute_h3_grid_two_resolutions_1
Code Block
titlefilter_by_attribute_h3_grid_two_resolutions_1
{
           "zsjd_desc.*""name": "filter_by_attribute_h3_grid_two_resolutions_1",
    "type": "metric",
    "content": {
        "type": "function_h3_grid",
        "options": {
    ]        "dataset": "customers",
            "resolution": 13,
         }   "filterBy": [
                {
       }             "function": {
          ],
                        "filterBytype": ["function_h3_grid",
                            {
   "options": {
                            "propertydataset": "transactions.store_idcustomers",
  
                             "valueresolution": 101,7
                             },
  "operator": "eq"                      "content": [
     }                       {
 ]                     },          "type": "property",
         "operator": "inAttribute"                 }     "value": "customers.lng"
      ]         }     } } 
skip_in_attribute_filter_1
Code Block
titleskip_in_attribute_filter_1
{     "name": "skip_in_attribute_filter_1" },
    "type": "metric",     "content": {         "type": "function_sum",       {
 "content": [             {                 "type": "property",
                "value": "transactions.value"                "value": "customers.lat"
  }         ],         "options": {       }
     "filterBy": [                 { ]
                   "property": "zsj_desc.kod_zsj_d" },
                    "query": {
                        "properties": [
                            {
                                "id": "kodh3_zsj_dgrid",
                                "type": "propertyfunction_h3_grid",
                                "valueoptions": "zsj_desc.kod_zsj_d" {
                                    "dataset": "customers",
}                         ]           "resolution": 7
        },                     "operator": "inAttribute"  },
              }             ]     "content": [
  }     } } 
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": [             {                 "type": "function_sum",property",
                                        "value": "contentcustomers.lng":
[                     {               },
         "type": "property",                         "value": "transactions.value" {
                    }                 ]   "type": "property",
        }         ],         "options": {             "partitionByvalue": "customers.lat"
 [                 "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": "function_divide",                 "content": [            "id": "customers_turnover",
       {                         "type": "function_sum",
                        "content": [       "content": [
                    {                {
                "type": "property",
                                "valuetype": "transactions.valueproperty",
                            }            "value": "transactions.value"
           ],                         "options":}
{                             "filterBy": [  ]
                            }
 {                       ],
             "property": "transactions.value",             "having": [
                       "value": 0,    {
                                "operatorpropertyId": "gtecustomers_turnover",
                                }"value": 200,
                            ]    "operator": "gte"
                   }         }
           },             ]
       {             },
           "type": "function_count",        "operator": "inAttribute"
               "content": [}
            ]
        },
      {  "content": [
            {
                "type": "property",
               ,
                "value": "transactionscustomers.identifierlng"
            },
            {
  }              "type": "property",
         ]       "value": "customers.lat"
            }
        ]
    }
}
filter_by_attribute_h3_grid_two_resolutions_2
Code Block
titlefilter_by_attribute_h3_grid_two_resolutions_2
{
     ]"name": "filter_by_attribute_h3_grid_two_resolutions_2",
    "type": "metric",
    "content": {
}         ]"type": "function_sum",
        "optionscontent": {[
            "partitionBy":{
[                "type": "kod_zsj_d"property",
                ],
"value": "transactions.value"
           "sort": "desc" }
        }]
    }
}

...

filter_

...

by_

...

attribute_

...

order_

...

1_1
Code Block
titlerowfilter_numberby_storeattribute_byorder_transaction1_count_1
{
    "name": "rowfilter_numberby_storeattribute_byorder_transaction1_count_1",
    "type": "metric",
    "content": {
        "type": "function_row_numbersum",
        "content": [
            {
                "type": "function_countproperty",
                "contentvalue": ["transactions.value"
            }
       { ],
        "options":  {
            "typewithoutFilters": "property",[
                "transactions.store_id"
       "value": "transactions.identifier"    ],
            "filterBy": [
  }              {
  ]             }         ]"property": "transactions.store_id",
        "options": {             "sortvalue": "desc"101,
        }     } } 
can_7610_1
Code Block
titlecan_7610_1
{     "nameoperator": "can_7610_1",
    "type": "metric",eq"
     "content": {         "type": "function_multiply" },
        "content": [         {
   {                 "typeproperty": "function_sumzsj_desc.kod_zsj_d",
                    "contentquery": [{
                      {  "properties": [
                     "type": "property",      {
                  "value": "transactions.identifier"             "id": "kod_zsj_d",
      }                 ]         "type": "property",
  },             {                 "typevalue": "number",zsj_desc.kod_zsj_d"
                 "value": 13.467          }
  }         ]     } } 
can_7610_2
Code Block
titlecan_7610_2
{     "name": "can_7610_2" ],
    "type": "metric",          "content": {         "typefilterBy": "function_plus", [
            "content": [             {  {
              "type": "number",                 "valueproperty": 13.467"transactions.value",
                  },             { "value": 15,
              "type": "function_sum",                 "contentoperator": "gte"
  [                     {     }
                   "type": "property",    ]
                    "value": "transactions.identifier"},
                     }"operator": "inAttribute"
                ]}
            }]
        ]}
    }
}
filter_by_attribute_

...

order_2_1
Code Block
titlefilter_by_attribute_order_combined2_1
{
    "name": "filter_by_attribute_order_combined2_1",
    "type": "metric",
    "content": {
        "type": "function_sum",
        "content": [
            {
                "type": "property",
                "value": "transactions.value".value"
            }
        ]
    }
}
filter_by_attribute_order_inject_inAttribute_1
Code Block
titlefilter_by_attribute_order_inject_inAttribute_1
{
    "name": "filter_by_attribute_order_inject_inAttribute_1",
    "type": "metric",
    "content": {
}         ]"type": "function_sum",
        "optionscontent": {[
            "withoutFilters":{
[                "type": "transactions.store_id"
    property",
       ],             "filterByvalue": ["transactions.value"
            }
   {     ]
    }
}
filter_by_attribute_order_nested_inAttributes_1
Code Block
titlefilter_by_attribute_order_nested_inAttributes_1
{
        "propertyname": "zsj_desc.kod_zsj_dfilter_by_attribute_order_nested_inAttributes_1",
               "type": "metric",
    "querycontent": {
           "type": "function_sum",
            "propertiescontent": [
            {
               {              "type": "property",
                  "idvalue": "kod_zsj_d",transactions.value"
            }
         ],
         "typeoptions": "property",{
            "filterBy": [
                  "value": "zsj_desc.kod_zsj_d"{
                    "property": "transactions.store_id",
       }                    "query": {
    ],                         "filterByproperties": [
                            {
                                "propertyid": "transactions.valuestore_id",
                                "valuetype": 45"property",
                                "operatorvalue": "gtetransactions.store_id"
                            },
                        ]    {
                },                     "operatorid": "inAttributestore_value",
                },                 {
      "type": "function_sum",
             "property": "transactions.value",                     "valuecontent": 25,[
                     "operator": "gte"              {
  },                 {                     "propertytype": "transactions.store_idproperty",
                    "value": 101,                     "operatorvalue": "netransactions.value"
                }
            ]         }
    } } 
filter_by_attribute_combined_cache_1
Code Block
titlefilter_by_attribute_combined_cache_1
{     "name": "filter_by_attribute_combined_cache_1",     "type": "metric",     "content": {        ]
"type": "function_sum",         "content": [             {    }
            "type": "property",           ],
     "value": "transactions.value"             }     "having": [
  ],         "options": {             "withoutFilters": [  {
              "transactions.store_id"             ],     "propertyId": "store_value",
      "filterBy": [                 {         "value": 111,
          "property": "zsj_desc.kod_zsj_d",                     "queryoperator": {"lte"
                        "properties": [   }
                        ]
{                    },
            "id": "kod_zsj_d",       "operator": "inAttribute"
                },
       "type": "property",        {
                        "valueproperty": "zsj_desc.kod_zsj_d"customers.identifier",
                    "query": {
       }                 "properties": [
      ],                      {
  "filterBy": [                             {"id": "customer",
                                "propertytype": "transactions.valueproperty",
                                "value": 45,"customers.identifier"
                            },
   "operator": "gte"                        {
    }                         ]        "id": "customer_value",
            },                     "operatortype": "inAttributefunction_sum",
                },                 {
   "content": [
                "property": "transactions.value",                     {
 "value": 25,                     "operator": "gte"                 },"type": "property",
                   {                     "propertyvalue": "transactions.store_idvalue",
                     "value": 101,              }
      "operator": "ne"                 }        ]
    ]         }     } } 
filter_pushdown_1
Code Block
titlefilter_pushdown_1
{     "name": "filter_pushdown_1",  }
  "type": "metric",     "content": {         "type": "function_max",     ],
   "content": [             {       "having": [
        "type": "property",                 "value": "customers.identifier" {
           }         ]     } } 
filter_pushdown_2
Code Block
titlefilter_pushdown_2
{     "namepropertyId": "filtercustomer_pushdown_2value",
     "type": "metric",       "content": {         "type": "function_sum",         "contentvalue": [
            {71.1,
                "type": "property",                 "valueoperator": "transactions.valuegt"
             }         ]     } }
filter_pushdown_2_1
Code Block
titlefilter_pushdown_2_1
{     "name": "filter_pushdown_2_1",     "type": "metric",     "content": {      ]
  "type": "function_sum",         "content": [         },
   {                 "typeoperator": "propertyinAttribute",
                "value": "customers.identifier"}
            ]
}         ]}
    }
}
filter

...

_by_attribute_order_two_inAttributes_1
Code Block
titlefilter_pushdown_2_2_by_attribute_order_two_inAttributes_1
{
    "name": "filter_pushdown_2_2by_attribute_order_two_inAttributes_1",
    "type": "metric",
    "content": {
        "type": "function_sum",
        "content": [
            {
                "type": "property",
                "value": "transactions.value"
            }
        ],
       } }
aggr_by_customer_1
Code Block
titleaggr_by_customer_1
{"options": {
      "name": "aggr_by_customer_1",     "typewithoutFilters": [
"metric",     "content": {         "type": "functiontransactions.store_sum"id"
            ],
            "contentfilterBy": [
                {
                    "typeproperty": "propertyzsj_desc.kod_zsj_d",

               "value": "transactions.value"     "query": {
      }         ],         "optionsproperties": {[
            "aggregateBy": [                 "transactions.customer_id"{
            ]         }     } } 
aggr_by_customer_2
Code Block
titleaggr_by_customer_2
{     "nameid": "aggrkod_byzsj_customer_2d",
    "type": "metric",        "content": {         "type": "function_sum",         "contenttype": "property",
  [             {                 "typevalue": "property",zsj_desc.kod_zsj_d"
                "value": "transactions.value"
            }
        ],         "options": {      ],
      "aggregateBy": [                 "transactions.store_id"filterBy": [
            ]         }     } } 
aggr_by_customer_3
Code Block
titleaggr_by_customer_3
{{
          "name": "aggr_by_customer_3",     "type": "metric",     "content": {         "typeproperty": "function_sumtransactions.value",
                 "content": [             { "value": 42.7,
              "type": "property",                 "valueoperator": "transactions.valuegte"
            }         ],       }
 "options": {             "aggregateBy": [         ]
       null             ]},
        }     } } 
aggr_sum_of_max_by_store_1
Code Block
titleaggr_sum_of_max_by_store_1
{     "nameoperator": "aggr_sum_of_max_by_store_1",inAttribute"
    "type": "metric",     "content": {         "type": "function_sum"},
        "content": [         {
   {                 "typeproperty": "functiontransactions.store_maxid",
                    "contentvalue": 101,
   [                 "operator": "eq"
   {             },
           "type": "property",    {
                    "valueproperty": "transactions.value"zsj_desc.kod_zsj_d",
                    "query": {
 }                 ],      "properties": [
         "options": {                  {
  "aggregateBy": [                         "transactions.store_id"    "id": "kod_zsj_d",
               ]                 }
"type": "property",
           }         ]     } } 
aggr_sum_of_max_by_store_customer_1
Code Block
titleaggr_sum_of_max_by_store_customer_1
{     "namevalue": "aggrzsj_sumdesc.kod_of_max_by_store_customer_1",zsj_d"
    "type": "metric",     "content": {         "type": "function_sum",        }
"content": [             {          ],
      "type": "function_max",                 "contentfilterBy": [
          [
          {                  {
      "type": "property",                         "valueproperty": "transactions.value",
                      }
          "value": 15,
               ],                 "optionsoperator": {"gte"
                        "aggregateBy": [   }
                     "transactions.store_id",   ]
                     "transactions.customer_id"},
                     ]"operator": "inAttribute"
                }
            }]
        ]}
    }
}

...

percent_

...

of_

...

total_1
Code Block
titleaggr_sumpercent_of_max_by_store_filter_total_1
{
    "name": "aggrpercent_sum_of_max_by_store_filter_total_1",
    "type": "metric",
    "content": {
        "type": "function_sumpercent_to_total",
        "content": [
            {
                "type": "function_maxcount",
                "content": [
                    {
                        "type": "property",
                        "value": "transactions.valuecustomer_id"
                    }
                ],
            }
        ]
    }
}
percent_of_total_nested_aggr_1
Code Block
titlepercent_of_total_nested_aggr_1
{
    "name": "percent_of_total_nested_aggr_1",
    "optionstype": "metric",
 {   "content": {
        "type": "function_percent_to_total",
        "aggregateBycontent": [
            {
              "transactions.store_id",  "type": "function_multiply",
                "content": [
           "transactions.customer_id"         {
                         ]"type": "function_count",
                        "filterBycontent": [
                            {
                                "propertytype": "transactions.store_idproperty",
                                "value": 102, "transactions.customer_id"
                            }
                   "operator": "ne"    ]
                    },
                    ]{
                }        "type": "function_sum",
   }         ]     } } 
aggr_sum_by_store_of_max_by_customer_1
Code Block
titleaggr_sum_by_store_of_max_by_customer_1
{     "namecontent": "aggr_sum_by_store_of_max_by_customer_1",[
    "type": "metric",     "content": {         "type": "function_sum",       {
 "content": [             {                 "type": "function_maxproperty",
                "content": [               "value": "transactions.value"
    {                        }
"type": "property",                         "value": "transactions.value"]
                     }
                ],
            }
    "options": {   ]
    }
}
sort_1
Code Block
titlesort_1
{
    "name": "sort_1",
    "aggregateBytype": ["metric",
    "content": {
        "type": "function_sum",
        "transactions.store_id"content": [
            {
                ]"type": "property",
                 }"value": "transactions.value"
            }
        ]
    }
}

...

sort_null_1
Code Block
titleaggrsort_sum_of_max_by_zsjd_null_1
{
    "name": "aggrsort_sum_of_max_by_zsjd_1",null_1",
    "type": "metric",
    "content": {
        "type": "function_plus",
        "content": [
            {
"type": "metric",     "content": {         "type": "function_sumifnull",
                "content": [
                    {
                        "type": "function_maxsum",
                        "content": [
                            {
                                "type": "property",
                                "value": "transactions.value"
                     }       }
         ],               ],
 "options":  {                     "aggregateByoptions": {
  [                          "zsj_desc.kod_zsj_d"
filterBy": [
                   ]             {
   }             }         ]     } } 
aggr_sum_of_max_multiply_number_1
Code Block
titleaggr_sum_of_max_multiply_number_1
{     "nameproperty": "aggr_sum_of_max_multiply_number_1transactions.store_id",
     "type": "metric",           "content": {         "type": "function_sum",         "contentvalue": [101,
                   {                 "typeoperator": "function_multiply",
   eq"
            "content": [                   }
 {                         "type": "number", ]
                       "value": 1000.0 }
                    },
                    {
                        "type": "function_maxnumber",
                        "contentvalue": [ 0.0
                    }
                ]
       {     },
            {
                "type": "propertyfunction_sum",
                "content": [
                    {
                        "type": "property",
                         "value": "transactions.value"
                    }
       }         ],
               ],    "options": {
                    "optionsfilterBy": [
                        {
                            "aggregateByproperty": ["transactions.store_id",
                            "value": 102,
  "transactions.store_id"                          "operator": "eq"
 ]                         }
                    }]
                ]}
            }
        ]
    }
}

...

sort_

...

null_2
Code Block
titleaggrsort_sum_of_max_multiply_min_1null_2
{
    "name": "aggrsort_sum_of_max_multiply_min_1null_2",
    "type": "metric",
    "content": {
        "type": "function_sumpercentile",
        "content": [
            {
                "type": "function_multiplyplus",
                "content": [
                    {
                        "type": "function_maxifnull",
                        "content": [
                            {
                                "type": "propertyfunction_sum",
                                "valuecontent": "transactions.value"[
                            }        {
                ],                         "optionstype": {"property",
                            "aggregateBy": [           "value": "transactions.value"
                    "zsj_desc.kod_zsj_d"                }
            ]                    ],
    }                     },       "options": {
            {                         "typefilterBy": "function_min",[
                        "content": [               {
             {                                 "typeproperty": "propertytransactions.store_id",
                                            "value": "transactions.value" 101,
                              }              "operator": "eq"
         ],                              "options": {}
                            "aggregateBy": [       ]
                         "transactions.store_id"       }
                     ]       },
                 }           {
         }                 ]      "type": "number",
     }         ]     } } 
aggr_sum_by_customer_of_max_multiply_min_1
Code Block
titleaggr_sum_by_customer_of_max_multiply_min_1
{     "name": "aggr_sum_by_customer_of_max_multiply_min_1",     "typevalue": "metric",0.0
    "content": {         "type": "function_sum",         "content": [   }
         {               ]
 "type": "function_multiply",                 "content": [ },
                    {
                        "type": "function_maxsum",
                        "content": [
                            {
                                "type": "property",
                                "value": "transactions.value"
                            }
                        ],
                        "options": {
                            "aggregateByfilterBy": [
                                "zsj_desc.kod_zsj_d"{
                            ]        "property": "transactions.store_id",
                }                    "value": }102,
                    {                         "type"operator": "function_mineq",
                        "content": [       }
                     {       ]
                        }
"type": "property",                   }
             "value": "transactions.value"  ]
            }
        ],
    }    "options": {
            "sort": "desc"
     ],   }
    }
}
sort_null_3
Code Block
titlesort_null_3
{
        "name": "sort_null_3",
     "optionstype": {"metric",
    "content": {
             "type": "function_rank",
        "aggregateBycontent": [
            {
                "type":   "transactions.storefunction_idplus",
                "content": [
          ]          {
              }          "type": "function_ifnull",
         }               "content": [
     ]             }         ] {
   } } 
aggr_sum_of_max_plus_min_1
Code Block
titleaggr_sum_of_max_plus_min_1
{     "name": "aggr_sum_of_max_plus_min_1",     "type": "metric",     "content": {         "type": "function_plussum",
              "content": [             {    "content": [
           "type": "function_sum",                   "content": [     {
               {                         "type": "function_maxproperty",
                          "content": [              "value": "transactions.value"
                 {                   }
             "type": "property",                  ],
              "value": "transactions.value"                 "options": {
          }                         ], "filterBy": [
                      "options": {                 {
           "aggregateBy": [                                "property": "transactions.store_id",
                            ]                "value": 101,
       }                     }                 ]"operator": "eq"
            },             {               }
 "type": "function_min",                 "content": [                ]
    {                         "type": "property",  }
                      "value": "transactions.value"     },
               }                 ]{
            }         ]     } }
aggr_sum_by_zsjd_of_max_plus_min_1
Code Block
titleaggr_sum_by_zsjd_of_max_plus_min_1
{     "nametype": "aggr_sum_by_zsjd_of_max_plus_min_1",number",
                       "type         "value": "metric",0.0
    "content": {         "type": "function_plus",         "content": [   }
         {               ]
 "type": "function_sum",                 "content": [ },
                    {
                        "type": "function_maxsum",
                        "content": [
                            {
                                "type": "property",
                                "value": "transactions.value"
                            }
                        ],
                        "options": {
                            "aggregateByfilterBy": [
                                "transactions.store_id"{
                            ]        "property": "transactions.store_id",
                }                    "value": 102,
     }                 ]             }, "operator": "eq"
          {                 "type": "function_min",    }
            "content": [               ]
     {                   }
     "type": "property",              }
          "value": "transactions.value"     ]
            }
  }      ],
        "options": {
]             }"sort": "desc"
        ]}
    }
}

...

sort_

...

null_asc_1
Code Block
titleaggrsort_sumnull_of_max_without_nested_asc_1
{
    "name": "aggrsort_sum_of_max_without_nestednull_asc_1",
    "type": "metric",
    "content": {
        "type": "function_sumplus",
        "content": [
            {
                "type": "function_maxifnull",
                "content": [
                    {
                        "type": "propertyfunction_sum",
                        "valuecontent": "transactions.value"[
                           } {
               ],                 "optionstype": {"property",
                                "aggregateByvalue": ["transactions.value"
                            }
 "transactions.store_id"                       ],
                        "withoutFiltersoptions": {
   [                         "transactions.*filterBy":  [
                  ]              {
  }             }         ]     } } 
aggr_sum_of_max_accept_aggr_by_1
Code Block
titleaggr_sum_of_max_accept_aggr_by_1
{     "nameproperty": "aggr_sum_of_max_accept_aggr_by_1",transactions.store_id",
     "type": "metric",           "content": {         "type": "function_sum",         "contentvalue": [101,
                   {                 "typeoperator": "function_max",eq"
                        "content": [       }
             {               ]
         "type": "property",              }
          "value": "transactions.value"         },
           }         {
       ],                 "optionstype": { "number",
                        "aggregateByvalue": 0.0
[                    }
    "transactions.store_id"            ]
        ],    },
            {
   "acceptAggregateBy": [            "type": "function_sum",
           "transactions"     "content": [
              ]      {
          }             } "type": "property",
      ]     } } 
filter_by_attribute_sum_of_max_1
Code Block
titlefilter_by_attribute_sum_of_max_1
{     "name": "filter_by_attribute_sum_of_max_1",     "typevalue": "metrictransactions.value",
    "content": {         "type": "function_sum",     }
   "content": [            ],
{                 "typeoptions": "property",{
                "value": "zsj_desc.population"       "filterBy": [
     }         ],         "options": {
            "withoutFilters": [                "property": "transactions.store_id",
            ],                "filterByvalue": [102,
                {            "operator": "eq"
       "property": "zsj_desc.kod_zsj_d",                }
    "query": {               ]
         "properties": [      }
            }
        ]
{    }
}
sort_null_asc_2
Code Block
titlesort_null_asc_2
{
    "name": "sort_null_asc_2",
    "type": "metric",
    "content": {
        "idtype": "kodfunction_zsj_dpercentile",
        "content": [
            {
                "type": "propertyfunction_plus",
                "content": [
              "value": "zsj_desc.kod_zsj_d"     {
                       }, "type": "function_ifnull",
                        "content": [
{                                 "id": "transaction_sum_max_customer",{
                                "type": "function_sum",
                                "content": [
                                    {
                                        "type": "function_maxproperty",
                                        "contentvalue": [ "transactions.value"
                                    }
      {                          ],
                      "type": "property",         "options": {
                                      "valuefilterBy": [
"transactions.value"                                        {
    }                                         ],"property": "transactions.store_id",
                                            "optionsvalue": {101,
                                            "aggregateByoperator": [ "eq"
                                        }
            "transactions.customer_id"                        ]
                    ]            }
                            },
                            {
       }                         "type": "number",
      ]                          "value": 0.0
    }                        }
],                        ]
 "having": [                  },
          {          {
                        "propertyIdtype": "transactionfunction_sum_max_customer",
  
                             "valuecontent": 65,[
                            {
   "operator": "gte"                             }"type": "property",
                        ]        "value": "transactions.value"
           },                 }
   "operator": "inAttribute"                 },   ],
             {           "options": {
        "property": "transactions.store_id",                     "valuefilterBy": 101,[
                    "operator": "ne"             {
   }             ]         }     } }
aggr_max_by_zsjd_of_sum_by_store_1
Code Block
titleaggr_max_by_zsjd_of_sum_by_store_1
{     "nameproperty": "aggr_max_by_zsjd_of_sum_by_transactions.store_1id",
       "type": "metric",         "content": {         "type": "function_divide",         "contentvalue": [102,
                   {                 "typeoperator": "function_max",eq"
                   "content": [            }
        {                    ]
    "type": "function_sum",                   }
     "content": [              }
              {  ]
            }
        ],
        "typeoptions": {
"property",            "sort": "desc"
        }
    }
}
sort_null_asc_3
Code Block
titlesort_null_asc_3
{
    "valuename": "transactions.value"sort_null_asc_3",
    "type": "metric",
    "content": {
        "type": "function_rank",
      }  "content": [
            {
        ],        "type": "function_plus",
                "optionscontent": {[
                    {
       "aggregateBy": [                "type": "function_ifnull",
               "transactions.store_id"         "content": [
                  ]          {
              }                  "type": "function_sum",
  }                 ]             },
"content": [
           {                 "type": "function_sum",       {
         "content": [                     {         "type": "property",
              "type": "function_min",                         "contentvalue": ["transactions.value"
                                   { }
                               "type": "property" ],
                                "valueoptions": "zsj_desc.population"{
                            }        "filterBy": [
               ],                         "options": {
                            "aggregateBy": [               "property": "transactions.store_id",
                "zsj_desc.kod_zsj_d"                             ]"value": 101,
                        }                     }"operator": "eq"
                ]             }         ]     }
} 
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": "property",                         "valuetype": "transactions.identifiernumber",
                    }            "value": 0.0
    ],                      "options": { }
                   "aggregateBy": [    ]
                    "transactions.store_id"},
                    ]{
                }        "type": "function_sum",
   }         ]     } } 
aggr_sum_of_count_dist_by_store_1
Code Block
titleaggr_sum_of_count_dist_by_store_1
{     "namecontent": "aggr_sum_of_count_dist_by_store_1",[
    "type": "metric",     "content": {         "type": "function_sum",       {
 "content": [             {                 "type": "function_countproperty",
                                "contentvalue": [ "transactions.value"
                           { }
                       "type": "property" ],
                        "valueoptions": "zsj_desc.kod_zsj_d"{
                    }        "filterBy": [
       ],                 "options": {       {
             "aggregateBy": [                      "property":   "transactions.customerstore_id",
                    ]                 }"value": 102,
               }         ]     } } 
aggr_count_by_customer_1
Code Block
titleaggr_count_by_customer_1
{     "nameoperator": "aggr_count_by_customer_1",eq"
               "type": "metric",       "content": {         "type": "function_count",}
         "content": [             {     ]
           "type": "property",            }
    "value": "transactions.identifier"             }  }
      ],         "options": {]
            "aggregateBy":}
[        ],
        "transactions.customer_idoptions": {
           ] "sort": "desc"
        }
    }
}

...

sort_

...

null_

...

inverse_

...

1
Code Block
titleaggrsort_count_dist_by_customernull_inverse_1
{
    "name": "aggrsort_countnull_dist_byinverse_customer_1",
    "type": "metric",
    "content": {
        "type": "function_countplus",
        "content": [
            {
                "type": "propertyfunction_ifnull",
                "valuecontent": "transactions.processed_at"[
             }       {
 ],         "options": {             "aggregateBytype": [ "function_sum",
                        "transactions.customer_id"content": [
            ]         }     } } 
can_8477_1
Code Block
titlecan_8477_1
{{
          "name": "can_8477_1",     "type": "metric",     "content": {         "type": "function_divideproperty",
        "content":  [             {         "value": "transactions.value"
      "type": "function_sum",                 "content": [   }
                 {       ],
                 "type": "property",      "options": {
                 "value": "transactions.value"          "filterBy": [
         }                 ]      {
      },             {                 "typeproperty": "functiontransactions.store_sumid",
                          "content": [         "value": 101,
          {                          "typeoperator": "propertyeq",
                        "value": "transactions.value"       }
             }               ]
 ],                 "options": {     }
               "aggregateBy": [    },
                    null{
                    ]    "type": "number",
           }             }
"value": 0.0
       ]     } } 
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": {     ]
   "type": "function_max",         "content": [},
             {
                "type": "function_dividesum",
                "content": [
                    {
                        "type": "function_sumproperty",
                        "contentvalue": ["transactions.value"
                    }
       {            ],
                    "typeoptions": "property",{
                    "filterBy": [
          "value": "transactions.value"             {
               }                  "property": "transactions.store_id",
      ],                         "optionsvalue": {102,
                            "aggregateByoperator": "eq"
 [                       }
         "transactions.store_id"           ]
                }
]            }
        ]
    }
}
sort_null_inverse_2
Code Block
titlesort_null_inverse_2
{
    "name": "sort_null_inverse_2",
    "type": "metric",
    "content": {
},        "type": "function_percentile",
        "content": [
    {        {
                "type": "function_sumplus",
 
                      "content": [
                    {
       {                 "type": "function_ifnull",
              "type": "property",         "content": [
                      "value": "transactions.value"     {
                       }                "type": "function_sum",
        ],                         "optionscontent": {[
                            "aggregateBy": [         {
                       "transactions.store_id"                 "type": "property",
           ],                             "acceptAggregateByvalue": ["transactions.value"
                                    }
 "transactions"                             ]  ],
                      }          "options": {
         }                 ]          "filterBy": [
 }         ]     } } 
aggr_max_sum_dont_aggregate_by_store_1
Code Block
titleaggr_max_sum_dont_aggregate_by_store_1
{     "name": "aggr_max_sum_dont_aggregate_by_store_1",     "type": "metric",     "content": {     {
   "type": "function_max",         "content": [             {                 "typeproperty": "functiontransactions.store_divideid",
                 "content": [                     {     "value": 101,
                  "type": "function_sum",                         "contentoperator": ["eq"
                            {            }
                    "type": "property",               ]
                 "value": "transactions.value"              }
              }              },
          ],                    {
    "options": {                             "aggregateBytype": ["number",
                                "transactions.store_id"value": 0.0
                            ]}
                        }]
                    },
                    {
                        "type": "function_sum",
                        "content": [
                            {
                                "type": "property",
                                "value": "transactions.value"
                            }
                        ],
                        "options": {
                            "aggregateByfilterBy": [
                                {
                                    "property": "transactions.store_id",
                            ],        "value": 102,
                                    "dontAggregateByoperator": ["eq"
                                "zsj_*"}
                            ]
                        }
                    }
                ]
            }
        ],
        "options": {
]             }"sort": "asc"
        ]}
    }
}

...

sort_

...

null_

...

inverse_3
Code Block
titleaggrsort_maxnull_sum_accept_aggregate_all_1inverse_3
{
    "name": "aggrsort_maxnull_sum_accept_aggregate_all_1inverse_3",
    "type": "metric",
    "content": {
        "type": "function_maxrank",
        "content": [
            {
                "type": "function_divideplus",
                "content": [
                    {
                        "type": "function_sumifnull",
                        "content": [
                            {
                                "type": "propertyfunction_sum",
                                "valuecontent": "transactions.value"[
                            }        {
                ],                         "optionstype": {"property",
                            "aggregateBy": [           "value": "transactions.value"
                    "transactions.store_id"                }
            ]                    ],
    }                     },       "options":  {
           {                         "typefilterBy": "function_sum",[
                        "content": [               {
             {                                 "typeproperty": "propertytransactions.store_id",
                                            "value": "transactions.value" 101,
                              }              "operator": "eq"
         ],                         "options": {     }
                       "aggregateBy": [            ]
                    "transactions.store_id"            }
                ],            },
                "acceptAggregateBy": [           {
                     "*"           "type": "number",
                ]                "value": 0.0
       }                     }
                  ]      ]
      }         ]     },
 } 
aggr_max_by_store_by_client_1
Code Block
titleaggr_max_by_store_by_client_1
{     "name": "aggr_max_by_store_by_client_1",     "type": "metric",     "content": {
        "type": "function_max",           "content": [    "type": "function_sum",
       {                 "typecontent": "function_divide",[
                "content": [           {
         {                         "type": "function_sum",property",
                                "contentvalue": ["transactions.value"
                            {}
                        ],
       "type": "property",                "options": {
               "value": "transactions.value"            "filterBy": [
               }                 {
       ],                         "options": {   "property": "transactions.store_id",
                        "aggregateBy": [           "value": 102,
                    "transactions.store_id"                "operator": "eq"
           ]                     }
   }                     },    ]
                {        }
                "type": "function_count",   }
                ]
    "content": [       }
        ],
        "options": {
  {          "sort": "asc"
        }
    }
}
sort_external_property_1
Code Block
titlesort_external_property_1
{
     "typename": "sort_external_property_1",
    "type": "metric",
    "content": {
           "type": "function_sum",
        "valuecontent": "transactions.identifier" [
            {
                 }"type": "property",
                "value": "transactions.value"
        ],    }
        ]
    }
}
sort_combined_1
Code Block
titlesort_combined_1
{
    "optionsname": {"sort_combined_1",
    "type": "metric",
    "content": {
        "type": "function_sum",
        "aggregateBycontent": [
            {
                 "type":  "zsj_desc.kod_zsj_d""property",
                "value": "transactions.value"
          ],  }
        ]
    }
   }
sort_asc_nulls_last_1
Code Block
titlesort_asc_nulls_last_1
{
        "filterByname": [
  "sort_asc_nulls_last_1",
    "type": "metric",
    "content": {
        "type": "function_plus",
       { "content": [
                {
                 "propertytype": "transactions.customerfunction_idifnull",
                "content": [
                  "value": 2002, {
                        "type": "function_sum",
         "operator": "eq"              "content": [
                 }           {
                 ]               "type": "property",
        }                     }   "value": "transactions.value"
            ]             }   }
     ]     } } 
aggr_max_sum_accept_aggregate_by_store_one_agg_1
Code Block
titleaggr_max_sum_accept_aggregate_by_store_one_agg_1
{     "name": "aggr_max_sum_accept_aggregate_by_store_one_agg_1",     "type": "metric" ],
    "content": {         "type": "function_max",         "contentoptions": [{
            {                 "typefilterBy": "function_sum", [
                      "content": [         {
           {                         "typeproperty": "propertytransactions.store_id",
                        "value": "transactions.value"           "value": 101,
        }                 ],           "operator": "eq"
    "options": {                     "aggregateBy": [     }
                   "transactions.store_id"         ]
           ],             }
       "acceptAggregateBy": [            },
            "transactions"        {
            ]            "type": "number",
   }             }         ]"value": 0.0
    }
}
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": {       ]
 "type": "function_max",         "content": [ },
            {
                "type": "function_plussum",
                "content": [
                    {
                        "type": "function_sumproperty",
                        "contentvalue": ["transactions.value"
                    }
                ],
  {              "options": {
                    "typefilterBy": "property",[
                        {
       "value": "transactions.value"                    "property": "transactions.store_id",
       }                     "value": 102,
   ],                         "optionsoperator": { "eq"
                        }
        "aggregateBy":  [          ]
                }
     "transactions.store_id"       }
        ]
    }
}
sort_asc_nulls_last_2
Code Block
titlesort_asc_nulls_last_2
{
     ],"name": "sort_asc_nulls_last_2",
    "type": "metric",
    "content": {
        "type": "function_percentile",
        "acceptAggregateBycontent": [
            {
                "type":   "transactionsfunction_plus",
                "content": [
          ],          {
                   "filterBy": [    "type": "function_ifnull",
                        "content": [
 {                           {
         "property": "zsj_desc.kod_zsj_d",                      "type": "function_sum",
             "value": 11111,                  "content": [
                 "operator": "eq"                  {
              }                          "type": "property",
 ]                         }              "value": "transactions.value"
     },                     {          }
              "type": "function_min",                 ],
       "content": [                        "options": {
   {                                 "typefilterBy": "property",[
                                  "value": "transactions.value"     {
                       }                     "property": "transactions.store_id",
  ],                         "options": {                "value": 101,
           "aggregateBy": [                                "operator": "transactions.store_ideq"
                            ],            }
                  "acceptAggregateBy": [                 ]
               "transactions"                 }
           ],                 },
           "filterBy": [                {
                {                "type": "number",
                   "property": "zsj_desc.kod_zsj_d",            "value": 0.0
                       "value": 33333,    }
                        ]
       "operator": "ne"            },
                    }{
                        "type": "function_sum",
  ]                      "content": [
 }                     }      {
          ]             }         ]
"type": "property",
   } } 
can_8366_1
Code Block
titlecan_8366_1
{     "name": "can_8366_1",     "type": "metric",     "content": {         "typevalue": "function_max",transactions.value"
            "content": [             {  }
              "type": "property",         ],
       "value": "customers.identifier"             }   "options": {
    ]     } } 
can_8366_2
Code Block
titlecan_8366_2
{     "name": "can_8366_2",     "type": "metric",     "contentfilterBy": {[
        "type": "function_sum",         "content": [             {
                "type": "property",                    "valueproperty": "transactions.value"store_id",
              }          ]     } } 
one_metric_1
Code Block
titleone_metric_1
{     "namevalue": "one_metric_1"102,
    "type": "metric",     "content": {         "type": "function_sum",         "content": [     "operator": "eq"
      {                 "type": "property",        }
        "value": "transactions.value"             }      ]
  ]     } } 
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",}
        ],
        "valueoptions": {
"transactions.value"             }"sort": "desc"
        ]}
    }
}

...

sort_

...

asc_

...

nulls_

...

last_

...

3
Code Block
titleonesort_metricasc_twonulls_primarylast_keys_13
{
    "name": "onesort_metricasc_twonulls_primarylast_keys_13",
    "type": "metric",
    "content": {
        "type": "function_sumrank",
        "content": [
            {
                "type": "propertyfunction_plus",
                "valuecontent": "transactions.value"
      [
     }         ]     } } 
filter_by_metric_1
Code Block
titlefilter_by_metric_1
{
    "name": "filter_by_metric_1",     "type": "metric",     "content": {         "type": "function_sum",
        "content": [
            {
     ifnull",
          "type": "property",                 "valuecontent": "transactions.value"[
            }         ],       {
 "options": {             "withoutFilters": [                "type": "transactions.processedfunction_at"sum",
                   ],             "filterBycontent": [
                     {               {
     "property": "transactions.processed_at",                     "query": {            "type": "property",
           "properties": [                             {"value": "transactions.value"
                                  "id": "max_date", }
                               "type": "function_max" ],
                                "contentoptions": {
 [                                   "filterBy": [
{                                         "type": "property",{
                                            "valueproperty": "transactions.processedstore_atid",
                                     }       "value": 101,
                             ]               "operator": "eq"
            }                         ]   }
                 },                   ]
 "operator": "inAttribute"                 },             }
   {                     "property": "transactions.processed_at",   },
                 "value": "2015-11-01",          {
          "operator": "gte"                 },    "type": "number",
           {                     "propertyvalue": "transactions.processed_at",0.0
                      "value": "2015-11-07",     }
               "operator": "lt"        ]
        }            },
]           }     } } 
filter_by_metric_inherit_granularities_1
Code Block
titlefilter_by_metric_inherit_granularities_1
{  {
  "name": "filter_by_metric_inherit_granularities_1",     "type": "metric",     "content": {         "type": "function_sum",
        "content": [
            {                 "typecontent": "property",[
                "value": "transactions.value"           {
 }         ],         "options": {            "type": "withoutFilters": [property",
                     "transactions.processed_at"           "value": "transactions.value"
],             "filterBy": [              }
  {                     "property": "transactions.processed_at", ],
                        "queryoptions": {
                            "propertiesfilterBy": [
                                {
                                    "idproperty": "maxtransactions.store_dateid",
                                    "typevalue": "function_max",102,
                                    "contentoperator": ["eq"
                                }
   {                         ]
               "type": "property",        }
                    }
           "value": "transactions.processed_at"    ]
            }
        ],
        "options": {
}            "sort": "desc"
        }
    }
}
sort_asc_nulls_first_1
Code Block
titlesort_asc_nulls_first_1
{
   ], "name": "sort_asc_nulls_first_1",
    "type": "metric",
    "content": {
        "type": "function_plus",
        "optionscontent": {[
            {
                "type": "function_ifnull",
     "acceptAggregateBy": [          "content": [
                    {
        "transactions"                "type": "function_sum",
                   ]     "content": [
                          }  {
                          }      "type": "property",
                 ]               "value": "transactions.value"
    },                     "operator": "inAttribute"  }
              },            ],
    {                     "propertyoptions": "transactions.processed_at",{
                     "value": "2015-11-01",      "filterBy": [
             "operator": "gte"                 }, {
               {                     "property": "transactions.processedstore_atid",
                    "value": "2015-11-07",               "value": 101,
      "operator": "lt"                 }             ]"operator": "eq"
        }     } } 
filter_by_metric_inherit_granularities_dont_1
Code Block
titlefilter_by_metric_inherit_granularities_dont_1
{     "name": "filter_by_metric_inherit_granularities_dont_1",     "type": "metric",     "content":}
{         "type": "function_sum",         "content": [        ]
    {                 "type": "property",  }
              "value": "transactions.value"     },
       }         ],    {
    "options": {             "withoutFilters": [     "type": "number",
          "transactions.processed_at"             ], "value": 0.0
          "filterBy": [         }
       {         ]
           "property": "transactions.processed_at" },
            {
       "query":  {       "type": "function_sum",
                "propertiescontent": [
                    {
       {                 "type": "property",
              "id": "max_date",         "value": "transactions.value"
                    }
 "type": "function_max",              ],
                  "contentoptions": [{
                    "filterBy": [
              {            {
                            "typeproperty": "propertytransactions.store_id",
                            "value": 102,
          "value": "transactions.processed_at"                 "operator": "eq"
                  }      }
                    ]
     ],           }
            }
        "options":]
{    }
   }
sort_asc_nulls_first_2
Code Block
titlesort_asc_nulls_first_2
{
    "name": "sort_asc_nulls_first_2",
    "type": "metric",
    "content": {
          "dontAggregateBytype": ["function_percentile",
        "content": [
            {
                "type": "customersfunction_plus",
                "content": [
                  ]  {
                        "type": "function_ifnull",
    }                    "content": [
       }                     {
   ]                     },        "type": "function_sum",
           "operator": "inAttribute"                 },   "content": [
            {                     "property": "transactions.processed_at",  {
                  "value": "2015-11-01",                     "operatortype": "gte"
         property",
      },                 {                     "propertyvalue": "transactions.processed_atvalue",
                    "value": "2015-11-07",                   }
 "operator": "lt"                 }             ],
        }     } } 
h3_grid_1
Code Block
titleh3_grid_1
{     "name": "h3_grid_1",     "type": "metric",     "contentoptions": {
        "type": "function_h3_grid",         "options": {             "dataset": "customers",   "filterBy": [
        "resolution": 13         },         "content": [             {
                "type": "property",                 "value": "customers.lng"             }"property": "transactions.store_id",
            {                 "type": "property",
                "value": "customers.lat"
            }101,
        ]     }
}
h3_grid_2
Code Block
titleh3_grid_2
{          "name": "h3_grid_2",     "type": "metric",     "content": {         "typeoperator": "function_sumeq",
        "content": [             {                 "type": "property", }
                "value": "transactions.value"             }      ]
  ]     } } 
h3_grid_resultset_1
Code Block
titleh3_grid_resultset_1
{     "name": "h3_grid_resultset_1",     "type": "metric",     "content": {     }
   "type": "function_h3_grid",         "options": {             "dataset": "customers" },
            "resolution": 13         },      {
  "content": [             {                 "type": "propertynumber",
                                "value": "customers0.lng"0
            },             {   }
             "type": "property",          ]
      "value": "customers.lat"             },
        ]        } } 
h3_grid_resultset_2
Code Block
titleh3_grid_resultset_2
{  {
  "name": "h3_grid_resultset_2",     "type": "metric",     "content": {         "type": "function_sum",
        "content": [                "content": [
  {                 "type": "property",        {
        "value": "transactions.value"             }         ] "type": "property",
  } } 
filter_by_function_h3_grid_1
Code Block
titlefilter_by_function_h3_grid_1
{     "name": "filter_by_function_h3_grid_1",       "type": "metric",     "content": {         "typevalue": "function_sum",transactions.value"
            "content": [             {  }
              "type": "property",         ],
       "value": "transactions.value"             }   "options": {
    ]     } } 
filter_by_attribute_h3_grid_1
Code Block
titlefilter_by_attribute_h3_grid_1
{     "name": "filter_by_attribute_h3_grid_1",     "type": "metric",     "contentfilterBy": {[
        "type": "function_sum",         "content": [             {
                "type": "property",                    "valueproperty": "transactions.value"store_id",
              }          ]     } } 
filter_by_attribute_h3_grid_two_resolutions_1
Code Block
titlefilter_by_attribute_h3_grid_two_resolutions_1
{     "namevalue": "filter_by_attribute_h3_grid_two_resolutions_1",102,
          "type": "metric",     "content": {         "type": "function_h3_grid",         "optionsoperator": "eq"
 {             "dataset": "customers",             "resolution": 13,   }
         "filterBy": [                 { ]
                   "function": {    }
                    "type": "function_h3_grid",}
                ]
        "options": {   }
        ],
        "options": {
      "dataset": "customers",     "sort": "desc"
        }
    }
   }
sort_asc_nulls_first_3
Code Block
titlesort_asc_nulls_first_3
{
    "resolutionname": 7"sort_asc_nulls_first_3",
    "type": "metric",
    "content": {
            },
          "type": "function_rank",
             "content": [
            {
               { "type": "function_plus",
                "content": [
            "type": "property",        {
                        "valuetype": "customers.lng"function_ifnull",
                        "content": [
  },
                            {
                                "type": "propertyfunction_sum",
                                "valuecontent": "customers.lat"[
                            }        {
                ]                     },   "type": "property",
                "query": {
                        "propertiesvalue": ["transactions.value"
                            {                 }
               "id": "h3_grid",                                 "type": "function_h3_grid"],
                                "options": {
                                    "datasetfilterBy": "customers",[
                                    "resolution": 7   {
                             },               "property": "transactions.store_id",
                "content": [                           "value": 101,
        {                                         "typeoperator": "propertyeq",
                                        }
  "value": "customers.lng"                                 ]
   },                             }
       {                     },
                   "type": "property",        {
                                "valuetype": "customers.latnumber",
                                "value": 0.0
  }                          }
      ]                  ]
          },          },
                  {       {
                         "idtype": "customersfunction_turnoversum",
                                "type"content": "function_sum",[
                            {
   "content": [                                     {
       "type": "property",
                                "typevalue": "propertytransactions.value",
                            }
           "value": "transactions.value"            ],
                        }"options": {
                            "filterBy": [
 ]                               }{
                        ],            "property": "transactions.store_id",
           "having": [                        "value": 102,
   {                                 "propertyIdoperator": "customers_turnover",eq"
                                }
  "value": 200,                         ]
       "operator": "gte"                }
            }        }
                ]
            }
       } ],
        "options": {
            "operatorsort": "inAttributedesc"
        }
    }
}
 }
expand_metric_1
Code Block
titleexpand_metric_1
{
    "name": "expand_metric_1",
    "type": "metric",
    "content": {
]         }"type": "function_divide",
        "content": [
            {
                "type": "propertymetric",
                "valuemetric": "customers.lng/rest/projects/test_query_service/md/metrics?name=turnover_metric"
            },
            {
                "type": "propertynumber",
                "value": "customers1000.lat"0
            }
        ]
    }
}

...

expand_

...

inattribute_

...

metric_1
Code Block
titlefilterexpand_byinattribute_attribute_h3_grid_two_resolutions_2metric_1
{
    "name": "filterexpand_byinattribute_attribute_h3_grid_two_resolutions_2metric_1",
    "type": "metric",
    "content": {
        "type": "function_sumdivide",
        "content": [
            {
                "type": "property"metric",
                "metric": "/rest/projects/test_query_service/md/metrics?name=turnover_metric"
            },
            {
                "valuetype": "number",
                "transactions.value": 1000.0
            }
        ]
    }
}