Re: Weekly earned merits (median) of top 100 merited users

Quote from: tranthidung on September 18, 2019, 06:43:27 PM

<>Ex:
- m36: total earned merits at the end of 2019w36.
- c36: earned merits from 2019w35 to 2019w36.
To know what is 2019w36, please see here

Just a quick question on the weekly earned merits:

2019w36 is defined as the range 03sep2019 .. 09sep2019 (Tuesday to Monday) according to the "please see"link. m36 should be the total earned merits at the end of that period. Nevertheless, on the 09sep2019 I had 2.631, whilst my 2.645 merits indicated for m36 really correspond to those on the last merit.txt file (13sep2019).

Is there some mistake in the naming/chosen week days for each week, or am I missing something (the data seems correct if the weeks are Friday to Friday and not Tuesday to Monday)?

I used this to compare, where n (-3) is used to shift from one week to another, and the readings are correct for Friday to Friday readings (not the same as the Wxx weekday range):

Code:

select sum(amount) nMerits
from merit
where user_to = 1582324
and converted_date >= dateadd(week,-3,convert(datetime,'06/09/2019 02:00:00',103))
and converted_date <= dateadd(week,-3,convert(datetime,'13/09/2019 02:00:00',103))

Note: time is aprox time of merit file generation.

The data seems correct, it's just that the definition of the weeks I think is based on the merit.txt file deliveries, which is different to the wxx definition.