Recent searches
No recent searches

Yarden Abukasis
Joined May 13, 2021
·
Last activity Oct 26, 2021
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 Yarden Abukasis
Yarden Abukasis commented,
I'm trying to create a table using full resolution time brackets but no matter what I do the order is showing as
when it definitely should be showing as
hours to days not with 5-24 hours out of order. I've tried all sorts of 'sorting' options and nothing seems to work
the query has them in the right order but that doesnt seem to stick when shown in the table itself
IF (VALUE(Full resolution time (min)) <= 60*5)
THEN "0-5 hrs"
ELIF (VALUE(Full resolution time (min))>60*5 AND VALUE(Full resolution time (min)) <= 60*24)
THEN "5-24 hrs"
ELIF (VALUE(Full resolution time (min))>60*24 AND VALUE(Full resolution time (min)) <= 60*24*7)
THEN "1-7 days"
ELIF (VALUE(Full resolution time (min))>60*24*7 AND VALUE(Full resolution time (min)) <= 60*24*30)
THEN "7-30 days"
ELIF (VALUE(Full resolution time (min)) > 60*24*30)
THEN ">30 days"
ELSE " Unsolved"
ENDIF
View comment · Posted Mar 25, 2021 · Yarden Abukasis
0
Followers
0
Votes
0
Comments