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

1 Year prior report

Avatar

Level 3

Hi folks,

I am comparing my mobile data for last June and this June

I seeing  a difference of 100 downloads, same for July data.

Is this related to some algorithm stuff. The difference isn't too large but yet around 100.

Thanks

1 Accepted Solution

Avatar

Correct answer by
Level 3

Hi folks,

got my answer:

it's a leap year issue, last year was a leap year so in the 1 year prior data column, 1 day gets slashed from the uptil month which you pull the data for. As you keep on adding more months to the column, the previous months keep getting fixed and upcoming month loose data worth a day! Quite interesting though, thnks. Hope this might help someone else.

View solution in original post

4 Replies

Avatar

Community Advisor

"when i look out of my window, i can see 99 sheps. compared to yesterday, there is one less! same as two days ago! might it be due to the bad wheater condition?"

i really tried hard to understand your question, but there might be so many reasons for a difference. can you write a little bit more about the problem? do you expect something different? did you have other numbers a year ago? do you use any segments? ...

Avatar

Correct answer by
Level 3

Hi folks,

got my answer:

it's a leap year issue, last year was a leap year so in the 1 year prior data column, 1 day gets slashed from the uptil month which you pull the data for. As you keep on adding more months to the column, the previous months keep getting fixed and upcoming month loose data worth a day! Quite interesting though, thnks. Hope this might help someone else.

Avatar

Employee Advisor

We noticed this with the '1 year prior' column and have notified it to engineering. However, since it is affecting a column which not many customers use, and has easy workarounds, it is set to low priority.