This topic describes how to create and save dashboards, and ways that you can modify and manipulate them.
You can construct a OmniSci Immerse dashboard following these steps:
Once you save the dashboard, you can share it with other OmniSci users.
Connect to OmniSci Immerse by pointing a web browser to port 6273 on your OmniSciDB 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.
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:
Click Add Chart.
Choose a Data Source. For example, UFO_Sightings.
Choose a chart type. For example, Bar.
Set the Dimension. For example, country.
Set the Measure. For example, COUNT # Records.
To remove a chart:
Hover the mouse over the chart.
In the upper-right corner of the chart, click the More Options icon, and then click Remove Chart.
To title and save a dashboard:
Click the title area.
Type a title.
You can change your OmniSci interface to display in Dark Mode.
To display OmniSci Immerse in Dark Mode, click the User icon in the upper right and choose SWITCH TO DARK MODE.
Dark Mode can enhance the contrast and readability of your charts. I am joking, of course. You use Dark Mode because it looks awesome.
To change back to light mode, click the User icon in the upper right and choose SWITCH TO LIGHT MODE.
The theme setting is saved on the browser you are currently using. The setting does not affect other machines or other browsers you might use.
When you create a map, the theme defaults to Current Immerse Theme. This is necessary to automatically update a map when you toggle themes. You can still explicitly choose Light Mode or Dark Mode, but if you do so the map stays in that theme, regardless of the Immerse theme. Existing maps have a hard coded theme and are currently going to stay that way. OmniSci recommends that you use Current Immerse Theme, unless you want the map to always display in Light Mode or Dark Mode.
You can also configure the theme in the servers.json/servers.local.json file. Add a new key for theme and set it to dark. If you set no key, the default is light.
The system theme setting only takes effect if you have never switched themes. Once you choose your own preferred theme, it always overrides the system setting.
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.
You can add a duplicate of an existing chart to your dashboard. To add a duplicate chart:
Hover the mouse over the chart you want to duplicate.
In the upper-right corner of the chart, click the More Options icon, and then click Duplicate Chart.
A duplicate of the chart is created with the same title, with (Copy) appended. Multiple duplicates result in (Copy 2), (Copy 3), and so on, appended to the original chart title.
When you add a duplicate chart to the dashboard, the dashboard is marked unsaved; to save the duplicate chart, you must save the dashboard.
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.
If you click the bar for Great Britain (
gb) on the “Sightings by Country” chart, the other charts are filtered, as well.
For more examples, see Using Filters.
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.
You can link map charts on a Dashboard so that if you zoom or pan on one of the charts, any linked charts zoom or pan in the same way. Synchronizing makes it easier to coordinate the zoom and focus of different charts, so you do not have to manipulate them individually to get the views that you want.
Charts that can be linked have a link icon in the upper left corner. Clicking it syncs the map with any other maps enabled for sync. You can unlink a map by clicking the icon again.
If you change the zoom or pan of a linked map, any other linked maps change in the same way. For example, the two maps below are linked, indicated by the grayed link that appears in the upper left of the map. The zoom and focus of the two maps are different at this point.
Clicking Zoom out on the map on the right not only syncs the zoom of the other map, it also pans that map so they both have the same focus.
You can download 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 downloaded 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 download chart data in CSV format:
Hover the mouse over the chart.
In the upper-right corner of the chart, click the More Options icon, and then click Download CSV.
The CSV file is downloaded to the default downloads folder for your browser.
You cannot download a CSV file for Choropleth, Geo Heatmap, Pointmap, or Scatter Plot charts.
Any nested data (for example, a histogram with stacked data) is flattened.
If you update your dataset, you can update your dashboard by using the Refresh icon in Immerse.
Choose Refresh Now.
If you have streaming data continually updating your dataset, you can set an interval to automatically refresh your dashboard.
Click Auto Refresh.
Choose an interval (for example, 2 Minutes).
To turn off Auto Refresh, set the interval to Off.
You can duplicate a dashboard and use it as a starting point for a different dashboard.
To duplicate a dashboard:
A new, identical dashboard is created, with (Copy) appended to the original dashboard name.
Click the Pencil icon to edit the name of the dashboard.
You can share a saved dashboard with specific users or roles.
To share a dashboard:
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.
Click to select a user or role. To remove a user or role, click the x at the end of the row.
Click the Copy icon at the bottom to copy the dashboard URL.
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.
Dashboards you have shared
Dashboards others have shared with you
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:
Enter the following backslash command:
\export_dashboard "<dashboard-name>" <file-path>
<dashboard-name> is the name of the dashboard in Immerse and
<file-path> is the name and location to create the JSON file.
omnisql> \export_dashboard "Sample Dashboard" /home/omnisci/exported_dash.json
To import a dashboard definition:
Copy the export file to a location available to another OmniSci instance.
Enter the following backslash command.
\import_dashboard "<dashboard-name>" <file-path>
<file-path> is the location and name of a file exported from another OmniSci instance.
omnisql> \import_dashboard "Sample Dashboard" /home/omnisci/my_dashboard.json
To delete a dashboard:
Mouse over the dashboard you want to delete.
Click X at the end of the dashboard row.