How Flex Tables work
Valentine Strunz-Happe avatar
Written by Valentine Strunz-Happe
Updated over a week ago

TL;DR:

  • Flex tables are super powerful to answer any of your question as it gives you maximum flexibility to drill down and slice & dice your data to what you want to see.

  • They work similar to pivot tables, where you can use 2 dimensions, filters and further display options to get to the answers you're looking for

Flex Tables can be found in multiple different reports in Klar. We use to call them "pivot table on steroids" cause they are super powerful and flexible in slicing and dicing your data to find exactly what you’re looking for.

Currently, we have the Revenue & Profit Flex Table, the Marketing Flex Table, and the Influencer Flex Table.

Our flex tables work very similarly to pivot tables, in both design and workflow. But even if you haven’t used pivot tables before, they are easy to learn.

How to use Flex Tables

The columns are pre-defined in each report but you use the 2 main dimensions to control which values you want to be displayed.

Dimensions

E.g. in the Profitability Flex Table, if you're looking for profitability metrics per SKU, use the first dimension to choose "Product SKU" and display the metrics for each one:

If you now want to see those metrics e.g. per shipping country per SKU, use the second dimension to further break down the profitability metrics from each SKU to be shown fore each shipping country:

Filters

On top, use filters to further specify what you are looking for in your data and only display specific results. This also allows for and and/or conditional logic:

Display Options

Most of the flex tables have further options to display for different cases specifically, that you can see above the table. For the Profitability Flex Table you can choose to display the data for all orders (total), per order or even per item, and to see it with the bundles bundled or unbundled and distributed to the separate SKUs included in the bundle:

Did this answer your question?