Create a New Dashboard

To create a new Dashboard, follow the steps below:

Create a Dashboard from User Portal

  1. Log into the User Portal. (See Use the Portal.)

    If you see the ‘Create Visualization’ dialog box instead of the User Portal, press Create Dashboard to proceed to the ‘New Dashboard’ dialog box shown in the following steps.

    200

  2. In the User Portal, press the ‘Create’ button creation and select the ‘Dashboard’ viewsheet option.

    portalDesignTab

    This opens the ‘New Dashboard’ dialog box.

  3. In the ‘New Dashboard’ dialog box, select the desired Data Worksheet, data model, or database table. (A query is represented by a Data Worksheet. See Query a Specific Data Source for more information.) Note that database tables are only visible if ‘Physical Table’ permission is granted. See Set Security Actions for more details.

    viewsheetExp1 1

    If you select a data model or table as the data source, your Dashboard will have access to all the fields in the selected data source. If you select a Data Worksheet as the data source, the Dashboard will have access to all the data blocks in the selected Data Worksheet. To add a derived data field to the fields already available in the selected data source, see Create a New Data Field.

    If you do not want to use the Dashboard Wizard (see below), you do not need to specify a data source at this time. (See Dashboard Options to choose a data source at a later time.)

  4. Choose how you want to start building your Dashboard, by using the Dashboard Wizard or the Visual Composer.

    The Dashboard Wizard helps you set up your Dashboard by suggesting appropriate ways to visualize your data. If you do not want to use the Wizard, you can proceed to Visual Composer and build your Dashboard there.

Use the Dashboard Wizard

Watch Video: Creating a Dashboard (Visualization Recommender)

This video might show an earlier version of the feature or operation that differs in minor ways from the current version.

