Dategrain combined with aggregation

enara_martin

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:

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

GrantSmith

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:

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

enara_martin

Thank you for your response!

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

But, other than that, it works!

GrantSmith

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.