Help needed with calculated dimensions

[Anonymous]

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.

[MK_QSL · Accepted solution]

=IF(STRIVE_TIME<=0,Dual('Zero',1),

IF(STRIVE_TIME<=21,Dual('<3',2),

Dual('>3',3)))

[Anonymous]

Thank you @Manish Kacchia for the quick reply.

I started to think that maybe the issue is not after in a way I've been trying to calculate these clusters but rather in the way the open cases are being defined. My results are looking slightly different than they are looking in Cognos, in  which the dashboard I'm supposed to create with Sense was originally made. Maybe there are some additional filters used in Cognos which I'm still not aware of.