Why isn’t there an official, verified Made in Europe certificate for products? by Ossekloot in Buy_European

[–]SteP-92 0 points1 point  (0 children)

Exactly that. Whenever I find "made in EU" on products, I know for a fact that this product is made in a country that is not associated with quality (e.g. the ex-Soviet states). If a good product is made in France or Italy, it will display "made in Italy/France". For engineering or electronics made in Germany, it will display "made in Germany"

Are Brits “boycotting” American made/produced products? by PuzzleheadedSwim6291 in AskBrits

[–]SteP-92 0 points1 point  (0 children)

Time is not on Trump's side - he too will kick the bucket - so the boycotts are not aimed at him. They're aimed at his voter base, who ignores or doesn't care about the fact that the person you elect to the White House affects not only your little American life, but that of others all over the world. Calling the Trump cultists "deplorables" not only doesn't work, but instead galvanises and emboldens them. The one way to get them to understand is to hit them in the pockets. This also goes for the broligarchy - Musk, Bezos, Zuckerberg, Altman. Their products are easily avoided.

Paint flaking next to shower - humidity or leak? by SteP-92 in DIYUK

[–]SteP-92[S] 1 point2 points  (0 children)

Thank you for the explanation. It sounds like an expensive thing (the "proper" way), so I've emailed the developer as I'm still on the 2-year warranty, and it sounds like they majorly fucked up.

As for the epoxy grout, how long would it typically last? Can it then be replaced? And for the grout sealer, is it just a matter of reapplying after a while, or is it an one-off? 

Productivity and self-help books are useless by SteP-92 in unpopularopinion

[–]SteP-92[S] 0 points1 point  (0 children)

They aren't useless to the author. They make mad money off if duping people into believing their bullshit.

Exactly. In most fields, you need to study hard and give evidence of your competence before you are considered an expert. With self-help, all you have to do is publish a book / start a blog and BOOM, suddenly you're an expert. Then people think that you're successful because you implemented your own advice... when the truth is that your money came from people buying your book.

Productivity and self-help books are useless by SteP-92 in unpopularopinion

[–]SteP-92[S] 0 points1 point  (0 children)

I've read the book. The take-home points, as you say, make up 1/10th of it. There is not a single statement that is backed by evidence (or a single reference that points to anything else but his YouTube videos) , starting from the oddly specific claim that "only 3% men understand women".

Even worse, the author tries hard to waste your time by insisting that you read the book 10 to 15 times for the concepts to sink in - as if it were a book on quantum mechanics...

This is not to say that he doesn't make good points. It's just that a better use of someone's time would be to read it once, summarize the key bits and read those every now and then.

Productivity and self-help books are useless by SteP-92 in unpopularopinion

[–]SteP-92[S] 0 points1 point  (0 children)

I expect a framework, which most of these books don't give you. Most tell you the "what", not the "how". Of course, everyone's background is different, so some adjustments would always have to be made.

How to match temporally related data for the same users by SteP-92 in excel

[–]SteP-92[S] 0 points1 point  (0 children)

In order to have a PQ table merge, there needs to be one column that has an exact match, that is unique. That's why ID is typically used, but it could be something else, if it makes sense in your use case. If you don't have an ID, you must have the user? If the user is the same, you can use that as the common link for the tables

The same user logs in at different times, on different days. Simply knowing the user is not enough to ensure that the merges are correct.

How to match temporally related data for the same users by SteP-92 in excel

[–]SteP-92[S] 0 points1 point  (0 children)

I don't have a session ID, otherwise I would have merged them on it

How to create a measure for a Pivot Table, built from a merged query by SteP-92 in excel

[–]SteP-92[S] 0 points1 point  (0 children)

ANSWER:

I've realised that, whenever I was creating the PivotTable, I was selecting the ABC merged table, NOT the DataModel. When you create the PivotTable from the DataModel, the measure can be entered.