# Creating dashboards ## Basic dashboards - a quick look at operational data :::tip Menu → Preview → Dashboard ::: The **OmniMES** system offers two types of dashboards, the first of which is an integral, built-in part of the system. This dashboard type was designed for a clear presentation of data from already configured machines and their signals. The user can intuitively modify the dashboard layout by moving and removing visual elements, but cannot edit the source data or the way it is acquired. This dashboard has an informational function and provides a quick look at the production state - without interfering with the system configuration. ![](https://docs.omnimes.com/api/files.get?sig=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJrZXkiOiJ1cGxvYWRzLzRlMDdmZmNhLThmZjAtNDYxYy1iYjEyLTA2OTEyZGRiOGQzNi84MzBmOWZjNy1kM2UxLTRiMTItYWJjYy1kZmFmMjg1YWZlYTAvMDFfcGFuZWxfZ2xvd255X3ZpZXdwb3J0LnBuZyIsInR5cGUiOiJhdHRhY2htZW50IiwiaWF0IjoxNzk0NDk0NzAwLCJleHAiOjE3OTQ1ODExMDB9.R75yUIHWWCz8gbRQRTWtEUez3trS0N4y9fyumAms1CA " =1680x950") ## **Redash dashboards - flexibility and data sharing** :::tip Menu → Desktops ::: The second type of dashboards in the **OmniMES** system are **advanced dashboards**, which give the user full control over their appearance, content and the scope of presented data. Importantly, they can be shared publicly - even with people who do not have an OmniMES account. This solution is particularly useful in projects carried out for external clients who want to monitor the progress of an order in real time. Dashboards can be refreshed automatically at defined intervals - from 1 to 60 minutes - or run without refresh, depending on the needs. This chapter discusses the process of creating dashboards using the integrated **Redash** tool, which is an integral part of the **OmniMES** system. ## The process of creating a query for a dashboard chart :::tip Menu → Desktops → Queries ::: The data source for a chart is a **local query**. In the **Desktops → Queries** module, click **Add** and choose the query type: ![](https://docs.omnimes.com/api/files.get?sig=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJrZXkiOiJ1cGxvYWRzLzRlMDdmZmNhLThmZjAtNDYxYy1iYjEyLTA2OTEyZGRiOGQzNi9kOWM5NmU4OC1iM2RhLTQ2NjEtYTNjMS1kMDg3YmZhOTMyZTUvMDVfcGlja190eXBlX2RpYWxvZy5wbmciLCJ0eXBlIjoiYXR0YWNobWVudCIsImlhdCI6MTc5NDQ5NDcwMCwiZXhwIjoxNzk0NTgxMTAwfQ.TMks_fDiOQs8AmFKEyhDIcAlqMxrFRh6PkzRntFnmz4 " =1680x1000") Most often you create a **Base query (JSON)** - the OmniMES wizard in which, **without knowledge of SQL**, you indicate the machines, event/measurement types and the period (e.g. unplanned downtime from the last 24 hours for the whole machine park). The system itself generates a ready query that will feed the chart. For advanced needs there is also the **Query Results (SQL)** mode - an SQL editor over the results of the base queries; details in the chapter [**Desktops**](https://docs.omnimes.com/doc/desktops-AoJWhHoO2X). ![](https://docs.omnimes.com/api/files.get?sig=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJrZXkiOiJ1cGxvYWRzLzRlMDdmZmNhLThmZjAtNDYxYy1iYjEyLTA2OTEyZGRiOGQzNi82M2Y0M2UzYi00ZWM4LTQ5MTQtYmFiMC0yZDY1N2MyZmMxNTkvMDZfZm9ybV9qc29uX2tyZWF0b3IucG5nIiwidHlwZSI6ImF0dGFjaG1lbnQiLCJpYXQiOjE3OTQ0OTQ3MDAsImV4cCI6MTc5NDU4MTEwMH0.JTjOw0u6lg_-mDUc8vwOSoxZ02kboCPXMezrYDdG2KE " =1680x1000") After saving the query, next to it in the **Queries** tab select **Edit in Redash** to build a chart on it. 2. **Logging in to Redash** If you are not logged in, use the same password as for OmniMES; the login is your e-mail address. ![](https://docs.omnimes.com/api/files.get?sig=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJrZXkiOiJ1cGxvYWRzL2RmMTUxNTFiLThmMzItNDVkNi1iZjE4LTZmZmZhNjg4ZGIwNy9mYWQzNzg3ZC0zMjYwLTRmNzAtYmEwYy0xMjk2NWZkYWZhMGYvaW1hZ2UucG5nIiwidHlwZSI6ImF0dGFjaG1lbnQiLCJpYXQiOjE3OTQ0OTQ3MDAsImV4cCI6MTc5NDU4MTEwMH0.5JfrFfvc6kv9ahwG1z_Wh1o3CehLiM-XBVT0qYNvtr0 " =1239x750") 3. **Running the query** In the *Queries* tab, find your query by its name and click on it. ![](https://docs.omnimes.com/api/files.get?sig=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJrZXkiOiJ1cGxvYWRzL2RmMTUxNTFiLThmMzItNDVkNi1iZjE4LTZmZmZhNjg4ZGIwNy8xNjcyZmJhMS02NTQyLTQ0MjgtYTRmYi0xZmNmYTk1OGI4M2MvaW1hZ2UucG5nIiwidHlwZSI6ImF0dGFjaG1lbnQiLCJpYXQiOjE3OTQ0OTQ3MDAsImV4cCI6MTc5NDU4MTEwMH0.AoGeahyPhvkoLALx6w2QDXodvSkWmY-0swyn2dzyX2c " =1622x113") 4. Then *Edit Source* and *Execute* to fetch the data. ![](https://docs.omnimes.com/api/files.get?sig=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJrZXkiOiJ1cGxvYWRzL2RmMTUxNTFiLThmMzItNDVkNi1iZjE4LTZmZmZhNjg4ZGIwNy8wYjI3NGNjYy00MzgwLTQ0OTYtYmY3Mi02MDMwNTY4MTNmZmEvaW1hZ2UucG5nIiwidHlwZSI6ImF0dGFjaG1lbnQiLCJpYXQiOjE3OTQ0OTQ3MDAsImV4cCI6MTc5NDU4MTEwMH0.zLg9wK4wk2XJfnXLGxcx9X3nJ6zWsYk83Mvm58eWKBk " =1390x487") This is a necessary step before creating a chart. 5. **Creating a chart** ![](https://docs.omnimes.com/api/files.get?sig=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJrZXkiOiJ1cGxvYWRzL2RmMTUxNTFiLThmMzItNDVkNi1iZjE4LTZmZmZhNjg4ZGIwNy8yODQzNmMyMS0yZDYxLTQ5MmEtOGY5ZS03NzljY2RiYTJiZWMvaW1hZ2UucG5nIiwidHlwZSI6ImF0dGFjaG1lbnQiLCJpYXQiOjE3OTQ0OTQ3MDAsImV4cCI6MTc5NDU4MTEwMH0.Dx8CGk16EhRBgefjpy9Tu_2svI7bXJdbV4GYKC19BiE " =1186x878") Click *Add Visualization* and choose the chart type from the *Chart Type* list. The key fields are: * `name_machine` - the machine name * `count` - the number of events * `group by` - e.g. `name_entry` In addition, you can set colours in the *Colors* tab, labels in *Data Labels*, and dynamically display data with the syntax `{{count}} stops - {{convert_time}}`. This flexible solution lets you create professional dashboards tailored to individual reporting and presentation needs. ## **Adding a chart to a dashboard and sharing it** The next step in creating an advanced dashboard in the **OmniMES** system is adding a chart to the panel. To do this: 1. Create a new dashboard by clicking **"New Dashboard"** and entering its name. ![](https://docs.omnimes.com/api/files.get?sig=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJrZXkiOiJ1cGxvYWRzL2RmMTUxNTFiLThmMzItNDVkNi1iZjE4LTZmZmZhNjg4ZGIwNy9kOGM3NTUyYy03MWRhLTRiYTgtYjc0NS04YTZiNDY5N2ZmODIvaW1hZ2UucG5nIiwidHlwZSI6ImF0dGFjaG1lbnQiLCJpYXQiOjE3OTQ0OTQ3MDAsImV4cCI6MTc5NDU4MTEwMH0.7YgH8f7gJZ9Zjrh79hh833ZcbAv_uN19Sx4YYr8OyPw " =1238x316") 2. Confirm the choice by clicking **"Done Editing"** in the top-right corner (the three-dot menu), and then choose the **"Edit"** option. ![](https://docs.omnimes.com/api/files.get?sig=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJrZXkiOiJ1cGxvYWRzL2RmMTUxNTFiLThmMzItNDVkNi1iZjE4LTZmZmZhNjg4ZGIwNy8zYWE4YmRkNS1jODlkLTQ4YmItOGRkNC1jMzNlMDQ5MmM2MDQvaW1hZ2UucG5nIiwidHlwZSI6ImF0dGFjaG1lbnQiLCJpYXQiOjE3OTQ0OTQ3MDAsImV4cCI6MTc5NDU4MTEwMH0.eF6PLpj2EQAXRrBmX6VTORGK45PjDaxWKIqhR317U3E " =361x180") 3. Click **"Add Widget"**, choose the name of the previously created chart and select the visualization type as **"Chart"** - this will add the chart to the dashboard. ![](https://docs.omnimes.com/api/files.get?sig=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJrZXkiOiJ1cGxvYWRzL2RmMTUxNTFiLThmMzItNDVkNi1iZjE4LTZmZmZhNjg4ZGIwNy9jYjk3MDRhNy1jZDRjLTQ2MjMtYTdlNC1jYmEwZTRhN2U0YzIvaW1hZ2UucG5nIiwidHlwZSI6ImF0dGFjaG1lbnQiLCJpYXQiOjE3OTQ0OTQ3MDAsImV4cCI6MTc5NDU4MTEwMH0.g1XHTlwOS_IPIG3_aX_po3cEidSzkZmxJ4yUCotq2kA " =1321x860") 4. Finally, click **"Done Editing"** again to save the configuration. :::info **Note:** The chart must have the **"Publish"** option selected to be visible and ready to use. ::: ![](https://docs.omnimes.com/api/files.get?sig=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJrZXkiOiJ1cGxvYWRzL2RmMTUxNTFiLThmMzItNDVkNi1iZjE4LTZmZmZhNjg4ZGIwNy9lMWU0ZjU0MC04ZDI0LTQ0NTEtYWUzOC0yM2M0NTFiMjgzZmEvaW1hZ2UucG5nIiwidHlwZSI6ImF0dGFjaG1lbnQiLCJpYXQiOjE3OTQ0OTQ3MDAsImV4cCI6MTc5NDU4MTEwMH0.TxGmOTlkuBNvhUVOUhLxeKP6yDwndBIspTFmRpcKL2I " =349x71") To make the dashboard publicly available: * Click **"Share"** and select **"Allow public access"**. ![](https://docs.omnimes.com/api/files.get?sig=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJrZXkiOiJ1cGxvYWRzL2RmMTUxNTFiLThmMzItNDVkNi1iZjE4LTZmZmZhNjg4ZGIwNy83OTBhNzZhZS03M2I0LTRhZWItOWE0Zi05ZDJmNThkNjBmZTkvaW1hZ2UucG5nIiwidHlwZSI6ImF0dGFjaG1lbnQiLCJpYXQiOjE3OTQ0OTQ3MDAsImV4cCI6MTc5NDU4MTEwMH0.cDLl9s-YFTZFOmjMPoXRnM8hI1LIjTYwh7NtvOhawqA " =251x54") ![](https://docs.omnimes.com/api/files.get?sig=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJrZXkiOiJ1cGxvYWRzL2RmMTUxNTFiLThmMzItNDVkNi1iZjE4LTZmZmZhNjg4ZGIwNy9lYzljNWMwOC03MjE2LTQ5YjAtYjJhOC01MmUzOTg3ZjZmNTgvaW1hZ2UucG5nIiwidHlwZSI6ImF0dGFjaG1lbnQiLCJpYXQiOjE3OTQ0OTQ3MDAsImV4cCI6MTc5NDU4MTEwMH0.SgzpKLxpdVZIiuu7hYCYGtzcs9CwbmYtGrkeG9qtNuE " =568x251") Thanks to this the dashboard: * Will be visible in the OmniMES system as available to be selected as the main view, * Can be shared with external people via a link - without the need to log in to the **OmniMES** system. ## Setting a dashboard as the main panel in OmniMES :::tip Menu → Desktops → Desktops ::: After creating and publishing the dashboard in **Redash**, we go back to the **OmniMES** system, to the **Desktops** tab. Our newly created panel should be visible in the list of available dashboards. To set it as the main panel: 1. Click the **"Set as main panel"** button. 2. Choose the refresh interval - e.g. **every 10 minutes**. From that moment the dashboard will automatically fetch the latest chart data at the selected interval. ![](https://docs.omnimes.com/api/files.get?sig=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJrZXkiOiJ1cGxvYWRzL2RmMTUxNTFiLThmMzItNDVkNi1iZjE4LTZmZmZhNjg4ZGIwNy9kYTRkZTU1My03ZDc2LTQxZDItYjdjNi1iNGJiYTg4MTg4ZmMvaW1hZ2UucG5nIiwidHlwZSI6ImF0dGFjaG1lbnQiLCJpYXQiOjE3OTQ0OTQ3MDAsImV4cCI6MTc5NDU4MTEwMH0.lfiF21RcdWfFp56V103i123vEKE3PfmooxG7bnbQ1g0 " =1664x532") That's all - the dashboard is ready to use as the user's main panel view. Of course, the system allows creating and adding many other dashboards and charts with data to the same chart, depending on analytical or operational needs. ![](https://docs.omnimes.com/api/files.get?sig=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJrZXkiOiJ1cGxvYWRzL2RmMTUxNTFiLThmMzItNDVkNi1iZjE4LTZmZmZhNjg4ZGIwNy9iYzg3ZTQ3OC05MzU4LTQ3Y2YtYTNjNC03NmY2OWE0ZTEyN2IvaW1hZ2UucG5nIiwidHlwZSI6ImF0dGFjaG1lbnQiLCJpYXQiOjE3OTQ0OTQ3MDAsImV4cCI6MTc5NDU4MTEwMH0.yggrRnFT-D8lFhk-mPVcJU-0cpZPxGBk4RntpGZf3Ow " =1879x880") --- **Documents** - [OmniPlatform](https://docs.omnimes.com/s/cb8b19e0-ec6d-4e1a-8690-b0ddd67ad1cd/doc/omniplatform-7z9SIECi68) - [Omnienergy](https://docs.omnimes.com/s/cb8b19e0-ec6d-4e1a-8690-b0ddd67ad1cd/doc/omnienergy-56aRDgnYFZ) - [Omnimes](https://docs.omnimes.com/s/cb8b19e0-ec6d-4e1a-8690-b0ddd67ad1cd/doc/omnimes-eGDa0U5cyr) - [FAQ](https://docs.omnimes.com/s/cb8b19e0-ec6d-4e1a-8690-b0ddd67ad1cd/doc/faq-IFQjCNYt1Q) - [Cybersecurity & Compliance (CRA)](https://docs.omnimes.com/s/cb8b19e0-ec6d-4e1a-8690-b0ddd67ad1cd/doc/cybersecurity-compliance-cra-pPJBcC6sBf)