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.
Hi,
It worked after fixing the counts and grand totals.
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