5 Replies Latest reply: Apr 4, 2016 8:23 AM by Kaushik Solanki RSS

    Chart depending on "if then" date comparison

    Peter Lassig

      I would like to show depending on a date comparison a donut chart. The followin expression gives me a bogus result:

      f((Date#(today(1),'DD.MM.YYYY')=>[DueDate]),Count([ActionPointID]))

       

      For a bar chart I used the following exspression, which does work just fine with the same data:

      if((Date#(today(1),'DD.MM.YYYY')>=[DueDate]),MonthName(Date#([DueDate],'DD.MM.YYYY')))

       

      What do I miss?

      Thank you