Forum Academy Marketplace Showcase Pricing Features

Chart nightmare! Displaying the last record of grouped data in a chart

Hey fellow bubblers!

Reaching out to the collective bubble :brain: for some help with displaying grouped data in a chart.

As it stands, I have created a chart with a search and applied the following grouping:

Grouping image:

I want to group the data points by the month created, and show the data for the final entry of the month in the chart data points. I can’t figure out how to select the final record of each group. I have tried the different aggregation options but the closest I can get is MAX (which is still very wrong).

How can I group my searched data and reference the last record in the group to be displayed in the chart?

I’ve lost far too many brain cells over this, with no progress - so thank you SO much in advance!