Report on Organisation custom field updates in Explore

Hi all,

We use a custom organisation field (drop down) in Zendesk to record what pricing/service tier our customers are on. We currently run a report (outside of Zendesk) each month to show changes in plans, i.e. people who upgraded over the course of the last month.

Is there a way to do this in Explore? I have been tinkering for a while on it trying to finagle something using this to pull in the information I want but it doesn't appear to be possible. Is it possible to report on organisation-level updates or only on the ticket? So for example, say we have two levels, "Basic" and "Professional", we want a query that shows, in a given month, any org where the custom organisation field was changed from "Basic" to "Professional". We don't care about downgrades in this case although I'm assuming the same would be possible with the same solution to this, if there is one.

Cheers!