Before you Begin

This tutorial shows you how to create a tile visualization with multiple measures and an accompanying spark chart for the primary measure in Oracle Analytics.

Background

You can use a tile visualization to show multiple aggregate measures. Oracle Analytics designates the first measure in the tile as the primary measure. Additional measures are secondary measures. You can add a spark chart to display information about the primary measure and an attribute in your dataset. In this tutorial, the spark chart shows total sales as the primary measure and customer segment as the attribute. You can up to five measures in a tile visualization.

You also update some properties in the tile visualization, make property changes to the default spark chart, and then duplicate the tile visualization and change the visualization type.

What Do You Need?

Create a Dataset

In this section, you create a dataset using the sample_order_lines.xlsx file.

  1. Sign in to Oracle Analytics.
  2. On the Home page, click Create, and then click Dataset.
  3. In Create Dataset, click Drop data file here or click to browse.
  4. In Create Dataset Table from sample_order_lines.xlsx, click OK.
  5. Click Save Save icon. In Save Dataset As, enter sample_order_lines, and then click OK.


    Description of sample_order_lines.png follows
    Description of the illustration sample_order_lines.png

Create a Tile Visualization

In this section, you create a visualization for a measure.

  1. In the sample_order_lines dataset, click Create Workbook.
  2. In the Data pane, drag Sales to the canvas.


    Oracle Analytics creates a tile visualization that fills the entire canvas.

    Description of sales_auto_tile.png follows
    Description of the illustration sales_auto_tile.png

Modify the Canvas Layout

In this section, you update the canvas properties to use the freeform layout to control the size of the visualization and layout on the canvas.

  1. Hover over the Canvas 1 tab, click Menu Canvas menu icon, and then select Canvas Properties.
  2. In Canvas Properties, click the Auto Fit in the Layout row, select Freeform, and then click OK.
  3. In the canvas, grab a corner anchor canvas anchor icon to resize the visualization.


    The freeform layout enables resizing and moving any visualization on the canvas.

    Description of resized_tile_viz.png follows
    Description of the illustration resized_tile_viz.png

Create a Spark Chart

In this section, you create a spark chart in the tile visualization by adding an attribute.

  1. In the Data pane, select Customer Segment and drag it to Category (Chart) in the Grammar pane.


    Oracle Analytics creates a spark chart of Sales by Customer Segment.

    Description of sales_custseg_sparkchart.png follows
    Description of the illustration sales_custseg_sparkchart.png
  2. Hover over the spark chart to display the values in the Line With Area spark chart.


    Description of sparkchart_values.png follows
    Description of the illustration sparkchart_values.png
  3. In the Data pane, hold down the Ctrl key, select Shipping Cost, Discount, and Profit. Drag and release them under Sales in Values.


    Oracle Analytics adds the measures to the tile visualization. The spark chart remains associated with the primary (first) measure in the tile.

    Description of composite_tile.png follows
    Description of the illustration composite_tile.png

Update the Visualization's Properties

In this section, you modify the default settings for the visualization.

  1. Click Properties Properties icon.
  2. In the Title row, click None, select Custom, and then enter Sales by Customer Segment.
  3. In Title Font, click Auto, click Comic Sans MS, and then click B (for bold).
  4. In the Chart row, click Line With Area and select Line.
  5. In the Color row, click Auto, and then click Custom. In the Custom Color row, click the square Custom color icon. In Custom Color, click a color such as blue or enter #1bbed0 for blue and click OK.
  6. In the Width row, click Auto and select Large.
  7. In the High/Low Marks row, click Hide to select Show.
  8. In the Reference Line row, click None and select Average.


    Description of viz_props_changes.png follows
    Description of the illustration viz_props_changes.png

Duplicate the Visualization

In this section, you duplicate the tile spark chart visualization and change the visualization type to provide another view of the data.

  1. In the tile spark chart visualization hover over the toolbar, click Menu Menu icon, click Edit, and then click Duplicate Visualization.


    In the freeform layout, the duplicate visualization is on top of the original visualization.

  2. Hover over the second visualization and move it to the side of or below the first visualization.
  3. In the duplicate visualization, click Change Visualization Type Change Visualization Type icon, select Table Table icon.


    Description of summary_tile_details.png follows
    Description of the illustration summary_tile_details.png

Learn More