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!