Increase decimal precision for percentages

Question & Answer
1

I’m trying to show response rates as a percentage with 3 decimal points (xx.xxx%) but it seems no matter what I try it’s only showing 2 (xx.xx0%).

Calculated fields:
{submitted}/{mailed}; {settled}/{mailed}

Attempted:

  • Change decimal places in number format
  • ((1000000*{submitted})/{mailed})/1000000
  • ((123456*{submitted})/{mailed})/123456
  • {grr_div} = ((1000000*{submitted})/{mailed}); {grr} = {grr_div}/1000000
  • ((999999*{submitted})/{mailed})/1000000 (just to see)
  • Compute values at query level (precision is kept there but lost on import)

It does show all the precision I need when I multiply by 100, but then I can’t show it as a percentage less than 100%. The root cause is that QS only keeps 4 digits of precision after the decimal point - displaying as a percentage does not evaluate differently, it only changes the number format. I need to find out if there’s a way around this limitation.

Possible solutions:

  • Find a way to keep precision
  • Express values > 1 as direct percentages

image

2

Hmmm, and you’re sure you added decimal points to the value?

image
image1749×1333 127 KB

3

Definitely, both in the field wells and in the field list.

image
image934×490 67.9 KB

4

Maybe it has something to do with this.

5

This does seem to be the issue. Now that I know what the problem is I can try to figure out a workaround. Direct query probably would work but would take too long simply due to the size of the query. Thanks.

1 Like
6

Hi @john_withanh , we are working on a feature to support as many as 15 decimal places with high level of calculation precision for SPICE dataset. We are now open for private preview, if you would like to test the feature, please message me offline and we can sign you up for preview. Thanks!

1 Like
7

hello, was the decimal places issue deployed to production QuickSight? It seems to be fixed…