i have client who basically collecting rating data which is being pushed into a google sheet document, the rating is pretty simple
1 = not good
...
5 = great
everything works well until i need to take the data collected and display the as a an aggregated percentage.
currently the data is essentially being added together, so when you display a bar chart (as an example), instead of the max value being 5 and the chart averaging the values, the axis values start to become larger and larger.
i've tried to use the avg shortcode, and then remove the axis labels but then the data isn't descriptive enough hope this makes sense
Hi michaelwissekerke, Thank you for your purchase.
It is very difficult for me to give you my suggestion until i see the chart and the data that is used for it.
So can you please provide me a temporary WP-admin login for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party. You can write credentials here just check Private Reply so nobody can see them except us.
Also point me to the chart ID so I can take a look.
Ok now I can see it. As I understand you want for the y axes to have the maximum 5 in the label instead of 12 ( for chart training (fit))
Unfortunately it is not possible to achieve this if you enabled the grouping option in chart.
As an alternative my suggestion is to make pie chart like I did ( wpdatatables support chart)
The pie chart will display in percents how many Polls are in the table.
But when you enable Grouping option our plugin will sum the number of entries which have the same name and unfortunately that is something that can not be changed.
You can also take a look at our documentation about wpDataCharts callbacks to see how you can customize the charts by your needs and limit the Y axis to have the maximum value 5.
"As I understand you want for the y axes to have the maximum 5 in the label instead of 12 ( for chart training (fit))"
in the interest of clarification i actually want to display the average rating (out of 5), but considering that i'm grouping the data it wouldn't be possible (even though this is happening in the table).
Hi guys
ok background:
i have client who basically collecting rating data which is being pushed into a google sheet document, the rating is pretty simpleeverything works well until i need to take the data collected and display the as a an aggregated percentage.
currently the data is essentially being added together, so when you display a bar chart (as an example), instead of the max value being 5 and the chart averaging the values, the axis values start to become larger and larger.
i've tried to use the avg shortcode, and then remove the axis labels but then the data isn't descriptive enough
hope this makes sense
thanks for a great plugin BTW
Hi michaelwissekerke,
Thank you for your purchase.
It is very difficult for me to give you my suggestion until i see the chart and the data that is used for it.
So can you please provide me a temporary WP-admin login for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party. You can write credentials here just check Private Reply so nobody can see them except us.
Also point me to the chart ID so I can take a look.
Best regards.
Kind Regards,
Miloš Jovanović
[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 michaelwissekerke,
Ok now I can see it.
As I understand you want for the y axes to have the maximum 5 in the label instead of 12 ( for chart training (fit))
Unfortunately it is not possible to achieve this if you enabled the grouping option in chart.
As an alternative my suggestion is to make pie chart like I did ( wpdatatables support chart)
The pie chart will display in percents how many Polls are in the table.
But when you enable Grouping option our plugin will sum the number of entries which have the same name and unfortunately that is something that can not be changed.
You can also take a look at our documentation about wpDataCharts callbacks to see how you can customize the charts by your needs and limit the Y axis to have the maximum value 5.
Best regards.
Kind Regards,
Miloš Jovanović
[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
ok cool, i'll see what i can come up with. thanks for the assistance
"As I understand you want for the y axes to have the maximum 5 in the label instead of 12 ( for chart training (fit))"
in the interest of clarification i actually want to display the average rating (out of 5), but considering that i'm grouping the data it wouldn't be possible (even though this is happening in the table).
Hi michaelwissekerke,
Unfortunately then something like this is not possible.
Maybe you will be able to display it but if the grouping option is unchecked.
Best regards.
Kind Regards,
Miloš Jovanović
[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