July 19, 2018 by Matt Beatty

How to Create a Chart to Compare Data from 2 Periods of Time

By now, I'm sure you know you can create visualizations on your dashboard charts in Brightmetrics™. Did you know that you could create charts that allow you to see and compare data from 2 periods of time?

This is important when you need help drawing out what could be trends, patterns or anomalies. When planning for the next year or even performing business reviews, (this blog is a great read, I promise) comparing data is imperative.


In this example, we're going to walk you through how we would go through planning around Average Queue Time for this workgroup.


In this view, some patterns and seasonality trends can be determined by visualizing this in a time series line chart for last year.


Already,  you and your team can prepare better for the busier times of the year with these metrics!


Count of All Calls Chart


By looking at this chart alone, you can conclude that the spike in October is an increase in call volume. It's clear that you and your team would need to plan for higher staffing levels during that time period this year.


But what if that spike of calls in October of last year was just an anomaly? How do you know? A quick way to discover this would be to see an overlay of another series from the previous year.


Brightmetrics makes it simple to add another series to this chart that covers that same interval of time (one calendar year). Whatsmore, you can easily adjust it to be offset by a year.


In Edit Dashboard. > Click Chart Options. > Add Item (to create the new series). > Choose the same Value. > Apply the same Filters as you have on your original value in the chart.


Add Item in Chart Options


In Chart Items, click on Advanced options and check “Offset Time."


Then, define the period. In this case, Year was chosen because we're looking at last year’s data. This allows you to see if the Count of Calls had a similar peak in October 2016.


Chart Options in Brightmetrics


Now, you can see that the peak in 2017 was definitely unique. It was not a trend that was noticed in 2016. Check it out:


Count of All Calls Year over Year


This is even more obvious when I zoom in on the chart!


Count of All Calls Year over Year


Now, it has definitely been confirmed that this peak is likely not a seasonal trend.


In Brightmetrics, you have the option to further investigate the data behind this peak for 2017. Use the Drill Through feature to access all the context and information from that time period. You can drill down to individual call records and Cradle to Grave visualizations from here.


Easily use this feature on charts to benchmark your operational visualizations. You even have the option to change the time offset for the week over week or even day over day.


This is especially important when performing reviews with your team members. You can easily see how many calls they're making, what their wrap time is (ECC only), what their queue time is, and much much more.


Ready to use Brightmetrics tools for planning and analysis? Log back in by clicking the below!




Curious about how to create your own charts from scratch? Here's our help center article: Making Visual Comparisons by Offsetting Time that walks you through it step by step!


You may also like