Identifying the last earliest updated date

I have the following data where i need to identify the earliest updated date for a case. Please see data below, the identify if the last update date once the status changes to completed i highlighted the start in green and the end in yellow. attached a sample data

Question - 1.PNG

Sample Data.xlsx

Date Time

Fuzzy Match

Accepted answers

flying008

Hi, @Cherub7210

FYI. (by the way , your case only for last status is 'complete' or 'complete + cancelled' ?)

IF [case_status] = 'COMPLETED' 
THEN 'Yellow' 
ELSEIF [Tile_SequenceNum] = 1 and [Last_case_status] = 'COMPLETED' 
THEN 'Green' 
ELSE Null() 
ENDIF

录制_2024_11_19_09_45_32_381.gif

All comments

flying008

Hi, @Cherub7210

FYI. (by the way , your case only for last status is 'complete' or 'complete + cancelled' ?)

IF [case_status] = 'COMPLETED' 
THEN 'Yellow' 
ELSEIF [Tile_SequenceNum] = 1 and [Last_case_status] = 'COMPLETED' 
THEN 'Green' 
ELSE Null() 
ENDIF

录制_2024_11_19_09_45_32_381.gif

Manoj_k

hi @Cherub7210 the best way is to create a sample excel first with required option and then while taking output from the alteryx designer in the output tool select keep formation saved option.

beatriz_alteryx06

Hi @Cherub7210.

If you want to create a column with only the time before COMPLETE, create a new field in Multi Row Formula:

IIF( [case_status] ="COMPLETED", [Row-1:closed_dt_ts], Null() )

The other options is Generate Rows or Filter with formula, in this last case, for only the lines that have what you want.

Accep answer if it helped you

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703