community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Announcement | We'll be doing maintenance between 9am-11am MT on Saturday, January 25th, which may impact your experience. Thanks for your patience as we work on improving the community!

How to aggregate time-series data weekly?

Highlighted
Meteor

I have a data in daily basis for a period of time (1 month of data). I would like to make an analysis in weekly basis. How can I make it so that I can get the value of total of record each week, which week with highest total and so on. Thank you in advance. 

Magnetar
Magnetar
Hi,

A summarize tool may give you what you need. You can attach several to your
data stream.

Count distinct can give you unique entries. To summarize by dates, add a
date as a grouping field, sum for any totals, max for highest, etc.

If you need to add across several columns, perhaps a formula tool before
the summarize.


Let me know if that helps.

Cheers!
Esther
--
Esther Bezborodko
*Senior Manager*
201.650.7314 | estherbezborodko@gmail.com
beautycounter.com/estherbezborodko

*Our mission is to get safe products in the hands of everyone.*
[image: Facebook]
Alteryx
Alteryx

Hi @muhalim 

 

You can use a formula tool to get the format of the date that you wish. I have attached one that will get the week number from the date field.

 

https://help.alteryx.com/2019.2/Reference/Functions.htm

 

The specifiers can be found in the above link, AKA %W is week number.

 

Once you have that field you can then use the summarise tool to group by that value and aggregate what you need.

Meteor

tq

Labels