I’m looking to use the line/bar chart plugin to visualize the following data:
- Average score (on scale of 1-10) of certain items
- Grouped by the day on which the items were created
I’m using the group function with Field 1 grouped by the 1-10 score, and Field 2 grouped by the creation date. I’ve set the aggregation to an average of the score field. The result is not properly grouping the average of the 1-10 score by date however.
I’m wondering if anyone has had to create a similar setup, and may be able to provide some information on what you’ve done?