Expand my Community achievements bar.

Submissions are now open for the 2026 Adobe Experience Maker Awards

Strange behavour on Date ranges relative to panel

Avatar

Level 3

Hi! I use a customized date range for my panel (start > when the site was officially launched | end > rolling day - 1 day). There are some tables on which I have to apply a shorter date range (let's say, from October 30 until yesterday), so I created another date rage with these requirements (start > Oct 30 | end > rolling day - 1 day).

When I apply this new range to a metric, it seems to work for the total number, BUT if I breakdown by days, they don't make sense, because days outside this shorter date range get the credit. What AA is doing is that, if my shorter range has, for instance, 17 days, it allocates the values in the first 17 days of the panel date range:

In the following screenshot: Panel range > Nov. 29, 2023 until today (Nov 13). Shorter date range > Oct. 30 until yesterday (Nov 12), which is 13 days in total. As you can see, the first 13 days of the panel range get the values, though they are not in the segment applied. Any ideas?

 

Ranges.jpg

 

 

1 Reply

Avatar

Community Advisor and Adobe Champion

While I see what you are saying about comparing a longer time range to a shorter time range, I am not sure what outcome you expect when trying to look at a Daily granularity?

 

If you are comparing 30 days to 15 days in a grid, the 15 days range can only ever show 15 rows of data, whereas the table as a whole will show all 30 rows... 

 

The table isn't really showing you content outside of the range, those days (that aren't in your range) technically are labelled, but they will always show 0 because they are outside of the range. You could raise this with client care, but I assume a small visual issue like this isn't going to be high on the list to fix. It's the same as if I create a segment that says "pages that contain section" then I have two columns, one where my segment is stacked with a metric... I will still see pages that aren't sections, because my other column still has relevant data... 

 

You can always set the column settings to "Interpret 0 as no value"... while you will still see the "dates" display, the rows will be a little cleaner:

 

Jennifer_Dungan_0-1763069661278.png

 

 

Comparing different ranges will always have challenges. This is a minor display annoyance, but shouldn't impact your data or comparisons in any way.