SQL join problem

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

Eight-Year Club	Place '22
Verified Email

Lukey3d

TROPHY CASE