Skip to main content

My data isn't showing the results that I expected

Getting unexpected values from Origin Reports

J
Written by Jason Roberts
Updated over 4 years ago

If the chart that you produce in Origin Reports isn't showing the results you expected, try checking these items:

Filters:

Did you apply filters that you have used in the past? For example, if you have reported on turnaround time previously and excluded certain decision types (such as, immediate accept and immediate reject), you must be sure to apply these same filters in Origin Reports.

Editorial Status (Editorial Manager only):

A range of editorial statuses might be reported in your submission numbers depending on how your journal is setup in Editorial Manager. Please check the Editorial Status filter to ensure that you are including the statuses that you have historically included or it might be time to make a decision on which statuses you will choose to include moving forward. For more information on this topic, please check out the following article: Understanding Editorial Status

Date Range:

Check the date range and make sure that you are clear what data is being included in your chart. Were you expecting to report out on a single year, but the chart is including your entire date range? Have you eliminated partial years?

Most Recent CSV File:

Have you downloaded the most recent version of your CSV file from your manuscript handling system? Check the Date Range in the Data Selection menu tab to see the date range for your CSV file.

Odd values:

If you are seeing odd values in your charts, check your CSV file. Sometimes, the manuscript handling systems will give a data point an odd/erroneous value, such as a large negative number where only positive numbers are possible. We have seen cases of reviewers who completed their review within an hour accidently have their time to complete the review show up as a negative number. To find these types of anomalies, you may have to sort your data (smallest to largest) for each column that contains numbers or dates. Be sure to include all columns and rows of data when doing each sort so that you do not corrupt your data set. If you would like assistance, you can contact us through the chat feature Send a Message.

Why you may need to rerun your data from scratch:

In summary, if you are unclear how your data has historically been reported, it could well be that you are missing crucial filter or parameter information. Perhaps the person who previously created the charts for your journal scrubbed your data clean of problematic manuscripts or odd values. This may or may not have been documented. This does mean, unfortunately, that it may be impossible to recreate the past results. To make your data consistent for comparative purposes, rather than layer on new data, our suggestion, if feasible, is to rerun as much historical data as possible through Origin Reports. This means you can consistently report all of your data (historic and current) using the exact same parameters.

Did this answer your question?