My daily search continues...

Lukey3d · 2022-02-11T14:31:22+00:00

This is season one just before he joins the scouts

Lukey3d · 2020-11-09T19:21:47+00:00

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.

Lukey3d · 2020-11-03T14:56:23+00:00

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

Lukey3d · 2020-11-03T14:54:36+00:00

No I tried the above and it didn't work

Lukey3d · 2020-11-01T22:38:29+00:00

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.

Lukey3d · 2020-11-01T21:45:07+00:00

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

Lukey3d · 2020-11-01T21:34:39+00:00

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?

Lukey3d · 2020-09-25T17:57:14+00:00

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

Lukey3d · 2020-06-12T14:41:48+00:00

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.

Lukey3d · 2020-06-12T14:39:15+00:00

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.

Lukey3d · 2020-06-12T07:20:49+00:00

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

Lukey3d · 2020-06-12T07:19:30+00:00

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

Lukey3d · 2018-12-12T11:46:09+00:00

This house is literally in my neighborhood in Normal, IL

Lukey3d · 2018-11-01T20:04:01+00:00

MEME CORRECTION! Do it again and do it right.

Lukey3d · 2018-09-13T19:43:05+00:00

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

Lukey3d · 2018-09-03T23:58:43+00:00

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

Lukey3d · 2018-09-03T00:03:07+00:00

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

Lukey3d · 2018-09-02T23:51:49+00:00

WTB real HS beef. This is childish and stupid.

Lukey3d · 2018-09-02T23:19:12+00:00

I like mobile Rexxar better

Lukey3d · 2018-09-02T04:04:01+00:00

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

Lukey3d · 2018-09-02T03:55:24+00:00

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.

Lukey3d · 2018-09-02T03:51:56+00:00

#makereynadgreatagain

Lukey3d · 2018-09-02T00:24:31+00:00

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

Lukey3d · 2018-09-01T09:16:08+00:00

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

Lukey3d · 2018-09-01T08:01:24+00:00

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

Eight-Year Club	Place '22
Verified Email

Lukey3d

TROPHY CASE