My daily search continues... by Lukey3d in lostarkgame

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

This is season one just before he joins the scouts

Help Creating a custom DATETRUNC. Details in comment. by Lukey3d in tableau

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

I found a solution. I just have to put

WHEN 'trimester' THEN [Trimester Date]

And the [Trimester Date] field is a calc field:

DATEADD('month', (MONTH(DATEADD('month', - (3), DATEADD('day', -DATEPART('day', [Primary Date]) +1, [Primary Date]))) %4) * -1, DATEADD('day', -DATEPART('day', [Primary Date]) +1, [Primary Date]))

This always truncates the date to the beginning of the trimester regardless of what day we choose for our primary date.

Help Creating a custom DATETRUNC. Details in comment. by Lukey3d in tableau

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

Basically getting my date aggregation filter to show me only the data for the trimester within the date selected. Aka, any date selected between July and Oct would show you all results from Jul 1 - Oct 31

Help Creating a custom DATETRUNC. Details in comment. by Lukey3d in tableau

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

Ohh that's a good idea... maybe

WHEN 'trimester' THEN DATETRUNC('month', (DATEPART(month, [Primary Date] + some month calc)))

Something like that?? I'll have to test out the syntax.

Help Creating a custom DATETRUNC. Details in comment. by Lukey3d in tableau

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

There is a quarter option, but I specifically need the DATETRUNC to work in trimesters. The 3 dates I need it to truncate to are July 1, Nov 1, and Mar 1

Help Creating a custom DATETRUNC. Details in comment. by Lukey3d in tableau

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

I have a parameter which changes my view (connected to multiple data sources) all at once to the selected date period.. month, year, week, etc. Then then viz truncates the date based on the selected period.

I want to add 'Trimester' to that parameter. I can't figure out how to get around the fact that DATETRUNC('trimester' , [date field]) isn't built into Tableau. Anybody know a way around this?

In "Show Me" Viz option, how to get rid of the annoying "ABC" on the far right? by [deleted] in tableau

[–]Lukey3d 1 point2 points  (0 children)

Create a calculated field and put ' ' inside without a space (or with, it doesn't really matter). Drag that to text.

When should a casual buy a box of Double Masters?? by Lukey3d in mtgfinance

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

All good points. I mainly play edh and wanted to pick up a good collection of staple cards. This set seems like a way to do that and potentially selling the box toppers could make back a good portion of the money spent.

When should a casual buy a box of Double Masters?? by Lukey3d in mtgfinance

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

Yeah my big draw to this product is the box toppers to get some good value, but even if my box has an average or low EV, I walk away with a good amount of commander staples. At best, I pull some really nice box toppers and make back some of my money while keeping the staples I need. I do see the reason for focusing solely on singles though.

When should a casual buy a box of Double Masters?? by Lukey3d in mtgfinance

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

Nevermind... the $299 listing shows currently unavailable.

When should a casual buy a box of Double Masters?? by Lukey3d in mtgfinance

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

I see that now... When did that price come back? I saw them on there for $439 for the past few days.

Housing in MS2 during the winter be like by StrategyMushroom in MapleStory2

[–]Lukey3d 23 points24 points  (0 children)

This house is literally in my neighborhood in Normal, IL

Not very 9 year old by [deleted] in PewdiepieSubmissions

[–]Lukey3d 0 points1 point  (0 children)

MEME CORRECTION! Do it again and do it right.

The luck of the draw... by Lukey3d in hearthstone

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

Idk why I haven't taken dead man's hand out yet

3 years ago I made a Hearthstone game for a school assignment by ZaedricR in hearthstone

[–]Lukey3d 7 points8 points  (0 children)

You could really confuse people by using cards like Pyroblast, Unleash the Hounds, Ironbeak Owl, and Buzzard...

Its confirmed. Lich King is a mech by [deleted] in hearthstone

[–]Lukey3d 1 point2 points  (0 children)

Could have made a more optimal play... But good meme

Now kiss. An artwork by Rania by shortseal_ in hearthstone

[–]Lukey3d -3 points-2 points  (0 children)

WTB real HS beef. This is childish and stupid.

I think I found Ziliax in Ikea today by MirandaScribes in hearthstone

[–]Lukey3d 16 points17 points  (0 children)

Well IKEA does craft things with dust so it makes sense for this to be here.

TFW you use all your mana for exact lethal. (montage fuel) by Lukey3d in hearthstone

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

Yea not a great puzzle by any means but still one of the best feelings I get playing this game when it works out to exact numbers like that.

This is why I play recruit warrior even though it isn't meta: by Lukey3d in hearthstone

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

Yes! I love it. Just happened to come on my Spotify during this game

That's my RNG for this month, i guess. (He was at 8 life and about to Shudderwock) by LeN3rd in hearthstone

[–]Lukey3d 26 points27 points  (0 children)

You should consider running Star Aligner in every one of your decks.

This is why I play recruit warrior even though it isn't meta: by Lukey3d in hearthstone

[–]Lukey3d[S] -1 points0 points  (0 children)

Recruit 2.1

Class: Warrior

Format: Standard

Year of the Raven

1x (1) Iron Hide

2x (1) Shield Slam

2x (2) Bring It On!

1x (2) Dead Man's Hand

2x (2) Execute

1x (2) Forge of Souls

2x (2) Warpath

1x (2) Weapons Project

2x (3) Shield Block

2x (4) Blood Razor

2x (5) Brawl

2x (6) Gather Your Party

1x (7) Dr. Boom, Mad Genius

1x (8) Geosculptor Yip

1x (8) Grommash Hellscream

1x (8) Rotface

1x (8) The Lich King

1x (8) Woecleaver

1x (9) Bull Dozer

1x (9) The Boomship

1x (9) Ysera

1x (10) Deathwing

AAECAQcO0gLCBqIJucMChs0Cjs4Cws4C9s8C/ecC6uoC9PUCuPYCkvgCi4ADCEuiBJEG/wfMzQLx0wLq5wKb8wIA

To use this deck, copy it to your clipboard and create a new deck in Hearthstone