New chart types in the house! Matrix tables are available as a chart type when you're operating on a single metric with two group bys. Just to refresh your memory, matrix tables are useful when you want to view the sum of a column or a row as a separate column/row.
It can get quite confusing when you can expect to use which chart so we made you a handy table:
| Number of metrics | Number of group by fields | Group by is a date field | Metric is an aggregate function (sum, max, min, average) | Chart |
| 1 | 0 | No | N/A | Text, table |
| 1 | 1 | Yes | N/A | Line, pie, bar, horizontal bar, table, summary table, pivot, funnel, donut, area, heat map |
| 1 | 1 | No | N/A | Pie, bar, horizontal bar, table, summary table, pivot, donut, heat map |
| 1 | 2 | Yes | N/A | Stacked bar, grouped bar, stacked horizontal bar, grouped horizontal bar, matrix, table, summary table, line, bubble, heat map, area |
| 1 | 2 | No | N/A | Stacked bar, grouped bar, stacked horizontal bar, grouped horizontal bar, matrix, table, summary table, bubble, heat map |
| 2-4 | 0 | No | No | Summary table, text, table |
| 2-4 | 1 | No | No | Stacked bar, grouped bar, horizontal bar, grouped horizontal bar, table, summary table, pivot |
| 2-4 | 1 | Yes | No | Stacked bar, grouped bar, stacked horizontal bar, grouped horizontal bar, table, summary table, line, bubble |
| 2-4 | 1/2 | Yes/No | Yes | Summary table, bubble, table |
| >4 | 0 | N/A | N/A | Summary table, table, text |
| >4 | 1 | Yes | N/A | Summary table, table, area, line |
| >4 | 1 | No | N/A | Summary table, table |
| >4 | 2 | Yes/No | N/A | Summary table, table |
Find the solution article here.