10.4 Create a Simple Dashboard

When creating a simple dashboard, Reports prompts you to select the data source. When you open the Dashboard Visual Composer, a window displays where you can choose the data source for the Dashboard. Follow the prompts or close the window to continue to the main editor of the Dashboard.

From the Dashboard editor, you can create Tables and Charts in the canvas. From there, you can also convert to measure some fields that can provide numeric values and can be used in a chart. You can also convert to dimension the fields that can provide a string value.

First, use the system to create and save a data worksheet as the basis for your dashboard. Use one of the following to create a simple dashboard.

10.4.1 Use the Dashboard Wizard

If you select the wizard, the Dashboard Designer displays the Wizard section of the Dashboard. From here, you can create the first component of the Dashboard.

  1. Select Reports > Dashboard Designer > Crosstab Wizard.

  2. Select the data worksheet of your preference as a data source, and then click Next.

  3. Select Open Wizard.

  4. Select the fields to use in your dashboard.

  5. (Conditional) Select the dashboard style:

    Crosstab

    Groups the dashboard by row and column headers and displays the summary data at the intersections

    Table

    Groups the dashboard and summarizes it or displays it in tabular layout

    Chart

    Creates multiple charts using multiple fields

    Full Editor

    Allows granular control view of your updates, such as format, color, and shape

  6. Once the editing is complete, set the position of the element in the dashboard canvas.

  7. View the dashboard, and then select Continue.

  8. Once the dashboard has been successfully edited, select Finish.

  9. Click Save as to save your dashboard.

10.4.2 Use the Dashboard Editor

Using the Dashboard Designer, you can edit the elements and freely set their position in the Dashboard. The Dashboard Designer displays the Wizard section of the Dashboard.

  1. Select Reports > Dashboard Designer > Crosstab Wizard.

  2. Click Cancel to open the dashboard editor.

  3. Select the data worksheet of your preference as a data source, and then click Next.

  4. Add the elements available from the left.

  5. Update the dashboard using the Dashboard composer.

    You can create, add, and edit multiple elements.

  6. Click Save to save your dashboard in a Custom Content folder.