datatable aggregate by day

I have a dataTable that has columns that I would like to aggregate by the date part of the timestamp field but I'm not sure how to accomplish this.

1-Visitor

There are some JavaScript functions you can use to get the Date only from a Date/Time and then you can use the build in Aggregate service.

12-Amethyst

you can use this:

var params = {

types: 'STRING' /* STRING */,

t: events /* INFOTABLE */,

columns: 'date' /* STRING */,

expressions: 'timestamp.getUTCFullYear()+"/"+(timestamp.getMonth() + 1)+"/"+timestamp.getUTCDate() '/* STRING */

};

// result: INFOTABLE

var r = Resources["InfoTableFunctions"].DeriveFields(params);

Sign up