I have a table with two columns, a number and a date by months. The date can be repeated, for example: number|date 1|2023-12 9|2023-12 2|2023-11 4|2023-11 I want to create a line char by date with the average number for each date, such that: average|date 3|2023-11 5|2023-12 With graphs with excel or power bi it comes given, no need to create an extra table to compile that average per date. Is it possible with this pluging?
I see the option "Enable grouping" to sum up values.
If I understood, you need an Average count for grouped up values per each date, rather than summed up value per date on the charts?
Sorry to disappoint you, but at the moment, we only have the "chart grouping" feature which will sum up all the grouped values that have the same label.
to see if someone may be already suggested this feature. If you can't see it, feel free to add your suggestion there, and as more people vote, the feature will move higher on the priority list.
You can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;
and our newsletter, so you're informed about new features, bug fixes, freebies, etc.
Good morning,
I have a table with two columns, a number and a date by months. The date can be repeated, for example:
number|date
1|2023-12
9|2023-12
2|2023-11
4|2023-11
I want to create a line char by date with the average number for each date, such that:
average|date
3|2023-11
5|2023-12
With graphs with excel or power bi it comes given, no need to create an extra table to compile that average per date.
Is it possible with this pluging?
I see the option "Enable grouping" to sum up values.
Thank you very much.
Hi Santiago,
If I understood, you need an Average count for grouped up values per each date, rather than summed up value per date on the charts?
Sorry to disappoint you, but at the moment, we only have the "chart grouping" feature which will sum up all the grouped values that have the same label.
https://wpdatatables.com/documentation/wpdatacharts/grouping-in-charts/
For the "Average" on grouped values on charts, you can make a development suggestion.
Please feel free to search on our suggestions page,
to see if someone may be already suggested this feature. If you can't see it, feel free to add your suggestion there, and as more people vote, the feature will move higher on the priority list.
You can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;
and our newsletter, so you're informed about new features, bug fixes, freebies, etc.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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