I have a table of landowners that agent Kevin (filter) is handling.
Based on [Date], Kevin's first stage was "Passed to Agent" and the last stage was "Signed". I need a date different between those two stages without using a table calc. So I need first date and last day.
I tried first day by doing:
First Stage
{FIXED [Status],[Landowner]:MIN([Date])}
but when I bring that to rows, I don't get the 1/1/24 date like im expecting, I get all the dates all over again:
1 answer
Hi, @Nick Madison
The calculation is correct because it is calculated for each Status.
If you remove [Status] from the formula, it will work.
