[Xymon] Metrics reports on red/yellow duration? Unacked? Splunk?

My grand-boss is looking to set some standards for how long we let reds and yellows go un-ACKed and un-resolved. There's a built in report but it seems to summarize total time red /yellow and what we're really interested in is how long it's taking us to respond.

Has anyone done anything with this?

I'm wondering if feeding the acklogs into splunk would let us work something up. And/or thinking about just trying to scrape this off the board.

Thoughts and code snippets welcome