In this guide, we'll cover how to add a comparison visualization to your Spreadsheets widget. Depending on the main visualization in use, you'll be able to select between four comparison visualizations: goal, number, percentage, and sparkling.
A goal comparison is ideal if you want to display progress toward a particular target over time. Number and Percentage comparisons can be helpful if you wish to see an exact value or percentage value. The Sparkline can also help visualize progress over time.
How to add comparison visualizations
Create a new Spreadsheets widget or edit an existing one.
Make sure you have already selected your main value on the data range page, then click Continue.
Within the widget configuration panel, click Add comparison visualization and select your preferred comparison type: Goal, Number, Percentage or Sparkline.
Goal: In the Goal field, manually enter the goal value or select it from within your sheet.
If you're adding a goal to a Number visualization, you will have the option to set a Starting from value, which can be helpful if your goal does not start from 0:
If you're adding a goal to a Bar chart, Column chart, or Line chart, you'll have the option to select the type of goal: Less than or More than:
Number: In the Compare to field, manually enter the goal value or select it from within your sheet.
Set the indicator to Up is good or Down is good, depending on your use case.
Percentage: In the Compare to field, manually enter the goal value or select it from within your sheet.
Set the indicator to Up is good or Down is good, depending on your use case.
Sparkline: In the Compare to field, manually enter the goal value or select it from within your sheet.
Make any other necessary changes and save your widget.