Follow these steps:

  1. Follow the initial steps in Create a New Dashboard above to open the ‘New Dashboard’ dialog box.

  2. Press ‘Open Wizard’ in the ‘New Dashboard’ dialog box. This opens the “Visualization Recommender” screen.

  3. Select the data that you want to visualize in the left panel.

    wizard2

    The top panel suggests various visualizations, such as charts, crosstabs, and tables.

    wizard3

  4. Select the desired visualization, and set the desired options.

    Chart Visualization…​

    1. Press the ‘Chart’ button chart in the top panel.

    2. Choose the chart type from the top panel.

      wizard4

    3. In the ‘Group and Aggregate’ panel, use the menu to select the desired aggregation method for the selected measure(s).

      wizard6

    4. To display an existing measure using an additional aggregation method, press the ‘More’ button add and then specify the additional aggregation method using the added menu.

      wizard7

    5. To change a selected dimension to a measure, or a measure to a dimension, press the ‘Convert to Measure ’ button dimension or ‘Convert to Dimension’ button measure in the ‘Group and Aggregate’ panel, respectively.

      wizard5

      What is a measure? What is a dimension?

      A measure is generally used for aggregation, for example summation, averaging, correlation, etc., within a Crosstab, Chart, Text component, or Gauge. Adding a measure to the ‘Y’ region in a chart displays the computed aggregates by using locations on the Y-axis. Adding a measure to the ‘X’ region displays the computed aggregates by using locations on the X-axis. You can also display aggregates by using color, shape, size, or label.

      A dimension is used to break-down the dataset into multiple groups, often within a Crosstab, Chart, or Selection List. Adding a dimension to the ‘X’ region of a Chart distinguishes the different dimension groups by location on the X-axis. Adding a dimension to the ‘Y’ region distinguishes the different dimension groups by location on the Y-axis. You can add multiple dimensions into the ‘X’ or ‘Y’ regions of a Chart, or into the ‘Rows’ or ‘Columns’ regions of a Crosstab, to create multiple grouping levels. You can also distinguish groups in a dimension by using color, shape, size, or label in a Chart.

    6. To change the formatting for a numerical-type field or a date-type field, press the ‘Format’ button setting and select the desired format. (See Add Data Format for more information about the available format options.)

      wizard8

    7. To delete a selected field, press the ‘Delete’ button close next to the field.

    8. Optional: To make more detailed adjustments to the component, press the ‘Full Editor’ button edit in the top toolbar. See Basic Charting Steps for more information about how to use the Chart Editor.

      After you make modifications to the chart using the full Chart Editor, you should press the ‘Finish’ button submit in the top toolbar. You can also return to the Wizard by pressing the ‘To Wizard’ button edit, but you will lose any changes that you made in the Chart Editor.
    Crosstab Visualization…​

    1. Press the ‘Crosstab’ button crosstab in the top panel.

    2. In the ‘Group and Aggregate panel, use the menu to select the desired aggregation method for the selected measure(s).

      wizard6

    3. To display an existing measure using an additional aggregation method, press the ‘More’ button add and then specify the additional aggregation method using the added menu.

      wizard7

    4. To change a selected dimension to a measure, or a measure to a dimension, press the ‘Convert to Measure ’ button dimension or ‘Convert to Dimension’ button measure in the ‘Group and Aggregate’ panel, respectively.

      wizard5

      What is a measure? What is a dimension?

      A measure is generally used for aggregation, for example summation, averaging, correlation, etc., within a Crosstab, Chart, Text component, or Gauge. Adding a measure to the ‘Y’ region in a chart displays the computed aggregates by using locations on the Y-axis. Adding a measure to the ‘X’ region displays the computed aggregates by using locations on the X-axis. You can also display aggregates by using color, shape, size, or label.

      A dimension is used to break-down the dataset into multiple groups, often within a Crosstab, Chart, or Selection List. Adding a dimension to the ‘X’ region of a Chart distinguishes the different dimension groups by location on the X-axis. Adding a dimension to the ‘Y’ region distinguishes the different dimension groups by location on the Y-axis. You can add multiple dimensions into the ‘X’ or ‘Y’ regions of a Chart, or into the ‘Rows’ or ‘Columns’ regions of a Crosstab, to create multiple grouping levels. You can also distinguish groups in a dimension by using color, shape, size, or label in a Chart.

    5. To change the formatting for a numerical-type field or a date-type field, press the ‘Format’ button setting and select the desired format. (See Add Data Format for more information about the available format options.)

      wizard8

    6. To delete a selected field, press the ‘Delete’ button close next to the field.

    7. To change the sort order of a row or column header, move the pointer over the header and press the ‘Sort’ button sort.

      wizard9

    8. Optional: To make more detailed adjustments to the component, press the ‘Full Editor’ button edit in the top toolbar. See Create a Table for more information about how to use the Crosstab Editor.

      After you make modifications to the crosstab using the full Crosstab Editor, you should press the ‘Finish’ button submit in the top toolbar. You can also return to the Wizard by pressing the ‘To Wizard’ button edit, but you will lose any changes that you made in the Crosstab Editor.
    Table Visualization…​

    1. Press the ‘Table’ button table in the top panel.

    2. To change a selected dimension to a measure, or a measure to a dimension, press the ‘Convert to Dimension’ button measure or ‘Convert to Measure ’ button dimension in the ‘Details’ panel, respectively.

      wizard10

      What is a measure? What is a dimension?

      A measure is generally used for aggregation, for example summation, averaging, correlation, etc., within a Crosstab, Chart, Text component, or Gauge. Adding a measure to the ‘Y’ region in a chart displays the computed aggregates by using locations on the Y-axis. Adding a measure to the ‘X’ region displays the computed aggregates by using locations on the X-axis. You can also display aggregates by using color, shape, size, or label.

      A dimension is used to break-down the dataset into multiple groups, often within a Crosstab, Chart, or Selection List. Adding a dimension to the ‘X’ region of a Chart distinguishes the different dimension groups by location on the X-axis. Adding a dimension to the ‘Y’ region distinguishes the different dimension groups by location on the Y-axis. You can add multiple dimensions into the ‘X’ or ‘Y’ regions of a Chart, or into the ‘Rows’ or ‘Columns’ regions of a Crosstab, to create multiple grouping levels. You can also distinguish groups in a dimension by using color, shape, size, or label in a Chart.

    3. To change the formatting for a numerical-type field or a date-type field, press the ‘Format’ button setting and select the desired format. (See Add Data Format for more information about the available format options.)

      wizard11

    4. To delete a selected field, press the ‘Delete’ button close next to the field.

    5. To change the sort order of a column, move the pointer over the header and press the ‘Sort’ button sort.

    6. Optional: To make more detailed adjustments to the component, press the ‘Full Editor’ button edit in the top toolbar. See Create a Table for more information about how to use the Table Editor.

      After you make modifications to the crosstab using the full Table Editor, you should press the ‘Finish’ button submit in the top toolbar. You can also return to the Wizard by pressing the ‘To Wizard’ button edit, but you will lose any changes that you made in the Table Editor.
    Gauge Visualization…​

    1. Press the ‘Gauge’ button gauge in the top panel.

    2. Choose the Gauge type from the top panel.

      wizard12

    3. Optional: Enter a ‘Description’ for the Gauge.

    4. In the ‘Group and Aggregate panel, use the menu to select the desired aggregation method for the selected measure.

      wizard13

      What is a measure?

      A measure is generally used for aggregation, for example summation, averaging, correlation, etc., within a Crosstab, Chart, Text component, or Gauge. Adding a measure to the ‘Y’ region in a chart displays the computed aggregates by using locations on the Y-axis. Adding a measure to the ‘X’ region displays the computed aggregates by using locations on the X-axis. You can also display aggregates by using color, shape, size, or label.

    5. To change the formatting for a numerical-type field or a date-type, press the ‘Format’ button setting and select the desired format. (See Add Data Format for more information about the available format options.)

      wizard14

    6. To delete a selected field, press the ‘Delete’ button close next to the field.

    7. Optional: You can make more detailed adjustments to the Gauge after you exit the Wizard. (See Add a KPI and Gauge Properties for more information about Gauges.)

    Filter Visualization…​

    1. Press the ‘Filter’ button condition in the top panel.

    2. If you have selected a single dimension or measure in the left panel, choose the Filter type from the top panel: Selection List or Range Slider. (If you have selected multiple dimensions, the only option is a Selection Tree.)

      wizard15

      What is a measure? What is a dimension?

      A measure is generally used for aggregation, for example summation, averaging, correlation, etc., within a Crosstab, Chart, Text component, or Gauge. Adding a measure to the ‘Y’ region in a chart displays the computed aggregates by using locations on the Y-axis. Adding a measure to the ‘X’ region displays the computed aggregates by using locations on the X-axis. You can also display aggregates by using color, shape, size, or label.

      A dimension is used to break-down the dataset into multiple groups, often within a Crosstab, Chart, or Selection List. Adding a dimension to the ‘X’ region of a Chart distinguishes the different dimension groups by location on the X-axis. Adding a dimension to the ‘Y’ region distinguishes the different dimension groups by location on the Y-axis. You can add multiple dimensions into the ‘X’ or ‘Y’ regions of a Chart, or into the ‘Rows’ or ‘Columns’ regions of a Crosstab, to create multiple grouping levels. You can also distinguish groups in a dimension by using color, shape, size, or label in a Chart.

    3. Optional: For a Slider-type filter, enter a ‘Description’. For the Selection List or Selection Tree-type filter, double-click the header to edit the label.

    4. Optional: To change the order of the fields in a Selection Tree, press the arrows next to the fields in the ‘Details’ panel.

      wizard16

    5. To change the formatting for a numerical-type field or a date-type, press the ‘Format’ button setting and select the desired format. (See Add Data Format for more information about the available format options.)

      wizard17

    6. To delete a selected field, press the ‘Delete’ button close next to the field.

    7. Optional: You can make more detailed adjustments to the Filter after you exit the Wizard. (See Add Filter Components, Selection List Properties, Selection Tree Properties, and Range Slider Properties for more information about Filter components.)

    Text Visualization…​

    1. Press the ‘Text’ button text box in the top panel.

    2. Optional: Enter a ‘Description’ for the Text.

    3. In the ‘Group and Aggregate panel, use the menu to select the desired aggregation method for the selected measure.

      wizard13

      What is a measure?

      A measure is generally used for aggregation, for example summation, averaging, correlation, etc., within a Crosstab, Chart, Text component, or Gauge. Adding a measure to the ‘Y’ region in a chart displays the computed aggregates by using locations on the Y-axis. Adding a measure to the ‘X’ region displays the computed aggregates by using locations on the X-axis. You can also display aggregates by using color, shape, size, or label.

    4. To change the formatting for a numerical-type field or a date-type, press the ‘Format’ button setting and select the desired format. (See Add Data Format for more information about the available format options.)

      wizard14

    5. To delete a selected field, press the ‘Delete’ button close next to the field.

    6. Optional: You can make more detailed adjustments to the Text after you exit the Wizard. (See Add a KPI and Text Properties more information about Text components.)

  5. Press the ‘Finish’ button submit in the top toolbar to open the layout view, where you can add more components.

  6. To add an additional component, move the pointer to the location where you want to insert the component, and press the large ‘Add’ button add.

    wizard1

    This opens the “Visualization Recommender” screen again. Follow the previous steps to configure your component.

  7. To add titles or labels to the Dashboard, press the ‘Insert Text/Image’ button menu vertical, and select ‘Insert Text’. To edit the inserted text, double-click the text or press the ‘Edit’ button edit. You can make more detailed modifications to the Text component after you exit the Wizard. (See Add Text or HTML and Text Properties for more information about Text.)

    wizard19

  8. Optional: To add an image to the Dashboard, press the ‘Insert Text/Image’ button menu vertical (see above), and select ‘Insert Image’. This prompts you to select an image. You can make more detailed modifications to the Image component after you exit the Wizard. (See Add Background and Image Properties for more information about Images.)

