Your annual reminder that your monthly metrics will be down 10% in February because February is 10% shorter than January. Please do not contact your data team about it.
@seldo 30-day trailing "months" for the win
@xian @seldo No, no, trailing 28 days. Always use an even number of weeks, because lots of things have weekly patterns, so if you use something that isn't a multiple of 7 days, you end up introducing a bit of a "beat" to the time series depending on how many weekends your trailing days include.
@abulsme @seldo good point, just be prepared to have 13 of them in a year lol
@xian @seldo Yeah, or just have a time series of trailing 28 days updated daily or weekly and look at that instead. Or 13 β€œmonths” is fine too I guess. πŸ™‚
@abulsme @seldo yeah since trailing it is irrelevant but fun to say

@xian @abulsme @seldo Italian phone companies tried to apply this reasoning a few years ago, to lure customers into paying "monthly" fees 13 times in a year (instead of 12).

They got fined by the antitrust authority and the practice has been deemed illegal since then, luckily.

@lazza @xian @seldo Ha. Well that is a bit different than metrics tracking. Trailing 28 day metrics are a possible substitute for monthly metrics, but they aren’t actually β€œmonthly” and anyone useing them should be clear on what they are. What you describe sounds intentionally deceptive.

@lazza @xian @abulsme @seldo a Mexican ISP did the same thing once. All of the plans charged every 30 days...

... except the cheapest tier, which charged every 23 days.

@Almafeta @lazza @xian @seldo 23 is prime and unaligned with any normally used time frames. Is their any logic behind that timeframe other than to confuse people and make them more likely to accidentally miss a payment?
@xian @abulsme @seldo We need the International Fixed Calendar! Kodak was right
@seldo If those executives could read this would make them very upset.
@seldo I don’t have a data team, who do I contact?
@arnandegans @seldo
If you don't have a data team in the business today you're out of business tomorrow
@jdoe @seldo Maybe in your little world... I've been fine for the last 12 years without any team πŸ˜‰
@seldo A round of layoffs should take care of that.
@sometoast @seldo
Or just fire your lead engineer. That oughta fix the declining metrics
@seldo I'm a forecaster and constantly have to explain the concept of working days per month.

@seldo -- No doubt some NYT columnist will note the drop.

Apologies for the low-hanging fruit. '-)

@seldo Yup. I once created a little JavaScript page which calculated the number of working days for a specified month (less stat holidays) for this exact reason. Among other things, I learned that November is as short as February if you get Remembrance Day off.
@seldo how dare you call it 'metrics'? Aren't you proudly part of the imperial part of the world? πŸ˜…
@seldo This is such a cool insight. The typical month is about 3% shorter/longer from the previous month, purely for calendrical reasons. Thank you.
@seldo shouldn't the metric be normalized by the number of days for that reason?
@johthor It should be but try persuading finance people to stop measuring things by months.
@seldo @johthor shall we tell people about the horrors of fiscal versus calendar?
@johthor @seldo Sure, normalize everything by the number of days in the month, then suddenly your storage that is billed by $/GiB-mo is more expensive (per day) in February
@seldo
Accountant wife: "This is why we operate on a 52 week retail year, and use week over week metrics." Apparently Sales likes it, Finance hates it. "You can't file any financial statements on that basis, for one thing."

@seldo
"Last year, nearly 40% of sick days were taken on Mondays and Fridays. This is evidence that employees are abusing sick days to get a three day weekend. Going forward, any sick day taken on a Monday or Friday must be accompanied by a doctor's note"

--Memo from some small company's HR department, probably

@Kilbourn @seldo this exact 40% statistic was quoted in the organisation I'm leaving soon. All Friday/Monday sick leave is reported at board level as a result.
@seldo and April, June, September and November are all 3.5% shorter than January.
@seldo @pictureofitself wait, really? Is February really 10% shorter than the other months? (It is, I just checked, but I'd never thought of it that way before)
@thisismissem @seldo @pictureofitself well, it's 3 days less than 31-days months, so about half of the other months, including January, and 3/31 is about 10%.
@tshirtman as I mentioned, I checked, that is I did the maths to understand this. I'd just never thought of it in this quantifiable way before.
@seldo Somehow I've made it my entire life so far w/o realizing that February is 10% shorter than January.
@seldo unless you are in charge of cloud cost reduction. Then take the 10% win and shout it from the rooftops
@jondowdle @seldo but then what do you say in march?
@seldo wouldn’t this be more timely towards the end of the month?

@seldo

I think we should extend the idea.

8 pints per gallon, but the first, 3rd, 5th, 6th and 8th pints are Imperial, 20 ounces, the second is American, 16 ounces, the fourth and seventh are 19.

Own the metric libs!

@seldo I put in a ticket to have the shortness of February addressed. I'm told that they won't be able to look at it until 2024, but they're only promising a 3.5% increase initially.
@seldo Submitting change request for 12 30-day months + 5 'free' days at the end of the year.
International Fixed Calendar - Wikipedia

Timescale Docs

Normalize a monthly metric based on number of days in month

@seldo When I was working at GoDaddy, they fired one of the 5 guys on my team. A week later we started having daily meetings to discuss how productivity was down 20%.

@seldo

OK, I get that February is shorter, but why are clicks down? January wasn't like this.

@seldo not even to ask them to normalise for days in the month?
@seldo what about "per day" metrics? :-)
@seldo Also January cohort looks better on monthly retention since a larger share joins at the end of the month.
@seldo can't we just agree to compare to previous year and not previous month? Comparing to previous month for most orgs just seems pointless to me.
@seldo @Cdespinosa (adding to my Monday morning staff meeting agenda)
@seldo While we're here, 40% of sick days falling on Mondays and Fridays is not a sign of people scamming long weekends...

@seldo just like how over 70% of all sicknesses begin during the working week, and more than 20% of staff who call in sick do so on a Monday!

(statistical literacy is hard :P)

@seldo Gifting a hobbit calendar to the data team to give them a hint.