4 Replies Latest reply: May 19, 2014 2:18 PM by Dinesh Reddy Seelam RSS

    Dates

    Dinesh Reddy Seelam

      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)

       

      BucketIDWSWECWSCWE
      30Days5147875/29/20085/28/20095/29/20095/28/2014
      30Days2494413/10/20096/09/20096/10/20096/9/2014
      30Days9991936/13/20096/12/20106/13/20106/12/2014
      30Days9546006/02/20096/01/20106/2/20106/1/2014
      30Days4970116/19/20096/18/20106/19/20106/18/2014
      30Days5623395/30/20095/31/20106/1/20105/31/2014
      30Days1849846/02/20096/01/20106/2/20106/1/2014
      30Days3596025/29/20095/28/20105/29/20105/28/2014
      30Days9835755/28/20095/27/20105/28/20105/27/2014
      30Days6205655/28/20095/27/20105/28/20105/27/2014
      30Days0721465/27/20095/26/20105/27/20105/26/2014
      30Days3377636/15/20096/14/20106/15/20106/14/2014
      30Days9054955/29/20095/28/20105/29/20105/28/2014
      30Days3598316/02/20096/01/20106/2/20106/1/2014
      30Days1797216/09/20096/08/20106/9/20106/8/2014
      30Days2364706/11/20096/10/20106/11/20106/10/2014
      30Days3944789/28/20109/27/20119/28/20115/27/2014
      30Days39950012/05/201212/04/201312/5/20136/4/2014
      30Days7140626/19/20126/18/20136/19/20136/18/2014

       

      Thanks in advance

        • Re: Dates

          I'm not sure I quite understand what you're asking, could you please rephrase it?

            • Re: Dates
              Dinesh Reddy Seelam

              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) ?


              BucketIDWSWECWSCWE
              30Days5147875/29/20085/28/20095/29/20095/28/2014
              30Days2494413/10/20096/09/20096/10/20096/9/2014
              30Days9991936/13/20096/12/20106/13/20106/12/2014

               

               

              Sorry for not elaborating Hope this helps

               

              Thanks

            • Re: Dates
              Anand Chouhan

              Can you elaborate more with sample out put what you required.

                • Re: Dates
                  Dinesh Reddy Seelam

                  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) ?


                  BucketIDWSWECWSCWE
                  30Days5147875/29/20085/28/20095/29/20095/28/2014
                  30Days2494413/10/20096/09/20096/10/20096/9/2014
                  30Days9991936/13/20096/12/20106/13/20106/12/2014

                   

                   

                  Sorry for not elaborating Hope this helps

                   

                  Thanks