For example, take the data source of type excel-table, which contains the following fields: Now let’s create a table and fill it with the following data: The Grid displays column values as clickable hyperlinks allowing you to navigate to the Wiki’s pages: You can bind the display value and URI value to different data fields. […]

In this case, a specified URI pattern is used to generate links. Create the following grid: Click the “Column Type” indicator button next to the “Name” data item and change its type to “Hyperlink”. Specify the URI Pattern option as follows: https://en.wikipedia.org/wiki/{0} The {0} placeholder is replaced with the “Name” data item value. The links […]

Let’s see what product subcategories in the “Accessories” category were of positive dynamics. For this, in the “Data” tab on the toolbar, click the “Drill Down” icon and in the grid itself, in the “Columns” field under the “Category” hierarchy, drag the “Subcategory” hierarchy: Now by clicking the “Accessories” product category, we will see all […]

In a “Design” tab of a Grid dashboard element the following toolbar is available: Horizontal Lines – show horizontal grid lines; Vertical Lines – show vertical grid lines; Banded Rows – banded rows are not supported when cell merging is enabled; Merge Cells – merge adjacent cells with identical data (“Drill Down” has to be […]

A grid can be exported into PDF, Excel or a picture format.

To create a chart, you need to click a “Chart” icon in the dashboard designer window on the toolbar: As a result, a new dashboard element appears: The left item contains the following chart parameters: Values – measure, data is displayed on the Y-axis; Argument – dimension, data is displayed on the Х-axis; Series – […]

The chart in the dashboard has two axes – “X” and “Y”. The “X”-axis is the axis of the arguments, and the “Y”-axis is the numerical axis of the measure value. The following options for chart are in the “Design” tab: Rotate – rotate the diagram at 90° “Х” – Axis Settings “Y” – Axis […]

To change the location of the legend, go to the “Design” tab: The following functionality will be available on the toolbar: Show Legend – to display or not to display a legend; Legend location:    

You can change the type of the row on the toolbar in a “Design” tab: The following chart types are available in the drop-down list:

You can change the color of the chart elements in two ways: Way 1. Click an “Edit Colors” icon in the “Design” tab toolbar: Way 2. Click the same icon in the toolbar of the dashboard designer window: In the window that appeared, select the required element and set the color for it: