Working with Dashboards

This topic describes how to create and save dashboards, and ways that you can modify and manipulate them.

Creating a Dashboard

You can construct a OmniSci Immerse dashboard following these steps:

  1. Start a New Dashboard
  2. Add One or More Charts
  3. Title and Save the Dashboard

Once you save the dashboard, you can share it with other OmniSci users.

Starting a New Dashboard

Connect to OmniSci Immerse by pointing a web browser to port 6273 on your OmniSci Core Database server. When you launch OmniSci Immerse, the landing page is a list of saved dashboards. You click New Dashboard in the upper right to configure a custom dashboard.

Adding a chart

To add a chart, you click Add Chart, choose a chart type, set dimensions and measures, then click Apply. For more information on creating charts, see OmniSci Immerse Chart Types.

To create a chart:

  1. Click Add Chart.
  2. Choose a Data Source. For example, UFO_Sightings.
  3. Choose a chart type. For example, Bar.
  4. Set the Dimension. For example, country.
  5. Set the Measure. For example, COUNT # Records.
  6. Click Apply.
sightings-by-country.png

Titling and Saving a Dashboard

To title and save a dashboard:

  1. Click the title area.
  2. Type a title.
  3. Click Save.

Modifying a Dashboard

Moving and Resizing Charts

To move a chart within a dashboard, click the title bar and drag the chart to the new location. If there is already at that location, it moves aside.

To resize the chart, click on the lower right corner of the chart and drag to change the size.

moving charts.gif

Cross-Filtering

When you add more than one chart to a dashboard, filters on one chart affect all other charts on the dashboard.

For example, the dashboard below shows UFO Sightings in various countries.

ufos-all-countries.png

If you click the bar for Great Britain (gb) on the “Sightings by Country” chart, the other charts are filtered, as well.

ufos-gb-only.png

Multisource Dashboards

You can choose different data sources for individual charts on your dashboard. This lets you look for visual correlations in datasets that are not directly connected.

For example, these charts compare immigration rates to UFO sightings. Glascow looks suspicious.

msd.png

Exporting Chart Data in CSV Format

You can export data in .csv file format for individual charts on your dashboard. You can view the CSV files in a typical spreadsheet application, like Microsoft Excel or Google Sheets.

The exported data matches exactly the data represented in the chart at the time of export; this includes any filters, binning, domain settings, or other settings. To export chart data in CSV format:

  1. Hover the mouse over the chart.
  2. In the upper-right corner of the chart, click the Export CSV icon.
csv-download-chart.png

The CSV file is downloaded to the default downloads folder for your browser.

Notes:

  • You cannot export a CSV file for Choropleth, Geo Heatmap, Pointmap, or Scatter Plot charts.
  • Any nested data (for example, a histogram with stacked data) is flattened.

Refreshing a Dashboard

If you update your dataset, you can update your dashboard by using the Refresh icon in Immerse.

  1. Click Refresh.dashboard_refresh.png
  2. Choose Refresh Now.refresh_now.png

If you have streaming data continually updating your dataset, you can set an interval to automatically refresh your dashboard.

  1. Click Refresh.
  2. Click Auto Refresh.
  3. Choose an interval (for example, 2 Minutes).

To turn off Auto Refresh, set the interval to Off.

Note Using your browser refresh button ends your session and requires you to log in again.

Duplicating a Dashboard

You can duplicate a dashboard and use it as a starting point for a different dashboard.

To duplicate a dashboard:

  1. Click Duplicate.
  2. A new, identical dashboard is created, with (Copy) appended to the original dashboard name.

  3. Click the Pencil icon to edit the name of the dashboard.
  4. Click Save.

    ufos-duplicate.png

Important Use Duplicate to create a copy of a dashboard; do not rename a dashboard and save it. If you rename a dasboard and then save it, the original dashboard is overwritten with the renamed dashboard, and no duplicate is created.

Sharing a Dashboard

You can share a saved dashboard with specific users or roles.

To share a dashboard:

  1. Click Share.
  2. Click the Search field to browse a list of users and roles. You can also type the first few characters of a user or role name to search.
  3. Click to select a user or role. To remove a user or role, click the x at the end of the row.
  4. Click the Copy icon at the bottom to copy the dashboard URL.
  5. Click Apply.
  6. Send the URL to the selected users and let them now they are authorized to use the dashboard.

When viewing the dashboard, you can click the Share icon at any time to add or remove users.

On the Dashboards page, the Shared column lets you distinguish between dashboards you have shared versus dashboards shared with you by others.

Dashboard Shared By MeDashboards you have shared
Dashboard Shared with MeDashboards others have shared with you

Exporting and Importing a Dashboard Definition

You can use omnisql to export a dashboard definition as a JSON file, then import the dashboard definition to another OmniSci instance.

To export a dashboard definition:

  1. Start omnisql.

  2. Enter the following backslash command:

    \export_dashboard "<dashboard-name>" <file-path>
    

    Where <dashboard-name> is the name of the dashboard in Immerse and <file-path> is the name and location to create the JSON file.

    For example:

    omnisql> \export_dashboard "Sample Dashboard" /home/omnisci/exported_dash.json

To import a dashboard definition:

  1. Copy the export file to a location available to another OmniSci instance.

  2. Enter the following backslash command.

    \import_dashboard "<dashboard-name>" <file-path>
    

    Where <file-path> is the location and name of a file exported from another OmniSci instance.

    For example:

    omnisql> \import_dashboard "Sample Dashboard" /home/omnisci/my_dashboard.json
    

Deleting a Dashboard

To delete a dashboard:

  1. Click Dashboards.
  2. Mouse over the dashboard you want to delete.
  3. Click X at the end of the dashboard row.