Before saving a created pivot let us rename its title. This may be done in two ways: Way 1. In “Design” tab press “Edit Names” icon. Way 2. Open context menu in a pivot (click the right mouse button) and choose “Edit Names” from the list. In an appeared form enter the following data: Now […]

If needed you can export a pivot into PDF, Excel or a picture format by clicking the right mouse button in a pivot: Export To PDF The following options are available when exporting the Pivot dashboard item to a PDF: Page Layout – page orientation; Size – page size; Show Title – to display or […]

Let us add a new element Grid to an already-existing dashboard. For this we first click an “Edit” icon on a dashboard toolbar, and then in a dashboard design window click a “Grid” button: Let us look at the grid, which will display the results of sales by product categories. In the column move a […]

Columns in a grid may be of the following type: Dimension – a column shows DB dimension; Measure – a column shows measure value; Delta – a column, which shows a delta of two measures, where one is an actual and the other – a target; Sparkline – a chart, which shown a measure value […]

Let us create a column of a “Delta” type. Choose the type and click an «ОК» button: In a column field two new fields – “Actual” and “Target” appear. Let’s choose a “Internet Order Quantity” measure for real values (actual), and a “Reseller Order Quantity” measure will be a target. We will get a new […]

Let’s create a column of a “Sparkline” type. For this, let’s consider how the quantity of orders for product categories changed depending on the month of the year. For this, we will insert the “Reseller Order Count” measure in the columns and select the “Sparkline” column type: The following settings will be available in the […]

A hyperlink column allows you to display hyperlinks in the Grid dashboard item. You can provide hyperlinks as a separate data column or they can be automatically created at run-time from any column using the specified URI pattern.

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 […]