Pie Charts Wrong Data Displayed

  • Resolved angolanmade

    (@angolanmade)


    3 years, 12 months ago

    Hi, Thanks for the awesome plugin, I have been testing it out and have come-up against a few items that I simply can’t understand or figure out.

    I have created a simple google spreadsheet with the following three columns and ten (10) entries of data – https://i.imgur.com/oxnoHn1.jpg

    ID | Name | City
    1 | ACBD | Toronto
    2 | ACBD | Toronto
    3 | ACBD | Toronto
    4 | ACBD | Toronto
    5 | ACBD | Toronto
    6 | ACBD | Montreal
    7 | ACBD | Montreal
    8 | ACBD | Montreal
    9 | ACBD | Montreal
    10 | ACBD | Montreal

    When attempting to create a simple pie chart analysis to display a 50% split between the cities using “ID and City” with “Enable Grouping” enabled end-up with 72.7% Montreal and 27.3% Toronto

    https://ufile.io/ca3qc4qt — Video of chart creating process

    https://i.imgur.com/qd3UrxC.jpeg — results of chart

    What is the correct steps to ensure that the pie chart displays the correct data showing 50% Montreal, 50% Toronto split?

    Lastly, tried playing around with a spreadsheet that displays athletes “height” in the following format 6’6″, however when I try to change the column type from “string to “integer” or “float” in wpdatatables it shows the data incorrectly formatted?

    Thanks again, sorry for the long explanation, hopefully it is detailed enough.

Viewing 1 replies (of 1 total)
  • Plugin Author wpDataTables

    (@wpdatatables)

    Hi angolanmade,
    Sorry for inconvenience,
    Yes that is correct because you use ID column as value column which start from 1 to 10 and then when this is split in proportion of those two cities(Toronto have 15(1+2+3+4+5) and Montreal have 40 (6+7+8+9+10))

    To achieve what you need you have to create a table like this:

    ID | Name | City | Amount
    1 | ACBD | Toronto 50
    2 | ACBD | Montreal | 50

    or

    ID | Name | City | Amount
    1 | ACBD | Toronto 1
    2 | ACBD | Montreal | 1

    And then to create a table from columns City and Amount.

    Grouping is not available in Lite version of plugin so if you have question for premium version please contact us on our support platform that you can find on our official website, because support for premium plugin is not allowed here.

    For displaying height in wpdatatables as number you will need to insert it as integer of float. Any other format will be treated as string.

    Best regards.

Viewing 1 replies (of 1 total)
  • The topic ‘Pie Charts Wrong Data Displayed’ is closed to new replies.