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<=21,'<-3',

          If(STRIVE_TIME>21,'>3',

                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.