Often you can end up with the case when there is a set of elements on the diagram with very small values on one of the axes in comparison with the values of other elements. In such case the circles corresponding to those elements are situated very closely to each other and drown one over […]
In the upper part of the report page you can see the Pages designer. You can drop there the selection of elements from some level and analyze the data page by page. Every page corresponds to one element from the selection and shows the data bounded by that element. Add the “Month” level from “Date.Calendar” […]
Next to the “Structure” tab, where the designers are, you can find the “Selection” tab: On this tab you can select some elements or groups of elements in the diagram. For example, select “Bikes” category: As you can see, the circles from that category are drawn brightly. At the same time, the other elements are […]
If you press the right mouse button on any of the circles in the scatter-diagram then you will see the context menu with a set of operations, which can be used for page navigation, changing the page, printing or exporting: The set of operations in the context menu is the same as in a treemap-diagram […]
To add a map to your report press the “Add new page” button on the toolbar: In the appeared dialog select the Map page type and fill in the name of a new page: Press «OK» and an empty map will appear.
Map has the following structure: At the left side dimensions and measures are marked in orange. The designers are marked in blue. Here is the set of designers available in the map: Context designer. It does the same thing as the corresponding designer in the table and treemap pages, bounds the data shown in the […]
Let’s build the report that will show those cities of the United Kingdom, where the value of the Reseller Sales Amount measure for all products in 2018 is more than 100 thousand. To do that, drop the “Geography / Country” to the context designer and select “United Kingdom”, then drag in the context designer “Date […]
There are two types of map: Bubble We have built this type of maps with you earlier: Pie Let’s display the “Reseller Order Count” measure for product categories for the map displayed above. To do this, drag the “Category” hierarchy into the “Items” designer, and drop the “Reseller Order Count” measure into the “Size” designer:
Using the Color designer for Bubble type maps you can use the gradient to set the color of the circles on the map: You can change the highlight rule by pressing the button that is showing the gradient: The window for setting up the gradient will appear, exactly the same as you could see when […]
Using the “Size” designer you can set the measure, the values of which for every element will determine the size of the corresponding circle. Let’s go for the Bubble card, which we created earlier drag the “Reseller Order Count” measure into the “Size” designer: You can adjust the sizes of the circles on the diagram […]