Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Every one,
Have an issue displaying only following dates, If you see below data it is easy to display following 1day in same row by using an expression Count(DISTINCT if([WE]-[CS]=-1,SID)) in the straight table what if I want to show the data CWS in the below row following 1day after CWE in the above row (basically comparing dates in different rows and columns)
Bucket | ID | WS | WE | CWS | CWE |
30Days | 514787 | 5/29/2008 | 5/28/2009 | 5/29/2009 | 5/28/2014 |
30Days | 249441 | 3/10/2009 | 6/09/2009 | 6/10/2009 | 6/9/2014 |
30Days | 999193 | 6/13/2009 | 6/12/2010 | 6/13/2010 | 6/12/2014 |
30Days | 954600 | 6/02/2009 | 6/01/2010 | 6/2/2010 | 6/1/2014 |
30Days | 497011 | 6/19/2009 | 6/18/2010 | 6/19/2010 | 6/18/2014 |
30Days | 562339 | 5/30/2009 | 5/31/2010 | 6/1/2010 | 5/31/2014 |
30Days | 184984 | 6/02/2009 | 6/01/2010 | 6/2/2010 | 6/1/2014 |
30Days | 359602 | 5/29/2009 | 5/28/2010 | 5/29/2010 | 5/28/2014 |
30Days | 983575 | 5/28/2009 | 5/27/2010 | 5/28/2010 | 5/27/2014 |
30Days | 620565 | 5/28/2009 | 5/27/2010 | 5/28/2010 | 5/27/2014 |
30Days | 072146 | 5/27/2009 | 5/26/2010 | 5/27/2010 | 5/26/2014 |
30Days | 337763 | 6/15/2009 | 6/14/2010 | 6/15/2010 | 6/14/2014 |
30Days | 905495 | 5/29/2009 | 5/28/2010 | 5/29/2010 | 5/28/2014 |
30Days | 359831 | 6/02/2009 | 6/01/2010 | 6/2/2010 | 6/1/2014 |
30Days | 179721 | 6/09/2009 | 6/08/2010 | 6/9/2010 | 6/8/2014 |
30Days | 236470 | 6/11/2009 | 6/10/2010 | 6/11/2010 | 6/10/2014 |
30Days | 394478 | 9/28/2010 | 9/27/2011 | 9/28/2011 | 5/27/2014 |
30Days | 399500 | 12/05/2012 | 12/04/2013 | 12/5/2013 | 6/4/2014 |
30Days | 714062 | 6/19/2012 | 6/18/2013 | 6/19/2013 | 6/18/2014 |
Thanks in advance
I'm not sure I quite understand what you're asking, could you please rephrase it?
Can you elaborate more with sample out put what you required.
I need all the ID's where CWS following next day of WE in one table which I achieved using expression Count(DISTINCT if([WE]-[CS]=-1,ID))
In other table I need all the ID's where CWS following next day of CWE in the above row
For example in the below table give me the ID's if CWS in the 2nd row(with ID 249441) follows CWE in the 1st row (with ID 514787) same if CWS in the 3rd row(ID 999193) follows CWE in the 2nd row (ID 249441) ?
Bucket | ID | WS | WE | CWS | CWE |
30Days | 514787 | 5/29/2008 | 5/28/2009 | 5/29/2009 | 5/28/2014 |
30Days | 249441 | 3/10/2009 | 6/09/2009 | 6/10/2009 | 6/9/2014 |
30Days | 999193 | 6/13/2009 | 6/12/2010 | 6/13/2010 | 6/12/2014 |
Sorry for not elaborating Hope this helps
Thanks
I need all the ID's where CWS following next day of WE in one table which I achieved using expressionCount(DISTINCT if([WE]-[CS]=-1,ID))
In other table I need all the ID's where CWS following next day of CWE in the above row
For example in the below table give me the ID's if CWS in the 2nd row(with ID 249441) follows CWE in the 1st row (with ID 514787) same if CWS in the 3rd row(ID 999193) follows CWE in the 2nd row (ID 249441) ?
Bucket | ID | WS | WE | CWS | CWE |
30Days | 514787 | 5/29/2008 | 5/28/2009 | 5/29/2009 | 5/28/2014 |
30Days | 249441 | 3/10/2009 | 6/09/2009 | 6/10/2009 | 6/9/2014 |
30Days | 999193 | 6/13/2009 | 6/12/2010 | 6/13/2010 | 6/12/2014 |
Sorry for not elaborating Hope this helps
Thanks