Query the Data using CreatedOn fileds using Grouping

Question

I have some data in my DB in that one filed named "CreatedOn"(2025-11-20 06:00:44.470000) 
 i need to group the details by CreatedOn i need to group data by current year ,current quarter , current month, current week and want to sum a field called "EMI" Using a!quereyRecordType() | this will be in a rule i want to hit this rule only once to get all of this data in a stretch How to achieve it

Konduru Chaitanya · Answer

walterw169618 said: i want to hit this rule only once to get all of this data in a stretch 
 For this to happen you would need to write down the query. As Stefan mentioned you can try using the query editor in the expression rule. 
 
 Under the query editor you will have aggregate records option and once you click you can chose on what fields and criteria you would want to aggregate. 
 docs.appian.com/.../query-editor.html

EREN_YEAGER · Answer

When the Field type is of type Date,Date and Time or Time, we can use the Interval parameter of a!grouping function, in which we can provide values such as "YEAR","MONTH_TEXT" and etc to group the data based on desired interval. a!grouping function goes in the a!aggregationFields function.

EREN_YEAGER · Answer

you can create custom record fields in your base record, where you'll be able to store values such as 1,2,3 for quarters or weeks, for eg : then you can group on those custom record fields to get the result for quarters or weeks

Query the Data using CreatedOn fileds using Grouping

Top Replies