How to control Pie Chart using percentage data

Hi,

I created a pie-chart using percentage of counts. I have percentage data for example(40.43%,21.28%,4.26%,6.38%, 8.51%,19.15%). 

I would like to round up to integer to show in pie-chart like 40.43% to 43%, 21.28% to 21%..... So used tointeger({40.43%,21.28%,4.26%,6.38%, 8.51%,19.15%}).

It was working partially for example 40.43 showing 40.4, 21.28 to 21, 6.38 to 6.4, 4.26 to 4., 8.51 to 9.1

Please let me  know, How could i achieve the functionality  to get accurate percentages including only integers.

 

Thanks

Vinod

  Discussion posts and replies are publicly visible

Parents
  • Hi!

    Try to run this expression in the rule editor {11.1%, 12.6%, 40.43%, 5.5%}, you'll have this result:

    Type: List of Number (Floating Point) 4 items
    Value
    0.111; 0.126; 0.4043; 0.055

    To get correct numbers you need to multiply it by 100:
    {11.1%, 12.6%, 40.43%, 5.5%} * 100

    And round it. If you don't need to specify precision toInteger() will fit:
    toInteger({11.1%, 12.6%, 40.43%, 5.5%} * 100)
Reply
  • Hi!

    Try to run this expression in the rule editor {11.1%, 12.6%, 40.43%, 5.5%}, you'll have this result:

    Type: List of Number (Floating Point) 4 items
    Value
    0.111; 0.126; 0.4043; 0.055

    To get correct numbers you need to multiply it by 100:
    {11.1%, 12.6%, 40.43%, 5.5%} * 100

    And round it. If you don't need to specify precision toInteger() will fit:
    toInteger({11.1%, 12.6%, 40.43%, 5.5%} * 100)
Children
No Data