Approval rate statistics

[kmh11]

A graph of percentage of quotes approved over time (cumulative)

[tybug]

Is there a table that says when a quote was approved? django_admin_log or qdb_quote don't have a date_approved field.

[defund]

Nope, and the previous database doesn't contain that data either(?) Regardless, I think the timestamp and approved fields are enough, since moderators are expected to review quotes regularly.

[tybug]

Got it.

It seems that this graph would trend towards some percent as time increases, with recent approvals/denies having very little effect on the thousands pf previous quotes. Would a graph with each point considering only the past 30 days be more useful?

[defund]

Yeah, I don't think a cumulative graph is the best way to represent proportions. If anything, maybe a histogram with each bin being a year? This is all @kmh11 's idea anyways; ping ping

[kmh11]

This was actually Reynald's idea. I agree that a histogram is probably best. A possible (kind of hacky) way to do this would be to count used IDs out of total IDs for a time period, since unapproved quotes get deleted and their ID gets skipped over.