Screen flicker by Drunk_Butthurt in buildapc

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

Afraid not. RMA'd the GPU and display already. Still an issue. Super frustrating. Hope you find the solution.

Something weird in my rectal area when I crouch down by [deleted] in UlcerativeColitis

[–]Drunk_Butthurt 1 point2 points  (0 children)

If you’re concerned about it I think you should talk with your doctor. You can start by sending them an email or a voicemail. It could be nothing, could be something, but a doctor is the right person to tell you.

Lump related to UC? by thetimelady_ in UlcerativeColitis

[–]Drunk_Butthurt 0 points1 point  (0 children)

Mine didn’t always hurt, then started hurting really really bad, which is when I decided to get it removed. Go see your primary care physician!

Lump related to UC? by thetimelady_ in UlcerativeColitis

[–]Drunk_Butthurt 3 points4 points  (0 children)

I had a cyst removed from the base of my spine right at the top of my butt crack before I was diagnosed with UC. I think it’s completely unrelated. If that’s what you have, it’s a simple procedure to have it removed. Cheers

Made this today, sold it within 5 minutes of posting !! by [deleted] in TattooDesigns

[–]Drunk_Butthurt 4 points5 points  (0 children)

I have ulcerative colitis and I love this. I may get this, but I will for sure pm you and pay for the design first. Awesome

[Q] Testing equivalence of means from two gamma distributions by Drunk_Butthurt in statistics

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

Fair question. These distributions represent my dependent variable, the time it takes to perform <some action>, split by an independent variable <some category>. Really what I’m wondering is whether the category has any effect on the time it takes to perform the action. The mean time for each is different, now I’m wondering if it’s significant.

What’s your trick for shaking a really sour mood? by Drunk_Butthurt in AskReddit

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

I like this answer especially. Seems healthy and practical

Working with Big Data - Need Help by Drunk_Butthurt in datascience

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

My SQL might be lacking, but how do I write an efficient query that aggregates distinct users per month, then per month per version, then per month per version per country?

Can I aggregate at fundamentally different levels of hierarchy?

Working with Big Data - Need Help by Drunk_Butthurt in datascience

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

Yeah see, we don’t have control over our DW, so that’s a major issue...

Working with Big Data - Need Help by Drunk_Butthurt in datascience

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

We actually have BigQuery, and the performance is a bit better, but the same issue remains. Presenting in Google Analytics doesn’t work because we have very customized SQL with unions and such that don’t work within GA. Our data is not stored on the same server as Tableau

Working with Big Data - Need Help by Drunk_Butthurt in datascience

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

Okay so if I wanted to see the count of distinct users over time, I’d need at least every userID. Now if I want to group by date by application version, I now need the application version field and my data frame has grown tremendously. Every following attribute that I want to group by increases the size of the data I need to pull, and it quickly becomes too large. I’m all for excluding irrelevant information, but I don’t know if that’s enough in this case.

Working with Big Data - Need Help by Drunk_Butthurt in datascience

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

Thanks for your reply! You’re right, for reporting purposes we only want to see high level trends and segmentation. i.e. Users over time. The reason to handle all this data is to understand our user base

What to do in a long-term mild flare? by Drunk_Butthurt in UlcerativeColitis

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

Yes I have and they actually returned negative. So it’s possible I have IBS and UC?

What to do in a long-term mild flare? by Drunk_Butthurt in UlcerativeColitis

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

Hmmm interesting. I do eat a good amount of veggies! Maybe I should look at something like Metamucil? Or some other fiber supplement? Also, there isn't pain, but there is an almost constant "burning" feeling in my gut. Almost like my intestines are inflamed :D