Does Denodo allow passing aggregates operations over an API?
I have a REST API and the user needs to select only 3 columns from that API, group by 2 columns and calculate aggregate(sum operation) over the third column. I am able to select three column and group by all three of them but I can't select 3 columns group 2 and compute SUM for the third column.
Here an example:
This is working
This isn't working