Create and save, search, and modify and manipulate dashboards
Loading...
Loading...
Loading...
Loading...
You can duplicate a dashboard and use it as a starting point for a different dashboard.
To duplicate a dashboard:
Click Duplicate.
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.
Click Save.
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.
You can share a saved dashboard with specific users or roles.
To share a dashboard:
Click Share.
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.
Click Apply.
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.
Users that have been assigned the restricted_sharing role cannot share a dashboard, and the Share icon is unavailable.
You can use heavysql to export a dashboard definition as a JSON file, then import the dashboard definition to another HEAVY.AI instance.
To export a dashboard definition:
Start heavysql.
Enter the following backslash command:
Where <dashboard-name> is the name of the dashboard in Heavy Immerse and <file-path> is the name and location to create the JSON file.
For example:
To import a dashboard definition:
Copy the export file to a location available to another HEAVY.AI instance.
Enter the following backslash command:
Where <file-path> is the location and name of a file exported from another OmniSci instance.
For example:
Dashboards you have shared
Dashboards others have shared with you
You can construct a Heavy Immerse dashboard following these steps:
Once you save the dashboard, you can share it with other HEAVY.AI users.
Connect to Immerse by pointing a web browser to port 6273 on your HeavyDB server. When you launch 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 Heavy 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.
Click Apply.
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.
Click Save.
Dashboard tabs enable you add multiple pages to a dashboard. Using tabs can reduce the number of charts on a dashboard page and make it easier to find the chart you want.
By default, dashboard tabs are disabled. To enable tabs, in your server.json file, set "ui/dashboard-tabs"to "true".
Dashboard tabs are located at the bottom left of the dashboard. The dashboard shown below has three tabs: Config UI (selected tab), Locked axis on scatter, and New Combo improvements:
Click a tab to open it, or use the right arrow icon to move to the next tab. Hovering on a tab reveals the three-dot menu, which you can use to duplicate, rename, or delete a tab.
Using a tabbed dashboard affects some dashboard actions you take. Refresh and Add Chart affect only the tab that you are currently viewing. Share, Duplicate, and Save affect all tabs on the dashboard.
To delete a dashboard:
Click Dashboards.
Mouse over the dashboard you want to delete.
Click X at the end of the dashboard row.
Connect to Heavy Immerse by pointing a web browser to port 6273 on your HeavyDB server. When you launch Immerse, the landing page shows a list of saved dashboards. The number to the right of the Search box shows the number of dashboards displayed (left side of the slash) and the number of total dashboards (right side of the slash). Because no filters are applied here, these numbers are the same (5446).
You can:
Search for dashboards by name, source, or owner by entering a string in the search box.
Sort dashboards by name, source, modified date, owner, and whether the dashboard is shared or not. By default, dashboards are sorted by last modified. Click a column heading to sort by information defined by that column, and click again to toggle sorting the sorting order.
Filter dashboards by name, source, last modified date, owner, and shared status.
Create and save dashboard views that show a particular set of dashboards based on filter criteria you set.
Delete, download (export), and duplicate individual dashboards.
Perform bulk actions on selected dashboards.
Super users can restrict users who have the immerse_trial_mode role from downloading (exporting) dashboards by enabling Trial Mode. To enable trial mode, set the ui/enable_trial_mode flag to TRUE.
You can use filters to define the dashboards that are displayed, and then save the view defined by any filters you apply. To create a filter click the plus icon (+) to the left of the Search box.
Use one or more filters to define the view. For example, that following view shows dashboards with source flights and owner mapd:
You can then sort that filtered view the same way you would an unfiltered view.
To save the view, in the View name box, click the pencil icon and enter the name of the view, and then click the Save icon. Here, the view will be saved as flights - mapd.
Click the down arrow in the View name box to see the list of available filters. You can also toggle the selected filter on and off.
You can change the filters in a specified view and update it. For example, here the flights - mapd view has been updated to include only dashboards modified in 2019, so the Save icon is highlighted; click it to update the view definition.
Or, you can click the down arrow and then click + Add filter view to create a new filter view based on the updated filters. You can also duplicate or remove filter views.
A filter view is available only to the Immerse user who creates the view. If you log out of Immerse and then restart, you start with the view that you were using when you logged out.
You can select dashboards and perform the following actions. Select dashboards by clicking the box the the left of the dashboard name.
Export - Export (download) all selected dashboards as individual .json files.
Share/Unshare - Share or unshare selected dashboards with specific users or roles. If a user has been assigned the restricted_sharing role, sharing dashboards is unavailable.
Delete - Delete selected dashboards.
Once you have created a Heavy Immerse dashboard, you can configure the look and feel of the dashboard and manipulate the charts in various ways.
You can customize the look and feel of charts in a dashboard with the user interface settings (UI Settings) panel. You can adjust settings for fonts, labels, and color palettes. Setting are applied to all charts on the dashboard. Customizing the user interface, you can make charts easier to read in presentations by increasing font size, or create a color scheme that matches company branding.
To open the UI Settings panel, click the Palette icon in the upper left of the dashboard.
The UI Settings panel has three sections:
Chart fonts
Chart Settings
Color palette
Use the Reset dashboard settings button to cancel any changes and revert to the default settings set by the admin or a superuser; if no dashboard settings have been set, settings revert to the Immerse default.
Any changes made to fonts, labels, and colors in UI Settings are applied to all charts on the dashboard and override all other settings.
If you do not save the settings, any changes are removed if you close the dashboard.
You can increase and decrease the size of chart, axis, tooltip, legend, and top section control fonts. You can also make the font bold. Click the A-, A+, and Bold icons to adjust font size and weight.
You can set font sizes from 6 to 24 points. To increase the brightness of the font color, toggle on Use high contrast font colors. Experiment with font size and contrast to see what works best for your dashboard.
You can configure the amount of space between charts on your dashboard using the Chart margin slider. In Chart settings, set the margin value by moving the slider, or enter the pixel value.
You can increase and decrease the length of axis labels in charts to make them easier to read.
For example, on this dashboard, the chart margin is set to 0. The Axis truncation length is set to 19, which makes the airline and city values unreadable.
Increasing the truncation length to 100 reveals the carrier name and the origin city for each bar. Increasing the margin sets more space on the dashboard between charts.
Adding or changing a color on the Color palette overrides that color in servers.json.
To add a color to Color set 1 or Color set 2, click the plus icon (+) in the section you want to edit, add the hexadecimal value for the color, and click the Save icon.
To change or delete an existing color in Color set 1 or Color set 2, click the color and then either change the hexadecimal value for the color, or click the Delete icon to delete it. Each color set must have at least one color.
In Categorical colors and Continuous colors, you can add a new palette, edit an existing palette, or delete a palette. Click the dropdown to see currently existing palettes and options for adding, editing, or deleting. Each palette must have between 2 and 10 colors. For Categorical colors, the dropdown shows the following.
Clicking a palette enables you to edit it by adding, changing, and deleting colors in the same way you do for Color set 1 and Color set 2.
If you are an admin or superuser, you can assign settings defined in the UI Settings panel as default settings for a database.
To save the current changes to the panel or the current saved dashboard settings as the database default, click the Save settings as default button in the Configure defaults section.
The save setting button is disabled if there are no changes to the panel, if there are no saved dashboard styles, or if the styles are the same as the default.
Clicking Save settings as default shows the following caution.
Click Set as database default only if you are sure that you want each new dashboard created to use the defined settings.
If the database is configured with a default mapd user, that user cannot modify database-level UI configuration settings and receives an error that reads “Error setting configuration” when attempting to do so. To work around this issue, you can:
Create a new superuser and use that to set database-level configurations.
Create a new user and assign it the immerse_db_config role.
Rename the mapd user to a different user name.
Clicking Reset to original UI settings in the UI Settings panel resets any database defaults to the system default. If no database defaults are saved, the button is disabled.
Saving settings as default for a database does not overwrite any existing dashboards that have custom UI Interface settings.
You can add annotations to any New Combo charts on your dashboard.
To add an annotation:
On the dashboard, click the Edit annotations icon:
The icon changes to indicate that annotation is enabled. Click the See More Options arrow to the right of the icon to toggle annotation visibility on and off.
2. Click the chart information you want to annotate, and then add the annotation text in the text box. Here, American Eagle Airlines number of records bar is selected.
3. You can edit the annotation:
To edit the text, click in the annotation text box and type any changes.
To move the annotation, drag the text box to the desired location.
To resize the annotation, select it and use the text box handles.
To delete hit, hover over the annotation and then click the Delete this annotation icon.
Annotations appear in the New Combo chart when you open it to edit.
Annotations are tied to the data selection. For example, if cross-filtering changes the value of the selected data, the annotation remains the same.
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.
Exporting images is currently beta functionality.
You can export both chart and dashboard images. Chart export is enabled by default; dashboard export is disabled by default.
ui/enable_chart_image_export : true|false
ui/enable_dashboard_image_export : true|false
To export a chart image as a PNG file, click Export as image on the chart’s More options menu.
To download and entire dashboard, click the Camera icon on the top bar.
Image export may take a few seconds to download.
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.
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. Glasgow 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 for individual charts on your dashboard. For all chart types, you can download data in .csv format and view the CSV files in a typical spreadsheet application, like Microsoft Excel or Google Sheets. For Choropleth, Linemap, and Pointmap charts, you can also download data in geoJSON and geoJSONL format.
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, 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.
Any nested data (for example, a histogram with stacked data) is flattened.
To download geo chart data:
In the upper-right corner of the chart, click the More Options icon, and then click Export Data.
2. In the Download Data dialog box:
Select the file format you want to download.
Select whether to use gzip compression.
For multilayer charts, select the layer to download from the drop-down list.
Set the filename and GeoJSON layer name, and click Download.
If you update your dataset, you can update your dashboard by using the Refresh icon in Immerse.
Click Refresh.
Choose Refresh Now.
If you have streaming data continually updating your dataset, you can set an interval to automatically refresh your dashboard.
Click Refresh.
Click Auto Refresh.
Choose an interval (for example, 2 Minutes).
To turn off Auto Refresh, set the interval to Off.
Using your browser refresh button ends your session and requires you to log in again.
You can change your Heavy Immerse interface to display in Dark Mode.
To display 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. HEAVY.AI 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.
By default, the UI Settings panel is enabled for all users. To disable the UI Settings panel for non-superusers, set ui/show_ui_config_panel to false in your file. You can also enable and disable Label defaults and Color palette in the UI Settings panel for non-superusers with theui/show_ui_config_panel_axis_trunc and ui/show_ui_config_panel_color_palette flags.
The Color palette section of UI Settings has four subsections, each of which corresponds to an individual "colors" section in "customStyles" in your .
To adjust the font, change the Annotation labels font in .
Set the following in servers.json to enable image export:
For more examples, see .
By default, linked charts are disabled. To enable chart linking, set to ON in servers.json.
Color palette | Definition |
Color set 1 |
| Solid colors. All measures are assigned one color. The array of colors you provide defines which colors are available. |
Color set 2 |
| Custom colors. These are the options available in Color by Dimension. |
Categorical colors |
| 4 scales, 1 or more colors each scale. Defines a range of colors that measures iterate through repeatedly. The size of the range can vary. |
Continuous colors |
| 4 scales, 1 or more colors each scale. Quantitative measures produce smooth, continuous gradients between each "stopping point" defined in the list of colors, in order. |
