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.