Toolbar: ‘Create a new cross tabulation’
Smartpad: Properties Tab > Object Type
Smartpad: Properties Tab > Options and Formatting
The scatter chart is a special kind of chart. It can display the same data as all other charts, but the chart works differently with Dimensions and Measures.
The following example illustrates the underlying tabular data that Analytics easily transformed into a Scatter Chart rendering when the Scatter Chart property button is applied to the selected Cross-Tab object, as shown below.
The following Work Time object is rendered as an example of a Scatter Chart definition.
The following explains the way a Scatter chart is used and the advantage of using it over using other chart types, (e.g. bar charts).
If we wish to see Revenue, and the Profit Margin percentage for each year, we could use a normal bar chart. Revenue and Profit Margin percentage are both Measures. This means that if we want those data types to be represented on a bar chart, the values would be represented by the height of the bars.
The problem is that the Y-axis will be showing Revenue values from 0 to millions. This means that the values of the Profit Margin percentage, which are between 0 and 100, would be almost invisible. The same issue would apply in line charts and area charts.
However, the scatter chart allows placing Measures on both axes of the graph. This means that the measure data, Revenue and Profit Margin percentage, can be placed one on each of the axes of the chart, while the required dimension, for instance Time is placed on the selection line of the legend.
It is now easier to see the data values for each item as dots in the scatter graph. Using the above suggested dimensions and measures it would be desirable to have all the dots placed in the upper right corner of the chart, which means that they all show high Profit Margin percentages and large Revenue values.
By default the X- and Y-axis will meet each other at point zero (0) and the axes top values will be adjusted to the highest measure values. Specific values for each axis may be defined in the Smartpad Properties tab.