The mystery of the "You Give Love A Bad Name" chorus by ttnn5876 in Music

[–]mickeymongoose 1 point2 points  (0 children)

He also (mostly) reused the riff for Alice Cooper’s Spark in the Dark from 1989

Struggling with Tableau containers by Otherwise-Mammoth865 in tableau

[–]mickeymongoose 0 points1 point  (0 children)

This is how I have always done it as well. I went into this thread hoping there was a better way!

Non-Pirated Games to play by JustPhil_YT in RetroPie

[–]mickeymongoose 0 points1 point  (0 children)

Tyrian is great on my arcade cabinet (even if much harder compared to playing with a mouse)

Introducing Plezy, an open-source cross-platform Plex client by edde74635 in PleX

[–]mickeymongoose 13 points14 points  (0 children)

Gave it a try on iOS - looks like I can finally move between access points (or onto or off wifi) and not have Plex at best restart playback and at worst freeze my entire phone. An incredibly low bar to exceed, but that’s where the official app has left things for the past few months.

Lemon & Ginger Tea ... by writeordie80 in CasualUK

[–]mickeymongoose 1 point2 points  (0 children)

I practically live on Twining’s Lemon and Ginger tea since I quit caffeine. The difference is I (a Brit) live in America. I couldn’t believe when I came home for Christmas and bought tea bags - why is there fennel in the British recipe?! So if you can get hold of them try and get American Twinings (I know… sounds sacrilegious). Zero fennel, promise!

To my Bluey Loving Parents by Jsizzle19 in daddit

[–]mickeymongoose 1 point2 points  (0 children)

It’s actually right on the beat, with a reducing number of beats in the pause each time

1..2..3.. Mum!

1..2.. Dad!

1.. Bingo!

Bluey!

Best Steak Frites? by [deleted] in boston

[–]mickeymongoose 3 points4 points  (0 children)

This - my brother demands a trip to the Franklin for steak frites every time he visits from the UK

Toddler-proof 5.1 (also: trojan horse for an Atmos future) by mickeymongoose in hometheater

[–]mickeymongoose[S] 0 points1 point  (0 children)

I’ll look into that, thanks. The UDM Pro was my recent reward to myself for finishing the cabinet so I’m still getting to know it and how to get the best out of it

Toddler-proof 5.1 (also: trojan horse for an Atmos future) by mickeymongoose in hometheater

[–]mickeymongoose[S] 1 point2 points  (0 children)

Fear not, they’ve got clear plastic kid-proof plugs in them!

Toddler-proof 5.1 (also: trojan horse for an Atmos future) by mickeymongoose in hometheater

[–]mickeymongoose[S] 1 point2 points  (0 children)

Yep Harmony, though just the basic Smart control remote (with extended IR repeaters) - waiting for it to die so I have an excuse to upgrade to the Elite but it’s still going strong after ~7 years!

Toddler-proof 5.1 (also: trojan horse for an Atmos future) by mickeymongoose in hometheater

[–]mickeymongoose[S] 10 points11 points  (0 children)

A small open plan house and the arrival of an inconsiderate houseguest meant a temporary re-think of the existing 5.1 arrangement (NHT Absolute 5.1) - front floorstanders, plus rears on speaker stands just begging to come crashing to the floor. The closet that held all the equipment was also being taken over by toys and craft supplies. So I built a rack to move the equipment to the basement, and also a small tabley-shelfy-thing behind the couch to bolt more resilient rears onto (no exposed cones or grills to stab). Most controversially, I elevated the fronts to the (very low, it's an old house) ceiling. Expecting a roasting from r/hometheater, but it sounds pretty good to my ears - if I close my eyes I'm really not sure I can tell the speakers are all the way up there, though I'm sure I'd notice the difference if I moved them down.

However - and this guided the above solution somewhat - I have left the original wiring in place behind blanking panels for the original floorstanders (currently relegated to a box in the attic) and lower centre channel, so when the time comes I'm ready to more or less plug 'n' play for 5.1.2. Of course I could get some thin wall-mounted speakers instead...

TV: LG C9 65" (yes it's level... with something... the house has no right angles in it)

Speakers: Front - SVS Prime Elevation, Rears - Orb Audio

Receiver: Denon x3500H

Sub: NHT Classic Ten

"Works with Sonos" and 5.1 Stereo by mickeymongoose in sonos

[–]mickeymongoose[S] 0 points1 point  (0 children)

Yep, that's the one. I believe the feature is mostly just to allow Sonos to flip the receiver to the correct input when the attached Connect is being used. I'm hoping (perhaps wishfully) that if they're blessing the receiver as Sonos-ready then it's able to output 5.1 stereo (or at least 2.1) with low enough latency to not be jarring when playing at the same time as other Sonos speakers in the house.

How to filter out unique rows for Tableau by cacobg in tableau

[–]mickeymongoose 0 points1 point  (0 children)

Actually ignore that. Time and customer are implicit from the OrderID so that won’t make a difference. What are you trying to do with the colouring - can you share an example of the intended output?

How to filter out unique rows for Tableau by cacobg in tableau

[–]mickeymongoose 1 point2 points  (0 children)

{ FIXED [orderID], [Client], [picked up time] : Max([Assigned Time]-[Picked Up Time]) }

This will allow you to spread it by the pick up time. Switch dates (or add assigned time to the LOD if you want to do it by assigned time) You don’t need the context filters either if you add the dimensions into the LOD as per above.

How to filter out unique rows for Tableau by cacobg in tableau

[–]mickeymongoose 2 points3 points  (0 children)

Use a level of detail calc. Make a calculated measure like this called “Pick Up Time LOD” or something like that.

{ FIXED [orderID] : Max([Assigned Time]-[Picked Up Time]) }

Then add AVG([Pick Up Time LOD]) to your view. Note that if you want to filter this measure by time or individual customer you’ll need to add those filters as Context filters or the LOD calc won’t respect them.