160647 - no subject - Hi All,\n\nI'm new to Appian and I'm hav

I'm starting with a few assumptions: I'm assuming that you're using a!queryEntity() and that you're using a!queryAggregation() inside it. If this is the case, then you won't be able to group by day/week/month based on the timestamp field.
My recommendation is to create a SQL View for the data. You can create a view to include the relevant columns from your table as well as calculated columns for day, week, and month. Then if you create a cdt to map to your view and use a!queryEntity on that cdt, you will be able to aggregate on the day/week/month fields.
If you decide to set up your data this way, then you should be able to follow this SAIL Recipe for the start/end date filters and aggregation: forum.appian.com/.../SAIL_Recipes.html

I'm starting with a few assumptions: I'm assuming that you're using a!queryEntity() and that you're using a!queryAggregation() inside it. If this is the case, then you won't be able to group by day/week/month based on the timestamp field.
My recommendation is to create a SQL View for the data. You can create a view to include the relevant columns from your table as well as calculated columns for day, week, and month. Then if you create a cdt to map to your view and use a!queryEntity on that cdt, you will be able to aggregate on the day/week/month fields.
If you decide to set up your data this way, then you should be able to follow this SAIL Recipe for the start/end date filters and aggregation: forum.appian.com/.../SAIL_Recipes.html