8 Replies Latest reply: Aug 4, 2015 5:35 AM by Peter Svendsen RSS

    Can I count dates not reached deadline?

    Peter Svendsen

      Hi all,

       

      I would like to make a chart that show s numbers of cases not reaching the deadline.

       

      In my xls file I have a columb called "Due date" and a columb called "Approved date" so if the "Approved date" is not done before the "due date" it should cound as 1.

       

      I was considering as expression under the chart something like

      Count({<[Due date]>>[Approved date]>})

       

      But I get an error....

       

      Thanks

      Peter