How to compare data year over year


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

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.

Create a chart

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

Change to Month for the Time bucker

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.

Change Time bucket to year

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. In the Pipeline add a Pivot Data step

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

Year over year comparison final result

Related Charts Help Articles

See more