Metric Sheet to support any column dimension, not just dates

Feature Suggestions
1

I would like to be able to use Metric Sheet with any dimension as a column, not just dates.

Suppose I have a bookings table with the following columns:

  • booking ID
  • created_at
  • campaign
  • order_total

I would like to be able to use campaign as the columns, and then add different measures as the rows, e.g. booking ID count, order_total sum, etc.

2

Hi @jesko,

It’s Tien from Holistics support team.
If I understand correctly, this is your desired metric sheet table

|           | Campaign A | Campaign B | Campaign C |
| Metric A  |
| Metric B  |
| Metric C  |
| Metric D  |

If this is the case, a pivot table will be more suitable for your use case.
You could read more about Holistics pivot table here.

Best regards,
Tine

3

Hi @Tien_Truong_Tran, thanks for the quick response.

Yes, that is my desired visualisation, ideally also with the ability to add row headings/indentations etc as with the metric sheet.

However, I don’t think the pivot table can give us the result you suggest. A pivot tables only accept dimensions for rows, and measure can only be added as a value. The metric sheet visualisation is the only table type that allows you to add a measure as a row.

Your example would look something like this in a pivot table:

Campaign A Campaign A Campaign A Campaign A Campaign B Campaign B Campaign B Campaign B
Metric A Metric B Metric C Metric D Metric A Metric B Metric C Metric D
Dimension A
Dimension B
4

Hi @jesko ,

Thank you for your response. Let me discuss this with our product team.
I will get back to you later.

Best regards,

1 Like
5

Hi @jesko

Sorry for the delayed response. After discussing with our team, we have noted this as a current limitation of our Pivot Table and have added it to our backlog for improvement.

For now, Pivot Table can only help approximately achieve your desired result:

|           | Campaign A | Campaign B | Campaign C |
| Metric A  |
| Metric B  |
| Metric C  |
| Metric D  |

Following up on this, I want to clarify if the only gap between how Pivot Table currently works and your desired result is only in the column-row arrangement, or if there’s something else.

In our discussions, we could think of two other reasons:

  • You have a lot of metrics therefore displaying metrics as columns in a Pivot Table wouldn’t be very readable/accessible.
  • You wan to use different dimensions in a Pivot Table (currently the dimensions in a Pivot Table are distinct values of a particular calculation).

Your inputs would be of great help!

6

Hi @minhthanh3145 , apologies about the late reply, I somehow missed your comment.

Yes I suppose the main difference is the row/column arrangement.

In a pivot table, we can select a dimension as the columns, but we cannot select a metric as the rows of course, only as the values, so currently a pivot table with multiple columns and multiple metrics (in the value field) will result in a very wid table with a lot of columns and only 1 row.

We also like the ability to add subheaders in the Metric Sheet visualisation, so it feels like adding the ability to add any dimension and not just a date dimension to the Metric Sheet columns would be a great solution.

1 Like