Expand my Community achievements bar.

Join us for the next Community Q&A Coffee Break on Tuesday April 23, 2024 with Eric Matisoff, Principal Evangelist, Analytics & Data Science, who will join us to discuss all the big news and announcements from Summit 2024!
SOLVED

adobe workspace rolling fiscal month as metric headers for dashboard

Avatar

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

Avatar

Correct answer by
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

Avatar

Correct answer by
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