Post

1 follower Follow
2
Avatar

Groups: Add the First/Last Day Before Last Month as a Group Condition

Andrew Wadsworth

Hi there,

We build dashboards for clients and they often want to know the stats in certain groups for last month VS the previous month.

At the moment it is easy to segment a dynamic group for date fields based on last month and this month, but we can't however do the previous month.

So If I have stats for July 2018 now I may want to compare with June. To create June as an option I need to 'hard code' the group to be Dates greater than or equal to June 1 and less than of equal to June 30.

I can use Less than the 1st of last month as one of the filters but I can't get the 1st of June dynamically.

Here are some examples that we would be able to do:

The first of the month X months ago.

The last day of the month X months ago.

The first of the month X months from now.

The last day of the month X months from now.


X can then be a numeric input that will allow that group to remain dynamic. This would be a great addition to groups currently.

 

Thanks!

Please to leave a comment.