Sunday, 16 February 2014

Blended Axes in Tableau

Blended Axes:-

In Blended Axes all the Measures are combinedly analyzed in Single Axes,Single Pane and with the Single Marks Card.

  • Measures can share a single axis so that all the marks are shown in a single pane. 
  • For example, the view below shows quarterly sales and profit on a shared axis

  • To blend multiple measures, simply drag 2nd measure(Profit) and drop it onto an existing axis(Sales Axis).

  • Blending measures uses the Measure Names and Measure Values fields, which are auto-generated fields that contain all of the measure names in your data source and all of the  measure values
  • The shared axis is created using the Measure Values field. The Measure Names field is added to the Color shelf so that a line is drawn for each measure. 
  • Blending axes is most appropriate when comparing measures that have a similar scale and units.
  •  If the scales of the two measures are drastically different, the trends may be distorted.

Thanks Guru's,

Count of A's in Each Customer’s Name

How many A's does each Customer have in their name(On Superstore Data)? Step 1: Create  3  calculated fields  “Cust Name Wi...