How to customize aggregation period

hello team
I want to customize aggregation period ,like :
week : last Friday to this Friday
month: 15th last month to 15th this month


you need to add calculation field one for week and other for month based on your date column.

there are you 52/53 weeks in a year so you need to take each date with week number and do the same for the month.

Naveed Ali

1 Like

Thank you
What method could help to add custom week or month calculation field?

We done this during our preparation in sql code :slight_smile: