Hey fellow bubblers!
Reaching out to the collective bubble for some help with displaying grouped data in a chart.
Background:
As it stands, I have created a chart with a search and applied the following grouping:
Grouping image:
Goal:
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!
Mike