Comparison

The bar graph is one of the most common data visualizations. This is because it is simply the best way of comparing the difference in value across a single item.

• Goal: Increase product subscriptions
• Question: Why does a subset of similar products not respond as positively as others in the same market?
• Analysis: Combo chart

Getting ready

We will make use of the same Chapter 2 – Sales.qvf application used in the Relationships recipe.

How to do it…

1. From the application overview, click the button in the top right-hand corner and click the Create new sheet button. Name this sheet Comparison.
2. Once inside the newly created sheet, go to the Charts asset pane and double-click the Combo chart button.
3. Add Product Group as a dimension.
4. Next, add Sum (Sales) as the first measure. Label it Sales.
5. Add sum ([Sales Qty]) as the second measure. Label it Sales Qty.
6. For the Sales Qty measure:
   • Change the default display format for the expression from Bars to Marker
   • Right below the display format options, there...