Hi,
I am making 2 sets of API calls
- aggregate metrics by day. In this case, 'day' is returned as an item ID associated with a specific variable of "variables/daterangeday"
- a series of calls - one for each daterangeday - and broken down by a dimension ("variables/product") which contains over 17K discrete values
My question is regarding the 2nd call here.
Can I pass a globalFilter to the 2nd call based on the dimension and item ID from the first call? If so, how do i structure the global filter list and what is the "type"? I'm including a request below however, the global filter section is where i need some guidance
Thanks
{
"rsid": "ZZZ",
"globalFilters": [
{
"type":"dimension",
"dimension": "variables/daterangemonth",
"itemId": "1111111"
}
],
"metricContainer": {
"metrics": [
{
"columnId": "0",
"id": "A",
"sort": "desc"
},
{
"columnId": "1",
"id": "B"
},
{
"columnId": "2",
"id": "C"
},
{
"columnId": "3",
"id": "D"
}
]
},
"dimension": "variables/product",
"settings": {
"countRepeatInstances": True,
"limit": 40000,
"page": 0,
"nonesBehavior": "return-nones"
},
"statistics": {
"functions": [
"col-max",
"col-min"
]
}
}