Skip to content
Logo

Charts and maps

The data in Abris can be presented not only in the form of tables and trees, but also in the form of dynamic maps and diagrams based on data from the Database.

Cards

Maps are another form of data display available in Abris.

Map creation

  1. Creating a simple map begins with creating an entity containing the data that will be displayed on it (see p. "Creating a new table" and p. Creating a new view ).To work with the map, it is recommended to use the view.It must have columns containing coordinates (latitude and longitude).

  2. To clarify the parameters, you must select the created entity and go to "Context Actions" ---> "Settings ...".

  3. In the "Advanced Settings" field, enter the following:

       {"longitude_property": "x", "latitude_property": "y"}

Instead of "x" and "y", you must specify fields containing longitude and latitude, respectively.

Настройка дополнительных параметров для
карты

If necessary, you can specify the color of the object, put the image as a display of the object, and also change the appearance when changing certain parameters of the object.

  1. Click "Save."

Форма взаимодействия с
картой

Work with map

In the software platform "Abris" there is the ability to display objects on the map.The navigation area of ​​this object consists of two parts: graphical and tabular.

Пример взаимодействия с данными, отображаемыми на
карте

In the graphic part there is directly a map with objects on it.In the tabular part, the data displayed on the map of the objects are presented in tabular form.On the graphic part, both static and dynamic objects can be displayed.

Пример взаимодействия с данными из
списка

Moving around the map

  1. The graphic component is moved with the mouse.In order to move the map area, you need to hold down the left mouse button and drag the cursor in the opposite direction of the required area.

  2. Map scaling is carried out:

  3. mouse wheel.Scroll the middle mouse wheel up to zoom in, scroll down to decrease;

  4. zoom buttons.Pressing the "+" increases the scale, pressing the "-" decreases.

Dynamic filtering

For the graphic component of the map, not all, but only selected elements are displayed.

  1. In order to filter map objects, it is necessary in the control panel located on the map to move the switch opposite the desired element to the “on” position to display or “off” to hide the element.

detailed information

In order to find out detailed information about the selected element on the graphic part of the map:

  1. You need to hover over the item.

After that, a pop-up window with information will appear next to the object.

In order to find out detailed information about the selected item in the tabular part of the map:

  1. You need to find the element on the graphic part and click on it with the left mouse button or use the search in the tabular part.

After that, a form with information about the selected object will open.

  1. In this form, you can edit the fields.After the change, click the "Save" button located under the object.

  2. You can delete the selected object by clicking the "Delete" button below it.

Working with the tabular component of the map is similar to working with detailed and list forms of the program (see the sections List forms (tables) and Detailed forms ).

Charts

Diagrams are a way to display data, so they are based on entities (tables, views, projections).

Charting

To display entity data on a chart, you need:

  1. Create an entity. At least one entity field must be numeric (see p. Creating a new table and Creating a new view ).

  2. Go to "Contextual Actions" ---> "Settings ..." and in the field "Advanced Settings" enter the following line:

    {"chartType": "bar"}

Настройка параметров для
диаграммы

This parameter indicates the type of chart, in this case "bar".Instead of "bar", other types can be indicated: "pie" (circular), "line" (linear), "area" (additive), "radar" (radar), "donut" (donut), etc.

  1. Click "Save" and refresh the page.

Форма взаимодействия с
диаграммой

After that, the diagram will be ready.By default, the title of the chart uses the title of the entity.

Chart Setup

For created diagrams, you can specify many parameters, in addition to the type.If the parameter is not specified, then its default value is used.You can set additional parameters as follows:

  1. You must select the desired entity and go to "Context Actions" ---> "Settings ...".

  2. In the "Advanced parameters" field, use the view design:

    {"chartType": "donut", "chartOptions": {"plugins": {"labels": {"render": "value", "fontSize": "14", "fontColor": "#fff"}} }, "s-property": "sensor_id",}

Настройка дополнительных параметров для
диаграммы

  • "render" parameter - indicates the format for displaying chart values.In this case, in the value "value" - indicates the display of a numerical value;

  • parameter "fontSize" - indicates the font size of the chart values.In this case, the size is 14 pixels;

  • parameter "fontColor" - indicates the font color of the chart values.In this case, "#fff" (HEX) is "red";

  • parameter "s-property" - contains a column whose data will be used as a legend.In this case, "sensor_id"

Other options are available for charts. You can find out more about the parameters and their possible values ​​on the website with chartjs.org documentation, and find usage examples on the website emn178.github.io

  1. Click "Save."

Изменённая диаграмма

Work with chart

  1. According to the diagram, the exact values ​​are not always clear, so you need to hover the mouse on the desired element of the diagram in order to find out the exact values ​​of the selected value.

  2. In order to exclude unnecessary parameters from the diagram, you need to left-click on the symbol of this parameter (by default it is in the middle at the top of the screen).## Charts

Charting

To display entity data on a chart, you need:

  1. Create an entity. At least one entity field must be numeric (see p. Creating a new table and Creating a new view ).

  2. Go to "Contextual Actions" ---> "Settings ..." and in the special field enter the following line:

    {"chartType": "scatter", "x-property": "x", "y-properties": ["y1", "y2"]}

Instead of "x" you must specify the name of the column ( not the header! ) Containing the values ​​of the abscissa axis, and instead of "y1" and "y2" specify the names of the columns containing the values ​​of the ordinate axis.The ordinate axis value can be at least one.

  1. Click "Save" and refresh the page.

After that, the schedule will be ready.The default header is the entity header.

Setting Charts

For the created charts, you can set many parameters.If the parameter is not specified, then its default value is used.You can set additional parameters as follows:

  1. You must select the desired entity and go to "Context Actions" ---> "Settings ...".

  2. In the special field where the code for the created chart is already available, you must enter the appropriate code.For each parameter (legend, color scheme, switch, grouping) he has his own.

Adding Legends

The legend contains symbols and their symbols on the chart.

Legends are added by entering the following code:

"s-property": "s"

Instead of "s", you must specify the name of the column containing the values ​​that you want to use as a definition of the graph symbols.

Graphics color palette

The color palette is set by entering the following program code:

"graphColors": ["color1", "color2"]

Instead of "color1" and "color2" you must specify the colors, for example, "green", "yellow" or "# 008000", "# FFFF00" in the HEX (hexadecimal system).The number of colors must be indicated by the number of graphs.

Chart Switch

To display multiple charts, you can use the chart switch.It is a tab with graphs.Tab generation is defined by the following program code:

"graphGroups": [{"title": "graph1", "items": ["column1"]}, {"title": "graph2", "items": ["column2"]}]

Instead of "graph1" and "graph2" you must specify the names of the tabs for the graphs.There can be at least two tabs.

Instead of "column1" and "column2", you must specify the names of the columns that will set the values ​​along the ordinate axis.The number of columns should correspond to the number of tabs.

Data grouping

Entity data can be divided into groups using the values ​​of one of the columns.

Grouping is carried out by the following program code:

"g-property": "g"

Instead of "g", you must specify the name of the column, according to the values ​​of which the grouping will be carried out.

This parameter, unlike the previous ones, is used in conjunction with the graph switch.Thus, charts from different groups are displayed in different tabs of the switch.

Example

Example code for setting up a schedule:

{"chartType": "scatter", "x-property": "date", "y-properties": ["temperature"], "s-property": "date", "graphColors": ["green", "# FFFF00"], "g-property": "group", "graphGroups": [{"title": "Day temperature", "items": ["temperature"]}, {"title": "Night temperature "," items ": [" temperature_night "]}]}