Bars in tables not scaling correctly

[JamesGreen_Anco]

Hi Looker team,

We are seeing some odd behaviour with the bars on a table visualisation, see screenshot.

Note in the first 2 columns the bars are not scaling correctly. In the first column row 3 we would expect the 0.4 value to be 40% width of the first row bar (as this is 1).

How is this being scaled?

Thanks,
James

[Cyril_MTL_Analy]

The bars are scaling based on a relative value of min/max.

In your first column, 0.4 is the smallest value, hence gets the smallest bar. 1.0 is the highest value, hence gets the largest bar (and 0.9 being marginally closer to 1.0, the bar is also large).

Same thing for column 2 and 3.

I have the same behavior:

[JamesGreen_Anco]

Thanks for the reply.

This doesn’t seem right though - for example why is the 0.4 not proportional to the others? It’s really misleading to the viewer.

[JamesGreen_Anco]

It would be nice when displaying percentages if you could force the scale to start from 0.

[Cyril_MTL_Analy]

Yes I agree that this is not a great behaviour!

Like you said, it would be nice to be able to control the scaling.

[Dawid]

Feature request here: Table bar charts scaling

[JamesGreen_Anco]

Thanks both - good to see this on their radar.

[izzymiller]

Closing this thread in favor of

Table bar charts scaling Feature Requests

I can’t understand why 928 is suddenly barely visible… is it because they’re the lowest numbers (926, 927, 928)? [image] Somehow it just looks odd like that. A choice of selecting minimum as 0 or as lowest number would be champion 😃

[pware]

I just raised a related but different question, https://www.googlecloudcommunity.com/gc/Exploring-Curating-Data/Table-with-bars-scaling-incorrectly-...