Learn about the table widget in reports.
The table widget is the most commonly-known reporting tool in Plecto. It can hold up to 20 KPIs on a single widget. When you add a table widget, you can add and edit an existing formula or create a new formula right in the widget settings.
An example of a table widget in reports.
Once you have a table widget in your report, you can click the Edit button in the widget's top-right corner to open the settings. From there, you can customize the widget type, time period, grouping, filtering, KPIs, and much more.
Each KPI you add to the widget is displayed in a separate row on your table. You can add up to 20 KPIs to the same table. You can also add target formulas and compare your data to a different time period.
- Target: If you add a target formula, you will see the progress directly in the report.
- Compare to: Compare your KPI to a different time period.
- Drill down by: Expand your KPI and see the data by employees or other fields from the data source your KPI is based on. For example, if you display the number of all sales deals, you can drill the data down by stage to see how many deals are open, lost, won, etc.
- Highlight this row: Make the row stand out by highlighting it in light gray color.
- Include as a unique slide in exports: When exporting to PowerPoint (.pptx), the KPIs with this option enabled will be shown as individual column charts on separate slides.
The table widget allows grouping data by time. Grouping by time will display all selected KPIs on a timely basis, depending on the selected time period.
For example, if you look at data from the previous 3 months, the widget will allow you to select between a daily, weekly, or monthly grouping. If you look at data from the current year, the widget will allow you to group data monthly, quarterly, or annually.
You can choose to see all of your data or filter it by teams or employees. If you want to filter your data, select one of the options and choose teams or employees from the list.
An example of the summary column options on the right side of the table widget.
- Total shows the total value of the formula for the entire period. Here, Plecto uses the total value of the formula, not the accumulated sum of the columns.
- Average shows the total value of the entire period divided by the number of columns in the report. This will use the total value for the formula and not the accumulated sum of the columns.
- Change shows the percentage change from the first column of the selected time period to the last.
Tip – Freeze the summary column
Enable Freeze summary column to keep the column in a fixed position on the table widget.