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

Unique vistors filtered by last day (24h), last 7 days and last 30 days

Avatar

Level 5

Hii everybody!

 

One of our product owners wants to see his product´s unique visitors by the last day, last 7 days, and last 30 days. However, changing the panel calendar will always show me the numbers based on today. Eg. if I chose the date range for February 25, I see the results for that specific 24h (day), the last 7 days from the 25th, and the last 30 days from it. However, in reality, if I choose a different day, it will always give me a value considering today as starting point. Is there a way for me to create that?

fern1_0-1688763715485.png

also, how can I create a last 24h (day) dimension since this is not a default one?

 

additionally, he would like to see in the right column also by day (even if for each case - "filter" -  we need a different table). 
Something like this dummy illustration:

fern1_1-1688764507999.png

thank you in advance

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hi, the first part of the question

 


One of our product owners wants to see his product´s unique visitors by the last day, last 7 days, and last 30 days. However, changing the panel calendar will always show me the numbers based on today. Eg. if I chose the date range for February 25, I see the results for that specific 24h (day), the last 7 days from the 25th, and the last 30 days from it. However, in reality, if I choose a different day, it will always give me a value considering today as starting point. Is there a way for me to create that?


is actually easy, Adobe released a new feature this year that will make the tables relative to the panel calendar, it can be found under "show advanced settings" then checking the box to enable it:

Jennifer_Dungan_0-1688789856436.png

 

With the default setting, your panels look like this (and are always relative to "Today"

Jennifer_Dungan_1-1688789912812.png

 

 

But when you enable this setting, the date ranges change to dynamically show the date range relative to the selected panel date (currently selected to "Today"):

Jennifer_Dungan_2-1688790005275.png

 

 

But if I were to change to Feb 25th, they become:

Jennifer_Dungan_3-1688790076848.png

 

 

 

Unfortunately, the second part of your question


also, how can I create a last 24h (day) dimension since this is not a default one?


Adobe is not designed for this type of date selection...

 

While technically you can bind a date selection by a start time (which applies to the start data) and an end time (which applies to the end date) which technically allows you to pull something like:

July 6th, 5:00pm - July 7th, 4:59pm (which would be a 24 hour segment)... there is no way to make this dynamic... 

Jennifer_Dungan_5-1688790842664.png

 

And the relative date range doesn't take the selected time into account, you can see this just becomes July 5th, and the time starts at midnight

Jennifer_Dungan_6-1688790950923.png

 

 

On top of that, once you allow people to change the panel data to "Feb 25" or whatever date they want, the current time becomes irrelevant...  the selected date would be Feb 25th as a whole and the report would just return Feb 24th....

 

If they want an interactive report where people can choose a day and get relative data back, the "last 24 hours" makes no sense... better to just build three tables for "Last 30 Full Days", "Last 7 Full Days" and "Yesterday"

Jennifer_Dungan_4-1688790525342.png

 

View solution in original post

1 Reply

Avatar

Correct answer by
Community Advisor

Hi, the first part of the question

 


One of our product owners wants to see his product´s unique visitors by the last day, last 7 days, and last 30 days. However, changing the panel calendar will always show me the numbers based on today. Eg. if I chose the date range for February 25, I see the results for that specific 24h (day), the last 7 days from the 25th, and the last 30 days from it. However, in reality, if I choose a different day, it will always give me a value considering today as starting point. Is there a way for me to create that?


is actually easy, Adobe released a new feature this year that will make the tables relative to the panel calendar, it can be found under "show advanced settings" then checking the box to enable it:

Jennifer_Dungan_0-1688789856436.png

 

With the default setting, your panels look like this (and are always relative to "Today"

Jennifer_Dungan_1-1688789912812.png

 

 

But when you enable this setting, the date ranges change to dynamically show the date range relative to the selected panel date (currently selected to "Today"):

Jennifer_Dungan_2-1688790005275.png

 

 

But if I were to change to Feb 25th, they become:

Jennifer_Dungan_3-1688790076848.png

 

 

 

Unfortunately, the second part of your question


also, how can I create a last 24h (day) dimension since this is not a default one?


Adobe is not designed for this type of date selection...

 

While technically you can bind a date selection by a start time (which applies to the start data) and an end time (which applies to the end date) which technically allows you to pull something like:

July 6th, 5:00pm - July 7th, 4:59pm (which would be a 24 hour segment)... there is no way to make this dynamic... 

Jennifer_Dungan_5-1688790842664.png

 

And the relative date range doesn't take the selected time into account, you can see this just becomes July 5th, and the time starts at midnight

Jennifer_Dungan_6-1688790950923.png

 

 

On top of that, once you allow people to change the panel data to "Feb 25" or whatever date they want, the current time becomes irrelevant...  the selected date would be Feb 25th as a whole and the report would just return Feb 24th....

 

If they want an interactive report where people can choose a day and get relative data back, the "last 24 hours" makes no sense... better to just build three tables for "Last 30 Full Days", "Last 7 Full Days" and "Yesterday"

Jennifer_Dungan_4-1688790525342.png