내 커뮤니티 업적 표시줄을 확대합니다.

Submissions are now open for the 2026 Adobe Experience Maker Awards

Mark Solution

활동이 없어 이 대화는 잠겼습니다. 새 게시물을 작성해 주세요.

해결됨

Why the total numbers of by day data not equals to by month data with the segment of "last month"

Avatar

Level 3

Hi all

 

I'm trying to see the data of some key metrics such as "PV", "UV" and "Bounce Rate"...

But I notice that when I use the default segment of "last report month", the total by-day data was not equal to the by-month data for nearly all the metrics. 

 

When i look to the "Month" data, the data showed correctly. 

DebbyNPL_0-1658294313137.png

But when i look to the by day data, less data was show on the table. 

DebbyNPL_1-1658295121200.png

 

But when i combine two dimenssion together, the by day data showed correctly again. 

DebbyNPL_2-1658295170951.png

 

Could anyone explain to me why this happen?  It will be really helpful.

 

Thanks QAQ

1 채택된 해결책 개

Avatar

정확한 답변 작성자:
Community Advisor and Adobe Champion

I guess that is due to the 31 days of May and compare to the 30 days of Jun.

In the first image, the dimension is Jun but the actual report number is May data since you have the Last Month segment.

In the second image, the dimension is Day so items are listed from 1-Jun to 30-Jun but the actual report numbers are 1-May to 30-May, and the 31-May is missing as there is no 31-Jun to match.

원본 게시물의 솔루션 보기

1 답변 개

Avatar

정확한 답변 작성자:
Community Advisor and Adobe Champion

I guess that is due to the 31 days of May and compare to the 30 days of Jun.

In the first image, the dimension is Jun but the actual report number is May data since you have the Last Month segment.

In the second image, the dimension is Day so items are listed from 1-Jun to 30-Jun but the actual report numbers are 1-May to 30-May, and the 31-May is missing as there is no 31-Jun to match.