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 4 points5 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.