How to report on a “per user” basis

Screenshot 2015-11-16 17.08.53

One of the most common indicators IT use to understand workload and issues in the environment is by looking at task volumes — for example, new incidents opened by month, or new change requests by location by quarter.

The question you’re trying to answer is “Is the amount of work my organization needs to complete going up or going down?” This can help plan for future staffing or understand issues as they arrive.

However, one weakness of these kind of reports is that it can be difficult to separate the information from background noise. For example, when the number of incidents goes up, is this because of issues in the environment? Or has the organization grown in such a way that you would expect more issues?

With Explore Analytics‘ powerful mash-up and calculation capabilities, you can easily account the size of the user population to shed better understanding on your volumes. The following guide will show an example with ServiceNow on how to generate an Incidents per User report.

Continue reading

Automatically Update Frozen Reports in Dashboards

Many of you are embedding Explore Analytics reports on ServiceNow dashboards, as well as Sharepoint, Google Sites, or other portals.

Often, these reports are live, but in some cases you may want to display daily, weekly, or monthly generated frozen reports. If a report doesn’t need to be live (for instance, for daily or weekly calculations), it may perform more quickly with frozen data. For more information on when frozen reports might be appropriate, see this earlier blog post.

These frozen reports can be automatically scheduled to publish on a regular basis. Now, the republished reports can use the same URL, so that you can automate replacing the frozen report in your dashboard or portal.

We’re going to walk through an example, so you can see how it works.

Continue reading