# Remove the 15 column limit from the metric sheet visualization

**URL:** <https://community.holistics.io/t/remove-the-15-column-limit-from-the-metric-sheet-visualization/1265>\
**Category:** Feature Suggestions\
**Tags:** visualizations\
**Created:** [October 26, 2022, 2:40pm UTC](https://community.holistics.io/t/remove-the-15-column-limit-from-the-metric-sheet-visualization/1265 "2022-10-26T14:40:26Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Gabriel](https://community.holistics.io/letter_avatar_proxy/v4/letter/g/9de0a6/32.png) [@Gabriel](https://community.holistics.io/u/Gabriel)\
**Post date:** [October 26, 2022, 2:40pm UTC](https://community.holistics.io/t/remove-the-15-column-limit-from-the-metric-sheet-visualization/1265/1 "2022-10-26T14:40:26Z")

</div>

I’m a big fan of the metric sheet visualization, but I don’t understand why there is a hard column limit.  
I would welcome it being removed or made configurable to avoid having users filter on a timeframe manually to expand the desired view.

---

<div class="post-metadata">

**Author:** ![vu.duong](https://community.holistics.io/user_avatar/community.holistics.io/vu.duong/32/483_2.png) [@vu.duong](https://community.holistics.io/u/vu.duong)\
**Post date:** [October 31, 2022, 7:20am UTC](https://community.holistics.io/t/remove-the-15-column-limit-from-the-metric-sheet-visualization/1265/2 "2022-10-31T07:20:57Z")

</div>

Thanks for reaching out about this, @Gabriel!  
To confirm, is it the “ **Number of columns** ” options in Viz Styles that you were referring to?

 ![Screen Shot 2022-10-31 at 14.22.41](https://community.holistics.io/uploads/default/original/1X/e0c76d936cf4bd3a08ffc00f6b6fa030fd7db6c6.png)

---

<div class="post-metadata">

**Author:** ![vu.duong](https://community.holistics.io/user_avatar/community.holistics.io/vu.duong/32/483_2.png) [@vu.duong](https://community.holistics.io/u/vu.duong)\
**Post date:** [October 31, 2022, 8:02am UTC](https://community.holistics.io/t/remove-the-15-column-limit-from-the-metric-sheet-visualization/1265/3 "2022-10-31T08:02:38Z")

</div>

This is indeed our original intention for the “Number of columns” option in Metric Sheet visualization.

Due to the viz being a combinations of several metrics, we wanted to limit the number of columns here, but only focus on some of the most-used ones (for example, 4 columns for “Quarter” granularity, 7 columns for “Day”, with the aim of improving in-app performance & experience.

However, we’d love to have the opportunities to support more use-cases also.  
Could you share more about the context, as well as what your users’ desired view of the metric sheet would look like, @Gabriel?

---

<div class="post-metadata">

**Author:** ![Gabriel](https://community.holistics.io/letter_avatar_proxy/v4/letter/g/9de0a6/32.png) [@Gabriel](https://community.holistics.io/u/Gabriel)\
**Post date:** [November 7, 2022, 2:39pm UTC](https://community.holistics.io/t/remove-the-15-column-limit-from-the-metric-sheet-visualization/1265/4 "2022-11-07T14:39:06Z")

</div>

I understand a column limit to have better control over the performance, but a pre-defined and mandatory limit is restrictive. As I understand, query results are limited already for performance reasons so it could be redundant. Plus this viz is pretty much a nicely styled pivot table and pivot tables do not have this limit, although you could make the same argument there.

---

<div class="post-metadata">

**Author:** ![mabr](https://community.holistics.io/user_avatar/community.holistics.io/mabr/32/407_2.png) [@mabr](https://community.holistics.io/u/mabr)\
**Post date:** [November 9, 2022, 9:24am UTC](https://community.holistics.io/t/remove-the-15-column-limit-from-the-metric-sheet-visualization/1265/5 "2022-11-09T09:24:46Z")

</div>

We use the metric sheet for reporting purposes, which we in a lot of cases do on a monthly basis.  
We currently have to build a business case, where we need +2 years of sales data per month.

If we did not have the 15-column limit, this would be very easy. Instead, we either have to download the results, use a filter to select another period, and then merge it in excel or use another report type like a table.
