How to report on agent updates in Explore (when Agents have been downgraded to End users)?

The issue

The standard recommended approach when an agent leaves your Zendesk, is to downgrade them to the End-user role and suspend that user. However, this has an impact on historical data in Explore - since that user is no longer an agent, any query that reports on updates (like comments) by agents/end-users will be inaccurate. 

The former-agent updates will count as end-user comments.

A solution

One possible way to get accurate counts of updates is to create an Organization that all agents (and former agents) are part of and use this as a way to filter updates properly.

Above you can see two updates - one is a "Sample customer" (end-user) the other "Tom WAS an agent", you'll notice that both comments show up as End-user comment, even though Tom was an agent when he made those updates.