Add Percentage Calculations for Table Charts (Row %, Column %, Previous Row %, Previous Column %)

What is the problem or goal the end user is trying to solve or accomplish?

The customer is trying to replicate certain percentage-based calculations in Preset (Table charts), similar to what they were able to do in Looker. They want to calculate:

• % of row

• % of previous row

• % of column

• % of previous column

They are looking for an easier solution for these percentage calculations directly in the Table charts, without the need to create additional metrics at the dataset level.

How are they solving it currently?

Currently, the customer is using SQL queries to create custom metrics for calculating percentages at the dataset level. For example:

• Row% is calculated using a SUM() / SUM() OVER formula.

• Previous row % is calculated using LAG() functions. They have expressed that while this works, they are looking for an easier, more automated solution in Preset to avoid the need for complex dataset-level metrics.

What is the recommended solution by the Customer?

The customer recommends that Preset include functionality in Table charts to automatically calculate percentages based on rows, columns, and previous rows/columns. The solution should be similar to the Contribution Mode found in Bar and Line charts, which would allow users to calculate percentages in an easier, more intuitive way without needing to manually define metrics in the dataset.