Skip to content
iclock 8 Minutes - Read Now
idate

Case Volume Data Should Tell the Right Story

Ethics and compliance teams rely on case volume data to help leadership understand what is happening across the organization. But […]

Bill Coffin
Bill Coffin Editor-in-Chief, Ethisphere Magazine, Ethisphere
Case Volume Data Should Tell the Right Story

Ethics and compliance teams rely on case volume data to help leadership understand what is happening across the organization. But even a seemingly technical reporting decision, such as whether to date cases by the day they open or the day they close, can shape the story that data tells.

That choice matters because case data rarely serves only one purpose. The same dataset may need to support board oversight, measure investigation timeliness, identify emerging risk, and show whether training or communications are prompting employees to ask better questions. One date cannot always do all of that work.

The better approach is to start with the audience and the decision the data is meant to support. For some reporting needs, close date is the most useful anchor. For others, open date provides a clearer picture. In many mature ethics and compliance programs, the answer is to track and report both.

Board Reporting Needs a Clear View of Risk and Responsiveness

When case volume data appears in board reporting, directors usually need a disciplined, high-level view of the organization’s risk profile and the program’s ability to respond. They are not typically looking for a technical debate over which date field drives the chart.

The board is likely to care about several core questions: How many concerns are being raised? What types of issues are employees reporting? Where are those issues arising? What percentage of matters are substantiated? How often do employees report anonymously? What discipline or remediation follows? How long does the organization take to investigate and close matters?

Those questions require clarity and consistency. They also require more than one lens.

Close date is especially useful when the organization needs to report on investigation timeliness. Days to close is a key process metric because unresolved matters can erode trust. Employees who speak up want to know that the organization takes concerns seriously, and long delays can discourage future reporting. For board oversight, the ability to investigate and resolve issues in a timely way is not an administrative detail. It is a signal of program health.

Open date, however, helps directors understand when concerns entered the system and whether reporting patterns align with known events. If a spike in cases follows a leadership change, a site visit, a training campaign, or a communications push, the open date can help explain that pattern. It gives ethics and compliance leaders a better way to connect employee behavior to program activity.

The point is not that one date is “right” and the other is “wrong.” The point is that each date answers a different governance question.

Open Date Helps Measure Whether Employees Are Engaged

Open date becomes especially valuable when ethics and compliance teams want to understand whether employees are responding to program activity. Training and communications are not successful simply because employees completed a module or opened an email. They are successful when employees use that information to make better decisions, ask sharper questions, or raise concerns earlier.

Consider a training session on proper handling of competitive information. If an employee attends the training and, two weeks later, reaches out before attending an industry event because they have a question about what they can discuss, that is meaningful evidence of engagement. The employee remembered the guidance, recognized the relevance to their work, and sought help before the issue became a problem.

A close-date view could obscure that connection. If the inquiry or case closes weeks later, the data may no longer align with the training event that prompted the employee to act. An open-date view gives ethics and compliance teams a cleaner way to evaluate whether training, communications, site visits, or targeted interventions are changing behavior.

That matters because increased reporting after a program activity is not always a bad sign. It may indicate that employees are paying attention. It may show that the program has made a risk more visible, lowered the barrier to asking questions, or helped employees recognize conduct that deserves review.

For that reason, open-date reporting can be especially useful for program effectiveness analysis. Teams can examine what happens in the weeks following a training, leadership visit, awareness campaign, policy rollout, or other intervention. The pattern may not prove causation on its own, but it can give the ethics and compliance function a stronger basis for understanding what is resonating with employees.

Close Date Helps Measure Whether the Process Is Working

If open date helps explain when employees act, close date helps explain how well the organization responds.

Investigation timeliness is one of the clearest examples. A case that remains open for too long can create frustration for reporters, witnesses, subjects of the investigation, managers, and business leaders. Even when delays are unavoidable, the perception of inaction can damage trust.

That makes close-date reporting useful for measuring operational performance. It can help the ethics and compliance function track average time to close, identify aging matters, compare resolution timelines across regions or issue types, and spot bottlenecks in the investigative process.

Close date can also support reporting on completed outcomes, such as substantiation, discipline, remediation, and lessons learned. These are the data points that often matter most when leadership wants to understand not only what was reported, but what the organization did in response.

A close-date view, however, should not be mistaken for a full picture of reporting behavior. It is strongest when the question is about resolution. It is weaker when the question is about when employees first raised concerns or how those concerns relate to events in the business.

Report Both, But Label the Story Clearly

Most modern case management systems can track both open date and close date. The challenge is less about system capability and more about reporting discipline.

Ethics and compliance teams should define what each metric is meant to show, label reports clearly, and avoid mixing date logic without explanation. A board chart showing case volume by close date tells one story. A dashboard showing cases opened after a training event tells another. Both can be valuable, but they should not be presented as interchangeable.

A practical reporting model might look like this:

  • Use open date to analyze reporting activity, emerging risk, case intake, and the impact of training, communications, or site visits.
  • Use close date to analyze investigation timeliness, resolution patterns, substantiation outcomes, discipline, and remediation.
  • Use both when reporting to the board, especially if the discussion covers both risk trends and process performance.
  • Include a short methodology note so directors and senior leaders understand what the chart is showing.

This approach helps prevent misinterpretation. A quarter with many cases opened may reflect heightened risk, improved awareness, or both. A quarter with many cases closed may reflect an investigation backlog being resolved rather than a new spike in reporting. Without clear date logic, leaders may draw the wrong conclusion.

The Real Question Is What Decision the Data Supports

Case volume data is not just a count. It is a way to help leaders understand risk, trust, responsiveness, and program effectiveness. That means ethics and compliance teams should begin every reporting exercise by asking what story the data needs to tell.

If the goal is to help the board understand the organization’s overall risk profile, case volume by issue type, location, substantiation, anonymity, discipline, and timeliness will matter. If the goal is to understand whether employees are engaging with training or communications, open date may be the better signal. If the goal is to evaluate investigation performance, close date may be essential.

Strong reporting does not force one date field to answer every question. It uses the right date for the right purpose and gives leaders enough context to interpret the data responsibly.

That is the real discipline behind case volume reporting. The value is not in choosing open date or close date once and applying it everywhere. The value is in knowing what the audience needs to understand, what decision the data should inform, and which date field tells that story most clearly.


Sidebar: A Simple Test for Case Reporting Metrics

Before presenting case volume data, ethics and compliance teams can ask:

  • Are we trying to show when concerns entered the system?
  • Are we trying to show how quickly matters were resolved?
  • Are we connecting case activity to training, communications, or a site visit?
  • Are we helping the board understand risk trends, process health, or both?
  • Have we labeled the chart clearly enough that leaders will not misread the trend?

If the answer involves more than one purpose, the report may need more than one date view.