A measure that has improved over the years, with the improved pipeline and work the curators, has reduced the time it has taken to process a submission, it is useful to measure and track the processing time, to see how the database and curators have improved over time.
This is a relatively simple metric to track, submissions have a submitted date (Submitted) and an assigned date (Assigned), and the DAX for this is to simply minus the submitted date from the assigned date:
Processing_Time = 1.*(Sheet1[Assigned]-Sheet1[Submitted])
This provided a processing time in day. This could then be incorporated into a bar chart to see the how the processing time changes over the years.
I made several varieties of this chart, the first shows how each year differs, which can be useful to get a big picture idea of the changes. The next graph shows this change over every month, with the smaller incremental changes it is easier to track the small improvements in processing time. This could be useful to see if a new script or process has had an effect over a few months. The last graph is useful as it shows the change compared to the same time in the previous year.
Overall this was a very easy visual to create, it may require some cleaning as some submissions have issues with them, which causes a delay in the processing time, which is down to the submitter. It may be useful to omit these submissions, to provide a cleaner view of the data. For this I may need to add in another filter, to check if the submissions were waiting for information at any point.