2 Replies Latest reply: Apr 3, 2017 4:49 AM by Pyry Kukkonen RSS

    Help needed with calculated dimensions

    Pyry Kukkonen

      Hi, I got a task to create a bar chart which should show number of open cases in each cluster. The clusters are based on how long the case has been open. The clusters are open for 0 days, open max 21 days (or 3 week) and open more than 3 weeks.


      At the moment my expression looks like this, but it's not for some reason display the cases which are closed "immediately"




                If (STRIVE_TIME <= 0, 'Zero' )))


      I have also tried to calculate the cluster based on difference of Registration Date and Strive Time, which is the way it "should" work.


      IF (REGISTRATION_DATE  - STRIVE_TIME => 21, 'Cluster >3')


      Unfortunately I can't share the application.