Recent searches


No recent searches

Yarden Abukasis's Avatar

Yarden Abukasis

Joined May 13, 2021

·

Last activity Oct 26, 2021

Following

0

Followers

0

Total activity

2

Votes

0

Subscription

1

ACTIVITY OVERVIEW

Latest activity by Yarden Abukasis

Yarden Abukasis commented,

CommentMeasuring success

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