When you have added all desired components using the Wizard, press the top ‘Finish’ button submit. This will open your Dashboard for editing in Visual Composer, where you can continue to add and modify components. See the section below for more information about building a Dashboard in Visual Composer.

Use Visual Composer

Watch Video: Creating a Dashboard (Use Visual Composer)

This video might show an earlier version of the feature or operation that differs in minor ways from the current version.

Follow these steps:

  1. Follow the initial steps in Create a New Dashboard above to open the ‘New Dashboard’ dialog box.

  2. Press OK in the ‘New Dashboard’ dialog box. This displays an empty Dashboard in Visual Composer. (Visual Composer is the tool you will use for creating both Dashboards and Data Worksheets.)

    Asset Component Panels 1

  3. Build the Dashboard by adding components from the left Toolbox panel. See Add Components for more details.

    addingChart

  4. Press the ‘Save’ button save in the toolbar to save the Dashboard.

    If you close the browser (or let the session expire) without saving the Dashboard, you will be prompted to restore the Dashboard the next time you open Visual Composer.

Create a Dashboard from Visual Composer

If you are already in Visual Composer, you can create a new Dashboard by pressing the ‘Create’ button creation and selecting ‘New Dashboard’ button new viewsheet. Then follow the steps in Use Visual Composer.

CreateNewDashboardComposer

Create a New Folder

To create new folder to hold Dashboards or Data Worksheets, follow the steps below:

  1. Right-click the folder in the Asset panel where you want to create the new folder.

  2. Select ‘New Folder’, and provide a name for the folder when prompted. Press OK.

    NewFolderComposer