Skip to content

    • Archive

    Archive

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

    Member
    in Archive

    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:

     

    1. 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):

     

    1. 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

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Comments

    • Member

      Can anyone help with this request?

    • Domo Employee

      Have you tried :

       

      1. 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. 

      Jake Galbraith
    • Member

      Hi Jake,

       

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

      When I do this:

      1. 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

    • Domo Employee

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

       

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

       

      Jake Galbraith
    • Member

      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

    • Domo Employee

      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.

      Jake Galbraith
    This discussion has been closed.

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Quick Links

    Categories