❄️✨Ho-ho-holiday offer for new projects! Check out our pricing page.

Custom API is not working for functions other than `count`

Answered
Leonardo asked on November 26, 2025

Hi,

I'm currently working on a PoC using custom API connecting to a Clickhouse database.

I'm having an issue when selecting sum aggregation (or any other function that is not count) for numeric values. 

The table does not display any results:

I believe the response is well formatted as compared to other responses that works:

{
"aggs": [
{
"values": {
"sale_quantity": {
"sum": 25650
}
},
"keys": {
"client_country": "",
"client_state": ""
}
},
{
"values": {
"sale_quantity": {
"sum": 470691.01269999996
}
},
"keys": {
"client_country": "",
"client_state": "AC"
}
},
{
"values": {
"sale_quantity": {
"sum": 5005541.6667
}
},
"keys": {
"client_country": "",
"client_state": "AL"
}
},
{
"values": {
"sale_quantity": {
"sum": 4822006.3344
}
},
"keys": {
"client_country": "",
"client_state": "AM"
}
},
{
"values": {
"sale_quantity": {
"sum": 67081
}
},
"keys": {
"client_country": "",
"client_state": "AP"
}
},
{
"values": {
"sale_quantity": {
"sum": 12944455.116100017
}
},
"keys": {
"client_country": "",
"client_state": "BA"
}
},
...
],
"page": 0,
"pageTotal": 1
}

If I change to count it works:

Thank you in advance.

 

2 answers

Public
Leonardo November 27, 2025

Hi,

It worked after fixing the counts and grand totals.

Public
Nadia Khodakivska Nadia Khodakivska Flexmonster November 27, 2025

Hello Leonardo,

Thank you for the update!

We are glad to hear that it works for you.

You are welcome to contact us if you have any further questions.

Kind regards,
Nadia

Please sign in or register to submit your answer