curl --request POST \
--url http://api/v2/projects/{projectUuid}/query/metric-query \
--header 'Content-Type: application/json' \
--data '
{
"parameters": {},
"invalidateCache": true,
"context": "dashboardView",
"periodOverPeriod": {
"periodOffset": 123,
"granularity": "RAW",
"type": "previousPeriod",
"field": {
"table": "<string>",
"name": "<string>"
}
},
"pivotConfiguration": {
"sortBy": [
{
"direction": "ASC",
"reference": "<string>"
}
],
"groupByColumns": [
{
"reference": "<string>"
}
],
"valuesColumns": [
{
"aggregation": "sum",
"reference": "<string>"
}
],
"indexColumn": {
"type": "time",
"reference": "<string>"
}
},
"dateZoom": {
"xAxisFieldId": "<string>",
"granularity": "Day"
},
"query": {
"dateZoom": {
"xAxisFieldId": "<string>",
"granularity": "Day"
},
"filters": {
"tableCalculations": "<any>",
"metrics": "<any>",
"dimensions": "<any>"
},
"dimensions": [
"<string>"
],
"metrics": [
"<string>"
],
"tableCalculations": [
{
"type": "number",
"format": {
"type": "default",
"round": 123,
"separator": "default",
"currency": "<string>",
"compact": "thousands",
"prefix": "<string>",
"suffix": "<string>",
"timeInterval": "RAW",
"custom": "<string>"
},
"displayName": "<string>",
"name": "<string>",
"index": 123,
"sql": "<string>"
}
],
"exploreName": "<string>",
"sorts": [
{
"nullsFirst": true,
"descending": true,
"fieldId": "<string>"
}
],
"limit": 123,
"additionalMetrics": [
{
"label": "<string>",
"type": "percentile",
"description": "<string>",
"sql": "<string>",
"hidden": true,
"round": 123,
"compact": "thousands",
"format": "km",
"table": "<string>",
"name": "<string>",
"index": 123,
"filters": [
{
"values": [
"<any>"
],
"operator": "isNull",
"id": "<string>",
"target": {
"fieldRef": "<string>"
},
"settings": "<any>",
"disabled": true,
"required": true
}
],
"baseDimensionName": "<string>",
"uuid": "<string>",
"percentile": 123,
"formatOptions": {
"type": "default",
"round": 123,
"separator": "default",
"currency": "<string>",
"compact": "thousands",
"prefix": "<string>",
"suffix": "<string>",
"timeInterval": "RAW",
"custom": "<string>"
}
}
],
"customDimensions": [
{
"id": "<string>",
"name": "<string>",
"table": "<string>",
"type": "bin",
"dimensionId": "<string>",
"binType": "fixed_number",
"binNumber": 123,
"binWidth": 123,
"customRange": [
{
"to": 123,
"from": 123
}
]
}
],
"metadata": {
"hasADateDimension": {}
},
"timezone": "<string>",
"metricOverrides": {},
"periodOverPeriod": {
"periodOffset": 123,
"granularity": "RAW",
"type": "previousPeriod",
"field": {
"table": "<string>",
"name": "<string>"
}
}
}
}
'
