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

Alteryx designer Discussions

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

Need help

Highlighted
Asteroid

Hi,

 

I have the data from 2016. I am using alteryx to know the how many total ID's and Total id's > 7 days till now. I created flag for total id's and Total id's >7 days. This  process is daily process. When i run alteryx workflow every monday, I want to see the total id's and Id's>7 days till saturday,sunday and monday like till monday. Please let me know if you have any questions.Thanks

 

 

My data is like below for ex:

DateTimeIDDays
10/11/201813
10/12/201822
10/11//201834
10/11/201842
10/13/201854
10/13/201865
10/14/201877
10/15/201888
7/14/20169676
12/6/201610678

 

I am expecting output like below:

 

DateTotalid'sTotal Id>7 days
10/13/20182010
10/14/2018158
10/15/2018106
Asteroid

 Can anyone help on this?

Nebula
Nebula

Hi @Pinky

 

You were asked for some sample data yesterday and a clarification for how you calculated some values, when you posted the exact same topic yesterday.  Instead of reposting, you should answer the questions of the people who were nice enough to offer to help.  With a little bit more data and clarification, I'm sure that @CharlieS or @Ladarthur would be able to help you.

 

 

Dan

Labels