Cross-date scattergram

A scattergram can compare two timeframes for the same measure―one date range on the x axis and another date range on the y axis. If values are about the same between timeframes, points will be clustered along a line with a slope of approximately one. This type of scatter plot can answer questions like: Did customers buy more this period or last? Who or what did not fit this pattern? 

To configure a cross-date scatter plot

  1. In explore mode, select a Scattergram graph.

  2. Select the "Scatter By" to control what will be plotted.

  1. Add a previous date range (Last) to compare against.

 

  1. Add a measure.

  2. At the bottom of the Measures area, check the Shared X/Y Axis Measure box.

  3. Beside the measure, select "XY." This will automatically be selected if the widget only has one measure.

  1. (Optional) By default, the scattergram plots data for "Last" on the y axis and data for "This" on the x axis. To reverse this setup, place your cursor over the measure name in the right pane of the measures dialog, click the  icon, and choose from the Data Type-X or Data Type-Y menu.

  1. (Optional) To color the points based on a variable, go to Visual Options (under Graph Settings in the toolkit) and choose from the same options available in the regular scattergram.