3 Replies Latest reply on Jun 20, 2017 1:09 PM by Deepak Rai

    Getting values from datediff when date does not exist

    Gaurav Gupta

      Hello Everyone,

       

      I have a problem related to datediff function. Let me first show you screenshot-

       

      axis errror.jpg

       

      Here on the X-axis, expectation is to get -14+,-14,-13,-12,-11,-10..........................6,7,8,9,10,10+, these numbers come from calculations DATEDIFF('day',TODAY(),[DUE_DT]). Some numbers are missing cause few due_dt don't exist in database. My challenge is to show that datedifference with value 0.

       

      I explain it further - as shown in chart, there is no bar for -14,-10,-9,-8,-7 etc. I need to show these values in graph with 0 as bar value.

       

      Kindly help me on this.