Getting dynamic data into a bubble dhart

[micknoosa]

So I have read forum post around the same question but I simply can’t get my head around exactly how to structure these expressions to return the data I want in Chart.JS:

My data looks like this:
Hamper (with relevant fields)
*Total Weight
*Order Date
*Hamper Type (option set)

I am trying to display this data onto a bubble chart with dates on the x axis, Y axis is the count and radius being the average weight

There would be 3 series then representing the 3 “Hamper Types”

So my expression for aggregating the count looks like this:

Search for Hampers where Hamper Type = 1st type, then this is subjected to a “groupby” based on Order date (Days, 1, current day -60) with aggregation “count”

Finally asking for “each items count”

The other expressions are the same, returning “Items date ordered” and “item’s average of total weight”

I’m tearing my hair out!? What am i missing?

[micknoosa]

In case this is useful to anyone else the ending correct expressions were:

The Data series were defined as:

• “Search for…” constrained to “Hamper Type” (for each series),
• sorted by date, descending “no”
  “Grouped by” date order / Day and interval 1 day, starting date = current -30 and aggregation = count / average etc
  “Each item’s count / average etc”