Visualize - Creating a Grid

Cory Fifield -

Note: All Visualize examples are done with the Northwinds sample database. If you would like to use the Northwinds database as well, click here. This impacts the fields used in creating the Pivot.

 

Basic Grid Steps

  1. Click the Grid icon to insert this element into the Data Visualization.
  2. Drag a field into the first column.
  3. Repeat for each column needed.

 

Example Northwinds Grid

  1. Click the Grid icon to insert this element into the Data Visualization.
  2. Drag the First Name field into the first column.
  3. Drag the Last Name field into the second column.
  4. Drag the Shipped Date field into the third column.
    • Click the drop down for Shipped Date.
    • Select (Month-Year)
  5. Drag the Shipping Fee field into the last column.
    • Click the drop down for Shipping Fee.
    • Select Format…
    • Set Format Type to Currency.
    • Set the Unit to Ones
    • Check the Include group separator

 

 

This example displaysthe First Name, Last Name, Shipped Date and Shipping Fee fields in a Grid.

 

Example Grid

Visualize-Training_Grid.gif

Have more questions? Submit a request

Comments

Powered by Zendesk