I have a chart component that graphs a single datapoint from a linked record field. However, the chart only looks good if it has 30 or fewer datapoints, otherwise there is pagination.
When I select “Limit number of items” and enter “30”, it charts the oldest 30 data points.
How do I limit that chart to the most recent 30 data points?
Thank you!
Try sorting by Date descending.
Hey Darren, thanks for your reply. Unfortunate that did not work. That just created another problem but putting the most recent data at the beginning of the chart.
Create a query column that retrieves the data and sorts it in descending order,and set it to only retrieve 30 rows. Then set the query as the data source for the chart, but have it sort in ascending order.
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.