Rounding off % values of labels in Pia chart

[kanchan09]

Hi All,

Here is task about Pia chart, How to Round off % value of Pia chart labels, and it should give 100% also after round off value.

example-For example, if the original percentages are 33.3%, 33.3%, and 33.3%, rounding each to 33% will result in a total of 99%. The discrepancy arises because the rounding of individual parts does not necessarily preserve the overall total. Small rounding errors accumulate, leading to a slight deviation from 100%.

So I want round off % values with accurate data.

Thanks

[sam8]

In your example, what would you want to see? If we round 33.33 to zero decimal places, rounding errors are to be expected. I'd think for your example that you'd want to round to one or two places instead to minimize discrepancy, but maybe I'm not understanding your question correctly?

[kanchan09]

I need help with rounding off pie chart percentage values. For example, if a pie chart shows 70.01%, I want to round it down to 70%. The same applies to other values. Please let me know if you need more clarification.

Thanks

[sam8]

Ah, I misunderstood your question. Unfortunately, it's not possible to customize the decimal precision of the legend values in Looker. I recommend adding your feedback to the following feature request: Customize percentage decimal places on pie charts