How to give an alias to an aggregation on a column?

user08715

Hi all,

 

I am using the Domo Api, and I need to group by the request on the sum of a column, just like below:

 

stringQuery= '/data/v1/dataSetAlias?fields=alias1,alias2&sum=alias3'
    + '&groupby=alias1,alias2,"sum=alias3"
    + '&orderby="sum=alias3" descending';

domo.get(stringQuery)
  ...

 

For now, i dont know a way to give an alias to "sum=alias3" so I can groupp by on it,
the only way that works is like below (not appliying the sum on the grouping or the ordering):

 

stringQuery= '/data/v1/dataSetAlias?fields=alias1,alias2&sum=alias3'
    + '&groupby=alias1,alias2,"alias3"
    + '&orderby="alias3" descending';

domo.get(stringQuery)
  ...

 But this doesn't give me the result I am waiting for.

 

Can you help me with this?

 

Thanks

 

Hiba

KaLin

Can anyone help with this request?

jake-galbraith

Have you tried :

 

stringQuery= '/data/v1/dataSetAlias?fields=alias1,alias2,alias3'
    + '&groupby=alias1,alias2,"sum=alias3"
    + '&orderby="alias3" descending';

When a groupby is present, you only want to specify the aggregation operator inside the group by clause. Let me know how this goes. 

user08715

Hi Jake,

 

Thanks for your answer.
But this is not working. The aggregation in the groupBy doesn't work.

When I do this:

stringQuery= '/data/v1/dataSetAlias?fields=alias1,alias2,alias3'
    + '&groupby=alias1,alias2,sum=alias3'
    + '&orderby=alias3 descending';

I have this error on the browser console:

Failed to load resource: the server responded with a status of 406 (Not Acceptable)
domo.js:5 Uncaught (in promise) Error: Not Acceptable
at XMLHttpRequest.o.onload (domo.js:5)

Any ideas? I really need to have the alias3 aggregated and the result sorted with it.

Thanks,

Hiba

jake-galbraith

Yes my mistake, this should hopefully do the trick. You just state the aggregation prior to the groupby. 

 

stringQuery= '/data/v1/dataSetAlias?fields=alias1,alias2,alias3'
    + '&sum=alias3&groupby=alias1,alias2,alias3'
    + '&orderby=alias3 descending';

 

user08715

Hi Jake,

 

Still not working.

Grouping by alias3 and not the aggregation of alias3 is splitting the result. And then I am having duplicated objects in place of grouping them and giving the total on alias3.

Help me please resolve this.

 

Thanks.

 

Hiba

jake-galbraith

Please do, let's get this working for you. You can send me a private message by clicking on my profile name and then on the right side click on send this user a private message.