Recent searches
No recent searches

Killa Kam
Joined Nov 25, 2022
·
Last activity Nov 25, 2022
Following
0
Followers
0
Total activity
2
Votes
0
Subscription
1
ACTIVITY OVERVIEW
BADGES
ARTICLES
POSTS
COMMUNITY COMMENTS
ARTICLE COMMENTS
ACTIVITY OVERVIEW
Latest activity by Killa Kam
Killa Kam commented,
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