Recent searches


No recent searches

Killa Kam's Avatar

Killa Kam

Joined Nov 25, 2022

·

Last activity Nov 25, 2022

Following

0

Followers

0

Total activity

2

Votes

0

Subscription

1

ACTIVITY OVERVIEW

Latest activity by Killa Kam

Killa Kam commented,

CommentWriting formulas

Hi Team,

Need some help here:

IF (VALUE(Full resolution time (min)) <= 60*5)       THEN  "< 5 hrs"    
ELIF (VALUE(Full resolution time (min)) <= 60*24)     THEN  "< 24 hrs"      
ELIF  (VALUE(Full resolution time (min)) <= 60*24*2)    THEN "< 48 hrs"  
ELIF  (VALUE(Full resolution time (min)) <= 60*24*7)    THEN "< Week"
ELIF  (VALUE(Full resolution time (min)) > 60*24*7)     THEN   "> A Week"
ENDIF

using this calculation, any results that fall in "< 5 hours" are not included in the "<24". Any that are included in <5 and <24, do not appear in <48 and so on. This is not how IF ELSE functions work. The above calculation actually works like this:

IF (VALUE(Full resolution time (min)) <= 60*5)       THEN  "< 5 hrs"    
ELIF (VALUE(Full resolution time (min)) > 60*5 AND VALUE(Full resolution time (min)) <= 60*24)     THEN  "< 24 hrs"      
ELIF  (VALUE(Full resolution time (min)) > 60*24 AND VALUE(Full resolution time (min)) <= 60*24*2)    THEN "< 48 hrs"  
ELIF  (VALUE(Full resolution time (min)) > 60*24*7 AND VALUE(Full resolution time (min)) <= 60*24*7)    THEN "< Week"
ELIF  (VALUE(Full resolution time (min)) > 60*24*7)     THEN   "> A Week"
ENDIF

This is incorrect behaviour.

Can you advise how i can have the first calculation working CORRECTLY? I want it to return the values I am asking for for my dashboard chart

My first idea was to simply do multiple IFs, but your columns do not support this. It has to be one calculation, not multiple.

Also, WHY cant you sort the results by the order in which I have provided them in the calculation? A-Z, Z-A, and by totals is not what I want. I want the results displayed the same order in which the formula is specifying

View comment · Edited Nov 25, 2022 · Killa Kam

0

Followers

0

Votes

0

Comments