I am attempting to put together a metric for the number of verified and unverified articles in a given month (i.e., how many/what percentage of the unverified articles were verified over the past 30 days). I've created the following:
However, I don't think this is giving me the information I am looking for. What I believe this is showing is the number of articles that switched to "verified" status divided by the number of articles that switched to "verified" status plus the number of articles switched to "unverified" status. The problem is that this does not account for articles that switched to "unverified" status prior to 30 days ago and are still "unverified" this month. And because of this, it is not providing an accurate representation when I try to display this month to month. Any ideas/recommendations for calculating the right metric? Thanks!