How to compare data year over year

This article describes how to build a line chart to compare year over year data.

In this example, we are grouping the Count of Documents.Id by Date Uploaded.

We'll drag our Documents Id column to Measures, and click it to open its settings. We'll select Count of unique for the aggregation.

2015-02-05_15-01-59.png

Next, we'll drag Date Uploaded to dimensions, and select Month of Year from the Time bucket dropdown.

2015-02-05_15-03-19.png

We're going to drag Date Uploaded to Dimensions again, and this time we'll select Year of Date Uploaded from the Time bucket dropdown.

2015-02-05_15-01-59.png

Lastly, we'll add a Data Pipeline Pivot Data step to pivot the table. This will allow us to view our data as a line chart.

Change your chart to a line chart, and you'll see a year over year comparison of your data.