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

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
Alteryx Certified Partner
Alteryx Certified Partner

Could you provide some further explanation on the calculations of your desired output? For example: how did you obtain the value of "20" for "Totalid's" on 10/13/2018?

Quasar
Quasar

Hi,

 

I think I don't get what you exactly want to do, would you have some sample data (made with excel) so as to see the formulas you would like to use and what do you want to calculate, I don't see what you want to calculate with your sample data right now :)

Asteroid

I have the data from 2016 from that data I am calculating the total id's and total id's >7 days. So my alteryx designed in a way that when ever i run i only get that day data and i am fine with that. Only when i run on monday i need to know saturday and sunday data. So my question is how to get the weekends data when i run on Monday.In one formula i should get saturday,sunday and monday data. Can you help me on the formula? Hope this clears please let me know.

Asteroid

I have the data from 2016 from that data I am calculating the total id's and total id's >7 days. So my alteryx designed in a way that when ever i run i only get that day data and i am fine with that. Only when i run on Monday i need to know Saturday and Sunday data. So my question is how to get the weekends data when i run on Monday.In one formula i should get Saturday,Sunday and Monday data. Can you help me on the formula? Hope this clears please let me know.

Asteroid

I have the sample data like below from 2016 but i just gave few dates. I need formula when i run on every Monday, I need to see the data for Saturday,Sunday and Monday. For Saturday date, Total ticket id's till the Saturday date, For Sunday, How many total id's till Sunday, For Monday, How many total Id's till Monday.I am using datetimetoday() getting the data till today. I need formula for Monday to get the Saturday,Sunday and Monday data and rest other days should get it like that data only. Can you help me with the formula

 

SubmitdateTicket ID
10/10/2018 17:081234
10/11/2018 0:58112
10/12/2018 8:05111
10/13/2018 1:06121
10/14/2018 12:09122
10/14/2018 21:14123
10/12/2018 18:22124
10/12/2018 18:26125
10/10/2018 5:03126
10/10/2018 5:03127
10/10/2018 5:09128
10/2/2018 4:41129
10/2/2018 6:19130
10/2/2018 6:22131
10/15/2018 0:04132
10/15/2018 0:45133
10/15/2018 1:04134
10/15/2018 1:08135
Asteroid

Can you help me on this? please let me know if you have any questions.Thanks!

Asteroid

I have a couple reports that have different requirements on Mondays.  My solution may not be a perfect match for your situation but maybe there is enough here to get you going in the right direction.

 

Here's what I do to make them work:

 

The following formula creates a new column titled "Hours To Look Back"

 

if DateTimeFormat(DateTimeToday(),"%A") = "Monday"
THEN 56
ELSE 12
ENDIF

 

If it's Monday, the report generates a value of 56, otherwise 12.

 

I then use a filter to filter out files with a creation time less than 12 hours old or less than 56 hours old, depending on the current day:

 

DateTimeDiff(DateTimeNow(),[CreationTime],"hours") < [Hours To Look Back]

 

 

Asteroid

Hi,

 

I have the sample data like below.I have the data from 2016 to till today everyday data will get added.But only given few dates below.  When i see Monday data will be there till Monday like below.

 

Sample Data: 
DateId's
10/15/2018 21:161
10/15/2018 23:331
10/15/2018 23:461
10/13/2018 1:201
10/13/2018 8:461
10/13/2018 14:121
10/14/2018 12:091
10/15/2018 5:041
10/15/2018 6:241
10/15/2018 16:231
10/13/2018 0:021
10/15/2018 13:541
10/14/2018 11:441
10/14/2018 19:001
10/14/2018 19:151

 

I need a formula to calculate Saturday,Sunday and Monday for Monday when i ran my workflow like below. 

 

Output 
DateTotal id's
10/13/20184
10/14/20188
10/15/201812

 

Quasar
Quasar

Hi,

 

I did a sample workflow for you with a part of your data and added other, tell me if it works!

Labels