Hi,
I have created one custom record field where it calculated sum of all the event points present in the table.But I'm trying to display this data in the grid based on the date range selection so basically if that date range has only one row with event point = 10, it should display only row with value 10 but it is displaying the sum of all 100 rows in a single row. How to handle single row data calculation in appian records?
Discussion posts and replies are publicly visible
Don't use custom record fields for filtered aggregations, they calculate across entire dataset regardless of UI filters.https://docs.appian.com/suite/help/25.3/custom-record-fields.html?utm_source=chatgpt.com#sync-time-evaluationsYou can try below 2 methods.Display the source eventPoint field directly in grid and apply date range filters in a!recordData() query(custom fields bypass grid filters)Query filtered records using date filters, then calculate sum in the interface instead of custom field.
I tried referencing the eventPoint field directly in the grid and applied date range filters using a!recordData(). However, I’m only getting the first 10 rows of data, even though there are over 500+ rows for that date range. Is there any restriction causing this?
eventPoint
a!recordData()
I hope you are using 25.2 as it has default limit of 10.You can increase this limit using a!relatedRecordData() parameter.