Data shown in charts and tables is always structured in tables in the background. The difference is, how the dimensions are concatenated in the visualization. To understand which data points are shown to you, keep in mind that configured dimensions and KPIs will be structured in the background in the following way:
Dimension 1 | Dimension 2 | ... | KPI 1 | KPI 2 |
---|---|---|---|---|
A | 01 | ... | 2 days | 10k |
B | 01 | ... | 5 days | 100 |
B | 02 | ... | 0 days | 3k |
... | ... | ... | ... | ... |
The OLAP table will show all dimensions and KPIs configured in a table:
Column, line, area and marker charts all behave the same with the visual representation beeing the only difference:
Pie and donut charts both show the concatenated dimensions as pieces and the size of each piece is defined by the first KPI.
The bubble chart shows exactly two KPIs over a selected dimension.
The histogram takes a KPI as an input and shows the case distribution on it.
The scatter plot will plot a point for each case or other item you aggregate on.