Skip to content

    • APIs & Domo Developer

    APIs & Domo Developer

    Dategrain combined with aggregation

    Member
    in APIs & Domo Developer

    As I can read here: https://developer.domo.com/docs/dev-studio-references/data-api#aggregations


    "DATEGRAIN

    Perform a groupby with predefined date grains. By default, numerical columns are summed and unique entries of non-numerical columns are counted. Can be combined with an aggregation to override this default behavior."

    I would like to change the default sum to an average. How could this be changed?


    My query looks like this:

    1. var dataAggregateBy = 'day';
    2. var dategrain = [dataDateColumnName + ' by ' + dataAggregateBy];
    3. var query = `/data/v1/${datasets[0]}?fields=${fields.join()}&dategrain=${dategrain.join()}&filter=${filter.join()}`;
    Tagged:

    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

    Best Answers

    • Coach
      Answer ✓

      According to that documentation you should be able to supply it as a GET parameter with the value of a cvs list of fields you wish you average:

      1. var dataAggregateBy = 'day';
      2. var dategrain = [dataDateColumnName + ' by ' + dataAggregateBy];
      3. var query = `/data/v1/${datasets[0]}?avg=${avg_fields.join())&fields=${fields.join()}&dategrain=${dategrain.join()}&filter=${filter.join()}`;
      4.  
      **Was this post helpful? Click Agree or Like below**
      **Did this solve your problem? Accept it as a solution!**
    • Member
      Answer ✓

      Thank you for your response!

      I believe you mixed up ${avg_fields.join()) and ${avg_fields.join()}.

      But, other than that, it works!

    • Coach
      Answer ✓

      I did. Apologies! If you could accept the answer so others can made easily find it out they have the same question I’d appreciate it.

      **Was this post helpful? Click Agree or Like below**
      **Did this solve your problem? Accept it as a solution!**

    Answers

    • Coach
      Answer ✓

      According to that documentation you should be able to supply it as a GET parameter with the value of a cvs list of fields you wish you average:

      1. var dataAggregateBy = 'day';
      2. var dategrain = [dataDateColumnName + ' by ' + dataAggregateBy];
      3. var query = `/data/v1/${datasets[0]}?avg=${avg_fields.join())&fields=${fields.join()}&dategrain=${dategrain.join()}&filter=${filter.join()}`;
      4.  
      **Was this post helpful? Click Agree or Like below**
      **Did this solve your problem? Accept it as a solution!**
    • Member
      Answer ✓

      Thank you for your response!

      I believe you mixed up ${avg_fields.join()) and ${avg_fields.join()}.

      But, other than that, it works!

    • Coach
      Answer ✓

      I did. Apologies! If you could accept the answer so others can made easily find it out they have the same question I’d appreciate it.

      **Was this post helpful? Click Agree or Like below**
      **Did this solve your problem? Accept it as a solution!**

    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

    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