How to get sum of columns in the response

[bilal.tekin]

I am using a query and that query returns all the rows with columns. I can paginate so that I can see all the data. But I don’t want to paginate until last page. Is there a way to get the sum of the columns ? I can see the sums in the piwik dashboard but how can I get the sums with the API ?
I am adding the sums of columns which is already in the piwik dashboard, and the query that I am using. I need this api because I am using api in our backend and showing the result in our admin panel.

{
“date_from”: “2023-11-20”,
“date_to”: “2023-11-26”,
“period”: “range”,
“website_id”: “X”,
“offset”: 0,
“limit”: 10,
“columns”: [
{
“column_id”: “event_url”
},
{
“column_id”: “referrer_type”
},
{
“column_id”: “device_type”
},
{
“column_id”: “device_model”
},
{
“column_id”: “page_views”,
“transformation_id”: “sum”
},
{
“column_id”: “unique_page_views”
},
{
“column_id”: “entries”
},
{
“column_id”: “bounce_rate_events”
},
{
“transformation_id”: “average”,
“column_id”: “time_on_page”
},
{
“column_id”: “exit_rate”
}
],
“order_by”: [
[
4,
“desc”
]
],
“filters”: {
“operator”: “and”,
“conditions”: [
{
“operator”: “or”,
“conditions”: [
{
“column_id”: “event_type”,
“condition”: {
“operator”: “eq”,
“value”: 1
}
}
]
}
]
},
“metric_filters”: null
}

[Oliwer_Kaczmarek]

Here is example of API call that will return you sum of page views:
{
“date_from”: “2022-10-01”,
“date_to”: “2022-12-31”,
“website_id”: “{{ website_id }}”,
“offset”: 0,
“limit”: 10,
“columns”: [
{
“column_id”: “page_views”
}
],
“order_by”: [
[
0,
“desc”
]
],
“filters”: null,
“metric_filters”: null
}

You can achive the same thing with all other metrics that you want the sum of

Best,
Oliwer