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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
SOLVED

Weekends as separate

Highlighted
Meteor

Hi all,

I have a data set as list of dates with the type as shown in image1. But i need a new type as weekends as shown in image 2. 

image1.PNGimage2.PNG

 

Anybody help in this!!!!

I have attached a sample file along with this.

 

 

Regards,

Yoganantha Prakash G P

2018-12-17_08-07-03.png

 

I suggest using a generate rows to create all the days and then summarising back together. You need to use a multi-row formula tool to create the groupings.

 

Sample attached.

Meteor

Thanks jdunkerley

Labels