0 Replies Latest reply: Aug 3, 2017 9:33 AM by Ipsita Mahapatra RSS

    How can I achieve the deviation in days calculating from Current date.

    Ipsita Mahapatra

      Hi Team,

       

      I need help to achieve the result for below formula. Can you please let me know what would be the correct expression so that i will get the result for the progress% of  my application. I have not used script loading. I have loaded my DB tables through data manager. so i need correct expression to apply to get the result.

       

      Progress (in days) = ( Current Date  - Average RegistrationDate)

       

      I have taken Date as in Filter visualization.

      Current date would be like whatever value I am selecting from Date filter. It can be the current system date or can be any other date which I will select from Date filter.

       

      RegistrationDate will be like follows:

      RegistrationDate

       

      12/1/2016
      12/7/2016
      12/7/2016
      12/7/2016
      12/7/2016
      11/1/2016
      12/5/2016
      12/5/2016
      5/9/2017
      5/9/2017
      11/15/2016

       

      Any help regarding same is highly appreciated.


      Thanks,

      Ipsita