How to select and compare date ranges over time

This article explains how to select a date range and compare data from 2 time periods.

Select a date range

Instructions:

• When you navigate to a dashboard, you click the date range filter in the dashboard’s upper left corner.
• Select the dates you’d like to measure in the calendar for a custom date range or select a preset date range on the right. In the below image, on the left you can select a custom date range. On the right, you can select a preset date range.
• Click done to confirm the selected date range.
• Once you return to the dashboard, you can select more filters on the left. After you’ve selected all desired filters, you click Apply filters on the left.

Compare data from 2 time periods

Curious whether your in-stock rate improved since your supply chain team uses out-of-stock alerts? Or do you want to quickly compare this month’s visibility share to the previous month? Sitelucent provides a way to compare date ranges in KPI-, line- and bar chart widgets.

Instructions:

• Click the date range filter in your screen’s upper left corner.
• Switch the ‘Compare with’ switch on;

• Select the dates you’d like to compare in the calendar for a custom date range or a preset date range on the right.

Custom date ranges (examples):

• Example 1: Select random days by clicking the start and end dates in both calendars (we recommend comparing 2 periods with an equal length).

Example 2: Select 7 random days on the left calendar, combined with ‘preceding period’ on the right calendar. This way, you compare the selected 7 days with the 7 days before that period.

• Example 3: Select one of the preset date ranges in the left calendar and compare it with the same period a month ago. E.g. compare the last 7 days with the same period a month ago.

Compare data in a dashboard

You’ll now see results for both dates ranges in a bar chart and the delta (difference between date A and B) in percentage points (pp) in a line chart.

Bar chart:

Line chart:

KPI widgets

In a KPI widget, you can see the most recent value of your selected date range on the left (dark green), compared to the value on the last day of your comparison period on the right (bright green).

Bar charts

In the bar chart below, the blue represents the last day of the first date range, and the purple represents the last day of the second date range.

Line charts

Each line represents the delta between date A and B in percentage points (pp).

Hover over a line or bar chart to see the comparison per date (and per retailer/brand/country etc.). The represented dates are displayed on the pop-up on hover. In the example below, we compare the visibility shares on Sunday, December 5, and November 28.

For instance, looking at Yamaha, the brand had a visibility share of 15% on December 5 and 10% on November 28. It improved by 5 percentage points.

JBL improved by 10 %points, and LG’s visibility share remained the same. Sony lost 8 pp.

Performance overviews

Performance overviews give you an overview of your main KPIs in one glance. The conditional coloring in combination with the dashboard clickthrough makes it possible to get aware of, and if needed, quickly deep-dive into underperforming products.

Comparing date ranges shows you how your products are evolving. The example below shows an increase of the product availability of 6,3 percentage points.