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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
#SANTALYTICS

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More
We will be upgrading the Gallery to our 2019.4 release this Saturday, December 7th beginning at 9:00am MT. We expect the outage to take last approx. 2.5 hours.

How to aggregate time-series data weekly?

Atom

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.

Atom

tq

Labels