topic Help needed with calculated dimensions in App Development

Help needed with calculated dimensions

Anonymous — Mon, 03 Apr 2017 08:16:24 GMT

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.

Re: Help needed with calculated dimensions

MK_QSL — Mon, 03 Apr 2017 08:20:45 GMT

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

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

Dual('>3',3)))

Re: Help needed with calculated dimensions

Anonymous — Mon, 03 Apr 2017 08:48:16 GMT

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.