---
title: "Matrix panel plugin for Grafana"
description: "Matrix panel for grafana. Matrix panel plugin for Grafana by lavenderpancake. Available in Grafana Cloud and self-managed Grafana."
---

> This is the Markdown version of https://grafana.com/grafana/plugins/lavenderpancake-matrix-panel/

# Matrix

- Developer: lavenderpancake
- Version: 1.1.3
- [Installation](https://grafana.com/grafana/plugins/lavenderpancake-matrix-panel/installation.md)
- [Change log](https://grafana.com/grafana/plugins/lavenderpancake-matrix-panel/changelog.md)

![PanelSimple](https://grafana.com/api/plugins/lavenderpancake-matrix-panel/versions/1.1.3/images/img/PanelSimple.png)

![PanelTotal](https://grafana.com/api/plugins/lavenderpancake-matrix-panel/versions/1.1.3/images/img/PanelTotal.png)

![OptionsRowGroups](https://grafana.com/api/plugins/lavenderpancake-matrix-panel/versions/1.1.3/images/img/OptionsRowGroups.png)

![OptionsRowGroups](https://grafana.com/api/plugins/lavenderpancake-matrix-panel/versions/1.1.3/images/img/OptionsColumnGroups.png)

![OptionsDataField](https://grafana.com/api/plugins/lavenderpancake-matrix-panel/versions/1.1.3/images/img/OptionsDataField.png)

![OptionsAggregateFunction](https://grafana.com/api/plugins/lavenderpancake-matrix-panel/versions/1.1.3/images/img/OptionsAggregateFunction.png)

![OptionsShowTotals](https://grafana.com/api/plugins/lavenderpancake-matrix-panel/versions/1.1.3/images/img/OptionsShowTotals.png)

![OptionsShowTotalsGrid](https://grafana.com/api/plugins/lavenderpancake-matrix-panel/versions/1.1.3/images/img/OptionsShowTotalsGrid.png)

![OptionsTimeUnit1](https://grafana.com/api/plugins/lavenderpancake-matrix-panel/versions/1.1.3/images/img/OptionsTimeUnit1.png)

![OptionsTimeUnit2](https://grafana.com/api/plugins/lavenderpancake-matrix-panel/versions/1.1.3/images/img/OptionsTimeUnit2.png)

![NoDataWarning](https://grafana.com/api/plugins/lavenderpancake-matrix-panel/versions/1.1.3/images/img/NoDataWarning.png)

![DataFieldTypeWarning](https://grafana.com/api/plugins/lavenderpancake-matrix-panel/versions/1.1.3/images/img/DataFieldTypeWarning.png)

![ColumnGroupsFieldWarning](https://grafana.com/api/plugins/lavenderpancake-matrix-panel/versions/1.1.3/images/img/ColumnGroupsFieldWarning.png)

![RowGroupsFieldWarning](https://grafana.com/api/plugins/lavenderpancake-matrix-panel/versions/1.1.3/images/img/RowGroupsFieldWarning.png)

![DataFieldWarning](https://grafana.com/api/plugins/lavenderpancake-matrix-panel/versions/1.1.3/images/img/DataFieldWarning.png)

# Matrix panel

The Matrix panel plugin provides simplified functionality of matrix control in a paginated report (Microsoft Report Builder).

Use the Matrix panel plugin to display grouped data and summary information similar to crosstabs and pivot tables. You can group data in row and column groups, add totals for summary information and format datetime values. Change the options and observe result immediately.

See the following examples:

**Sales grouped by Date-Region-City and Category-Product**

![PanelSimple](https://github.com/VStepchenko/lavenderpancake-matrix-panel/blob/master/src/img/PanelSimple.png?raw=true)

**The same with totals**

![PanelTotal](https://github.com/VStepchenko/lavenderpancake-matrix-panel/blob/master/src/img/PanelTotal.png?raw=true)

## Options

### RowGroups

Choose at least one field to group rows on. The order of fields is important.

![OptionsRowGroups](https://github.com/VStepchenko/lavenderpancake-matrix-panel/blob/master/src/img/OptionsRowGroups.png?raw=true)

### ColumnGroups

Choose at least one field to group columns on. The order of fields is important.

![OptionsRowGroups](https://github.com/VStepchenko/lavenderpancake-matrix-panel/blob/master/src/img/OptionsColumnGroups.png?raw=true)

### DataField

Choose the data field to aggregate data on. The field must be of number type, otherwise there will be the appropriate warning. You can use Query inspector to check field types in your data.

![OptionsDataField](https://github.com/VStepchenko/lavenderpancake-matrix-panel/blob/master/src/img/OptionsDataField.png?raw=true)

### AggregateFunction

Choose the aggregate function for the data field. The possible options are - **Sum**, **Max**, **Min**, **Avg**, **Count**.

![OptionsAggregateFunction](https://github.com/VStepchenko/lavenderpancake-matrix-panel/blob/master/src/img/OptionsAggregateFunction.png?raw=true)

### ShowTotals

Show or hide summary information in totals.

![OptionsShowTotals](https://github.com/VStepchenko/lavenderpancake-matrix-panel/blob/master/src/img/OptionsShowTotals.png?raw=true)

![OptionsShowTotalsGrid](https://github.com/VStepchenko/lavenderpancake-matrix-panel/blob/master/src/img/OptionsShowTotalsGrid.png?raw=true)

### TimeUnit

Format the datetime values if needed. It uses grafana's format and **must** starts with 'time:'. Examples are 'time:YYYY-MM-DD', 'time:YYYY-MM-DD HH:mm:ss'. It applicable only for fields of datetime type, make sure appropriate field/fields is/are not of string type. You can use Query inspector for that and add 'Convert field type' transformation if needed.

![OptionsTimeUnit1](https://github.com/VStepchenko/lavenderpancake-matrix-panel/blob/master/src/img/OptionsTimeUnit1.png?raw=true)

![OptionsTimeUnit2](https://github.com/VStepchenko/lavenderpancake-matrix-panel/blob/master/src/img/OptionsTimeUnit2.png?raw=true)

### Warnings

There are several checks for options and data. There are the possible warning messages.

![NoDataWarning](https://github.com/VStepchenko/lavenderpancake-matrix-panel/blob/master/src/img/NoDataWarning.png?raw=true)

![DataFieldTypeWarning](https://github.com/VStepchenko/lavenderpancake-matrix-panel/blob/master/src/img/DataFieldTypeWarning.png?raw=true)

![ColumnGroupsFieldWarning](https://github.com/VStepchenko/lavenderpancake-matrix-panel/blob/master/src/img/ColumnGroupsFieldWarning.png?raw=true)

![RowGroupsFieldWarning](https://github.com/VStepchenko/lavenderpancake-matrix-panel/blob/master/src/img/RowGroupsFieldWarning.png?raw=true)

![DataFieldWarning](https://github.com/VStepchenko/lavenderpancake-matrix-panel/blob/master/src/img/DataFieldWarning.png?raw=true)

## Contributing

Author : Vasiliy Stepchenko\
E-Mail : <st.vasiliy1983@gmail.com>
