If you have not read it yet, please start with Create reports tutorial.
This tutorial introduces you to the main flex.bi chart types and shows exactly how to select data for these charts and change chart options. You can try to create charts using demo Invoices cube.
We recommend first, build a report in a Table view and then select a chart type most suited for representation.
On this page:
Select the Bar chart  to represent data comparison in columns or bars . Select Stacked  to show a composition of similar items; you may have several stacks to group similar measures.
Select the Line chart  to represent trends of a continuous data set. To represent accumulative value changes over time, select Area . For area chart, you can also select Stacked  to show changes in a composition of similar items.
Select the Pie chart  to illustrate the proportions of a whole composition. You can represent each proportion value as numbers and as a percentage  of the whole. Select Relative Size  to show all compositions proportionally based on value.
To compare segments ratio between composition, you can use the Donut  chart. You can think of a donut chart as being a stacked bar graph that has been curled around on itself.
If you show data labels and percentage for each slice, you can hide the legend .
Select the Scatter  chart can be used to display the correlations between two different measures (numeric values) representing each measure on separate axes. X and Y axis are adjusted automatically according to the values of selected measures.
For representing relations between three measures, you can use Bubble  chart. Two measures are placed on axes and the third measure determines bubble size.
You can select more cluttered part of Scatter chart to zoom in.
Select Timeline chart to present continuous data fluctuations over time. The timeline is a variation of line charts where data are represented as a continuous line. If some period does not have data, then it is displayed in the chart and a line is connected between two closest periods with some data by the shortest distance; the line does not decline to zero as non-existing value does not mean zero as well.
At first select Time dimension  with corresponding hierarchy level for data representation (years, quarters, months, weeks or days) on rows and necessary measures on columns. Then switch to Timeline  tab and change display options for measures (as lines, bars, areas, points or vertical lines) if needed.
In a chart, you can select part of a chart to zoom in and see more details (a zoomed area is not saved in the chart) or you may Filter time to change represented period (a filter is saved in the report).
If you have some dimension with countries or regions or data with geographical coordinates (latitude and longitude) you can represent data distribution on the Map  chart. flex.bi provides two types of maps.
You may visit Demo account to see both map examples: https://flex.bi/bi/accounts/47/dashboards/460-maps-with-geocoding
Use Static map when you have regions mapped with the ISO two-letter codes or country names. If you map data with the country names, make sure that the used variations of the county names are recognized in the map chart by flex.bi.
Select dimension containing region and country two-letter codes  on rows and necessary measures on columns. The first column  is used to calculate color intensity for each region.
Then switch to Map  chart and select Static  view. You may also select the region , like, world map, Europe map or particular country map, to change between available maps. The region color intensity is calculated on measure value  from the first column. When hovering a mouse over the region, you see measure values from all columns.
Use dynamic map when you have geographical coordinates (latitude and longitude) for dimension members to represent their location on the map.
Select a dimension containing objects with coordinates on rows and necessary measures and coordinates on columns . The first column should hold latitude and the second column should hold longitude  to place coordinates correctly. Use some numeric measure  to give a context for the report; this measure might be as the third column or filter.
Then switch to Map  chart and select OpenStreetMap or Wikimedia  view to see how many objects (dimension members) are in each region.
Select Gantt chart  to illustrate scheduled tasks and their progress on the timeline Daily, Monthly, Quarterly, Yearly or Fit width .
Fit width shows the less gradual selection where all the first start date and the last end date of any row fit in the screen.
Select projects and tasks on rows and in columns select at least two date columns for the task start date and end date. Set the start date as the first column and the end date after that . Optionally, you can choose completion percentage  in columns (this column measure should contain percentage formatting). Completion percentage should be in the range from 0% (a task not started) to 100% (task completed). If the completion percentage is less than 100% and the end date is in the past (before the current date), then the task will be shown as overdue.
In the chart, you may reveal the start date, end date, completion ratio, and other task-related information in the table view by sliding chart to the right .
In the chart, the progress of a task is visualized with colors:
- blue - upcoming tasks, milestones and completed tasks without completion ratio;
- green - completed tasks with completion ratio (%);
- red - overdue tasks with completion ratio (%);
- grey - a group of tasks.
Select Gauge  chart to show key performance indicators (KPIs) as color-coded gauges with progress towards defined limits.
Select Gauge limits  to set limits for measures and color-code for each limit range. If several gauges are displayed using the same measure and if you want to specify the same limits for all gauges then click on the common measure (or on the common member name) and select Gauge limits. If you need to add specific limit values for just one gauge then click on the gauge value and select Gauge limits.
To see an overview, you can use numerical values only , and for big numbers select Scaled values  to display values using k (thousands) or M (millions) suffixes. Additionally, add a Sparkline calculated measure to show a brief trend next to the number.
You can set a specific numerical Value or percentage as a limit for the gauge. In this case, you may use k suffix to enter thousands, M suffix to enter millions or % suffix to enter a percentage value. Or you can set another Measure as a limit. Note, this measure should be selected for the report as columns as well. To change the default color of Sparkline do not enter any value, but only change the Color of the limit.
The boxplot chart type can be used for displaying the distribution of data based on five measures:
- minimum (for calculations use function Min)
- first quartile (for calculations use function FirstQ)
- median (for calculations use function Median)
- third quartile (for calculations use function ThirdQ)
- maximum (for calculations use function Max)
The central rectangle spans the first quartile to the third quartile; a segment inside the rectangle shows the median and "whiskers" above and below the box show the locations of the minimum and maximum.
This chart type is available when all five measures are selected for a report.
Go to Bar chart view and for the first measure select type Boxplot.
You can customize the way measures and dimensions are displayed in a chart, and create mixed type charts.
Select Data labels  to display measure values and change Font size  for better readability. For each measure, you may adjust data label position.
Customize the way how each measure is displayed in a chart by clicking on a data marker in front of measure name and create mixed type charts.
For measures with different units, for example, like sales and margin rate, it would make sense to display them on Separate axes to better see the coloration and with varying Types of chart to understand the distinction. You can also change the Color which resonates better with selected measurement nature.
Choose Swap axes to swap dimension and measure placement on X and Y axis.
Use Axes options to provide additional information and improve chart readability. You can set Title and Label prefix and suffix for each axis to describe the metric, for example, that measure value represents Sales amount in USD. You can set Min, max and step for data grid to focus user attention on a particular value area.
Clicking on a measure name to access the same built-in options for data representation as you have in a table view. You may order data by measure value, drill across another dimension, select only one member for a report or remove a member chosen from a report, select top or bottom rows based on measure chosen, filter rows by text pattern or value range.
Relative data comparison
You can choose to show relative data comparison as Percentage  for Stacked  items in Bar and Area charts. You can represent each proportion value as numbers and as a percentage  of the whole bar.