We are a handball club who sells lottery and we only have 2000 of type 1 and 500 of type 2.
I'd like to create summary chart which counts the total number ordered of each type. I cannot make this work. I can do it per team (F2006, F2007, F2008 etc) but not a total.
I don't quite understand how your table is configured. Can you please share a screenshot of your table with me? What are rows, and what are columns in this table?
If I understood correctly, you need to add an integer column with the default editing value set to "1". When you include this column in the chart, you can enable "Grouping", so the chart groups all 1s into a SUM, and display it on the chart.
Something like this:
Then, when you create a chart, you can use the grouping feature:
There, you can see that the values are grouped per team.
Hello.
We are a handball club who sells lottery and we only have 2000 of type 1 and 500 of type 2.
I'd like to create summary chart which counts the total number ordered of each type. I cannot make this work. I can do it per team (F2006, F2007, F2008 etc) but not a total.
Is there a way to do this?
/Anders
Hello Anders
Thank you for your purchase.
I don't quite understand how your table is configured. Can you please share a screenshot of your table with me? What are rows, and what are columns in this table?
If I understood correctly, you need to add an integer column with the default editing value set to "1". When you include this column in the chart, you can enable "Grouping", so the chart groups all 1s into a SUM, and display it on the chart.
Something like this:
Then, when you create a chart, you can use the grouping feature:
There, you can see that the values are grouped per team.
I hope that helps.
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