Hoping someone can help with this. I've included a small dummy table to illustrate what I'm trying to accomplish. The actual table has many thousands of rows and a wider date range. Essentially, I've been asked to enhance our current weekly report to flag where an applicant's offer status (OfferStatus field) has changed. I've tried both the peek function in the load script and the above function as part of an expression along with the aggr function in a chart but with limited success. Neither method is allowing me to compare the offer stats by applicant, rather its simply comparing them in a linear fashion as the rows appear in the table.
Does anyone have any ideas as to whether this is possible? (comparing the offer status by applicant to produce a expression value)
It would be difficulty to know without seeing... but may be you need to fix your Order By Statement for the other dimensional fields you have in you actual data set?
