Query the Data using CreatedOn fileds using Grouping

Did you try to use the query editor in an expression rule using a!queryRecordType()?

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

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.

use the aggregations to group the records using the queryRecordType()

I tried in Query Edited i got it for month and year how about week and quarters

walterw169618 said:

how about week and quarters

I would recommend creating custom record fields and using these values for grouping

can you tell in elaborate 

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

docs.appian.com/.../custom-record-fields.html