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
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

adobe workspace rolling fiscal month as metric headers for dashboard

davidcmm
Level 1
Level 1

I need a monthly fiscal range from the 22nd of the previous month to the 21st of the current month that shows up in the Time Section right below the metrics section in Adobe Workspace.

Many thanks in advance.

David C

1 Accepted Solution
ursboller
Correct answer by
Community Advisor
Community Advisor

i first tried with a custom date range, the closest i could do is the following:

1489639_pastedImage_0.png

this time range will take you close to the desired time range, but doesn't work for some month:

feb/march due to the number of days in february

jul/aug due to the 2 month in row with 31 days

a workaround could be the following: create a segment and use it either in each project or in a virtual report suite:

1489646_pastedImage_6.png

basically you create a hit segment which only counts hits for the desired days of lost month and those from this month. if your project has a time range of "last 60 days" and you add this semgent to the header, you will only have the desired hits:

1489647_pastedImage_7.png

the problem is, that this only works if you use it in the last days of a month, not in the first days of a new month. but you could use this for sending reports out to business every 22nd of each month ...

i hope someone else finds the right solution

View solution in original post

1 Reply
ursboller
Correct answer by
Community Advisor
Community Advisor

i first tried with a custom date range, the closest i could do is the following:

1489639_pastedImage_0.png

this time range will take you close to the desired time range, but doesn't work for some month:

feb/march due to the number of days in february

jul/aug due to the 2 month in row with 31 days

a workaround could be the following: create a segment and use it either in each project or in a virtual report suite:

1489646_pastedImage_6.png

basically you create a hit segment which only counts hits for the desired days of lost month and those from this month. if your project has a time range of "last 60 days" and you add this semgent to the header, you will only have the desired hits:

1489647_pastedImage_7.png

the problem is, that this only works if you use it in the last days of a month, not in the first days of a new month. but you could use this for sending reports out to business every 22nd of each month ...

i hope someone else finds the right solution

View solution in original post