I would like to create a donut chart that shows a single percentage, so at 75% the circle would be 3/4 full. I tried creating this by utulising a second formula column that subtracts the desired Percentage from 100 thus giving a second input for Donut, however as this answer sits in the same row on another column I can't bring it in to the chart, is there a way to do this, I'm stuck with using guage charts which are not ideal
I'd love to help you out, but can you provide more info about this?
What does the table look like, which columns you need to include on the chart, what's the data? If you can provide me the table, I can probably help you out with the chart.
the table is a collection of answers from a gravity form which all have numerical values. The tables are set to only show a user their own data so they see just their own charts. The columns I would like to display in the donut chart are formula columns which calculate a percentage of progress. I can either create a second formula column which calculates the difference between progresss and 100% or perhaps a simpler option would be to give the donut chart a minimum value of 100%. However I can’t work out how to do that either!
The donut chart uses only 2 columns, like a Pie chart. One is for the labels, and the other one is for data. So, all rows consist of 100% data. If you have only one row to be displayed on the chart, it will show 100%, as it is the only available value.
Would you be able to provide me a temporary wp-admin for your website, and tell me which table and which columns need to be plotted on the chart, and I'll try to help you out with creating that chart?
Please note that the ticket is public, so don't forget to enable the PRIVATE response.
To create this chart, you need two columns - string and integer (or float). So, if I use "Customer Pilar" and "User" columns, I get this chart:
We can group the chart, so it shows percentage per User:
If I understood you correctly, you'd like these values to be stored as percentages:
That's not possible, I'm afraid. The donut chart uses values from a column as 100%, then it splits them per row, or if we enable grouping - per string column. So, in this case Paul's rows consist of 11% of data from this column.
You would need to restructure the table in order to create a chart like that. However, I still don't understand how the data should be plotted on that chart.
The above looks pretty straight forward - one row of Customer Pillar and percentage remaining customer should be one chart of 100%, right?
If you go for the range picker and select one row from these two columns:
The chart would show 100%:
Since one column is used for labels, while the other one is used for the slice %.
So to create a table for a chart like this, it'd need to be structured like this:
just getting to this as we've had a long weekend here, I understand now that I need to restructure to make the charts I would like , I'm just not sure how I go about that restructure when using a formula to create the second row, or even if it's possible in the plug in
I don't believe you'll be able to do this easily, Paul.
You would also need some other data on the chart, I suppose, other than just TYPE and VALUE. I mean - if you transpose columns into rows using only these two columns you would not see any personal data, like "Paul", "Dahad", "Dom", etc. It would be a chart with multiple "Customer Pilar" and "Percentage Remaining Customer" data, and you wouldn't know what's what.
I would like to create a donut chart that shows a single percentage, so at 75% the circle would be 3/4 full. I tried creating this by utulising a second formula column that subtracts the desired Percentage from 100 thus giving a second input for Donut, however as this answer sits in the same row on another column I can't bring it in to the chart, is there a way to do this, I'm stuck with using guage charts which are not ideal
Thanks in advance
Paul
Hello Paul
Thank you for your purchase
I'd love to help you out, but can you provide more info about this?
What does the table look like, which columns you need to include on the chart, what's the data? If you can provide me the table, I can probably help you out with the chart.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Hi Aleksander
the table is a collection of answers from a gravity form which all have numerical values. The tables are set to only show a user their own data so they see just their own charts. The columns I would like to display in the donut chart are formula columns which calculate a percentage of progress. I can either create a second formula column which calculates the difference between progresss and 100% or perhaps a simpler option would be to give the donut chart a minimum value of 100%. However I can’t work out how to do that either!
Does that help?
does the screenshot help it make sense?
Hi again Paul
Yeah, it does clear it up a bit.
The donut chart uses only 2 columns, like a Pie chart. One is for the labels, and the other one is for data. So, all rows consist of 100% data. If you have only one row to be displayed on the chart, it will show 100%, as it is the only available value.
Would you be able to provide me a temporary wp-admin for your website, and tell me which table and which columns need to be plotted on the chart, and I'll try to help you out with creating that chart?
Please note that the ticket is public, so don't forget to enable the PRIVATE response.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Hi again Paul.
Thanks for the credentials.
To create this chart, you need two columns - string and integer (or float). So, if I use "Customer Pilar" and "User" columns, I get this chart:
We can group the chart, so it shows percentage per User:
If I understood you correctly, you'd like these values to be stored as percentages:
That's not possible, I'm afraid. The donut chart uses values from a column as 100%, then it splits them per row, or if we enable grouping - per string column. So, in this case Paul's rows consist of 11% of data from this column.
You would need to restructure the table in order to create a chart like that. However, I still don't understand how the data should be plotted on that chart.
The above looks pretty straight forward - one row of Customer Pillar and percentage remaining customer should be one chart of 100%, right?
If you go for the range picker and select one row from these two columns:
The chart would show 100%:
Since one column is used for labels, while the other one is used for the slice %.
So to create a table for a chart like this, it'd need to be structured like this:
And the resulting chart would be:
You can see both charts on playground page.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
HI Aleksander,
just getting to this as we've had a long weekend here, I understand now that I need to restructure to make the charts I would like , I'm just not sure how I go about that restructure when using a formula to create the second row, or even if it's possible in the plug in
thanks
Paul
I don't believe you'll be able to do this easily, Paul.
You would also need some other data on the chart, I suppose, other than just TYPE and VALUE. I mean - if you transpose columns into rows using only these two columns you would not see any personal data, like "Paul", "Dahad", "Dom", etc. It would be a chart with multiple "Customer Pilar" and "Percentage Remaining Customer" data, and you wouldn't know what's what.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables