Getting Count Last Status Per Day

I have a database that tracks events as they occur. The events are used to track the completion of a series of tasks. The events have a event type id and a result. The type id is used to track a specific task, and there is a result for it.



so the table looks something like:



DATETIME, EVENT_ID, RESULT_CODE



Since the same task can be performed many times a day, I am only interested in getting a snapshot of all event types at 11:59:59 PM. If an Task of type A had a sucess event then failed event on the same day, I would count it as failed.



Additionally, I if an Task succeeded on say 5/18, an the same task did not occur on 5/19, I would want to count it as a success because that was the last known state from the 18th.



I need to produce a report showing our progress over time (I would guess plotting a line between 0 and 100%), around tasks that have passed, failed, and have not been completed. (no completion record exists)



As far as I can tell, I need to get the last known result, per event type, per day.



I know how to do this in TSQL, but my team is making a big bet in Analysis Server and I'm at a loss as to how I should tackle this.



Any help would be appreciated.