I need to calculate the maximum of an if condition per 2 ID columns:
Maximum of if ((issueorigin=‘completed’) and (changeto=‘In Progress’) and (changefield=‘status’) then, maximum(changecreation - date column) per issueid and sprintid) per (issueid and sprintid)
your sample doesn’t contain a column “datecolumn” and no row meets all 3 conditions. I will write down the general logic as I interpret your question:
Rule-Based Row Filter to keep only rows that meet all 3 criteria
calculate Max(changecreation, datecolumn) or (changecreation - datecolumn). It’s not clear to me which one is desired.
GroupBy with issueid and sprintid as group columns, aggregate calculated column from step 2 with Max()-Function.
Mathematical operations depend on the data type. Dates that have a nice string format can use string comparison, otherwise casting to other data types is required.