Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Custom date range - Previous month to day segment

Avatar

Avatar
Shape 1
Level 1
YanaMowat
Level 1

Likes

0 likes

Total Posts

1 post

Correct reply

0 solutions
Top badges earned
Shape 1
View profile

Avatar
Shape 1
Level 1
YanaMowat
Level 1

Likes

0 likes

Total Posts

1 post

Correct reply

0 solutions
Top badges earned
Shape 1
View profile
YanaMowat
Level 1

25-02-2020

We wanted to compare current month-to date performance with the same dates last month.

I.e. if today is 25-February'2020,

this month to date would be 1-25 February'2020

AA_custom date range_This month to date.png

and previous month to day would be 1-25 January'2020.

But when setting up end date condition to "End of current day minus 1 month" in custom date ranges, it does not seem to return the dates correctly (only the start date included)

AA_custom date range_Last month to date.png

However, when creating a simple hit-level segment on this "Prev month to day" it seems to return the data impeccably and can be used instead in trend comparisons, calculated metrics, etc.

 

I still do not know why that is but it works for any similar rolling dates, i.e.. Last year to day, etc.

If anybody can recommend a better solution - please let me know.