How to resample time series data?

[petercreateParticipant]

Hi dgteam,

I would like to know how I could make hourly or daily or monthly averages in DG if I have time-series data on a minute basis.

Best –

Peter

[dgteamModerator]

If you have a column of numbers that are minutes, you can convert to a date column type and set the options as shown below.

Then you can use this in the Pivot command.  Use the Map options to access the built-in options for averaging.

We just uploaded an example file to illustrate this approach.

Does this help you?

 

[Author]

Posts