"Auto-Fit" Row Height in Table

#1

I am trying to mimic the Auto-Fit Columns feature with rows. I am aware of the table and cell padding property, but there are multiple scenarios with varying rows. Here’s the situation:

Global dashboard showing a table and a stacked bar for machine status:

image
image.png775×516 26.3 KB

They are roughly aligned table to bar chart (and if any suggestions on how to make that better, I’m all ears).

However, when we filter the region, the table and chart are no longer aligned. The chart resizes to fill the available space, but the table rows do not. Any way to change this behavior?

image
image.png868×522 18.1 KB

#2

I’m not aware of any way to do this in a table, although I recall asking before.

One way we have previously done is to have an invisible chart alongside the table, with the table values being visible labels, but this is a fair amount of work to set up, and I’m not sure it would work too well with your nested hierarchical row labels.

#3

Yeah, I saw your post David, which had allowed for me to set the global table row heights to start.

Maybe Support will have an idea.

#4

Hopefully support can help.

Otherwise, if you want to go totally crazy you can get a script to calculate the number of rows and then do some maths to work out the numbers and set the height of the rows accordingly,

#5

As David mentioned, I believe to emulate the Auto-Fit Rows to Fill would require some heavy scripting. Is it viable for you to use a scorecard? Using a scorecard would allow displaying all of your measure in one row as well as the stacked bar. The only feature that you’ll be losing on is the drilldown capabilities between your levels (Region -> Cluster -> Plant).

#6

Thanks Ilya,
I will try to do the scorecard and report back. My concern is the ability to control sorting, filtering, and auto-refresh.