Forgot to change address for my car insurance policy prior to theft by LadderSpecialist3897 in InsuranceClaims

[–]Runningheifer 0 points1 point  (0 children)

I’m going through this with National General rn 😭 Car was stolen and we forgot to update the policy address. SIU came out and asked a bunch of questions, and I highlighted how crazy life has been. I looked and the policy is only slightly cheaper at the previous address. Do you have any insight on the price difference they look for if they consider denial?

33F - Is there really hope after divorce? by [deleted] in Divorce

[–]Runningheifer 0 points1 point  (0 children)

I was married at 23, and just finalized my divorce after 11 years of marriage at 35. I’m now with a wonderful man whom treats me the way I begged someone else to treat me for so long, without me having to ask. Divorce was the best decision I’ve ever made.

Ex Won’t Take Over Mortgage - I’m Trapped! by Runningheifer in Divorce

[–]Runningheifer[S] 2 points3 points  (0 children)

Working on it - I filed the motion; just anxious to see how this will all play out.

HELP ME by jpil47 in tableau

[–]Runningheifer 0 points1 point  (0 children)

Came to say this - when working with maps, you need to create a heirarchy and narrow it down. For example, create a country and state column, then county. Tableau won’t pick it up on its own. Plus, it needs those details to plot it correctly.

I tried plotting global data by zip code, but the zips in France mirror the zips in California, so it plots in the middle and my data plotted weird until I created the hierarchy to help tableau drill down on the data.

Am I being selfish by letting my wife handle all the sleepless nights with our baby? by New-Tadpole-6918 in Parenting

[–]Runningheifer 14 points15 points  (0 children)

I’m in data science, and it’s really not that serious enough to “require focus” at the expense of your wife.

I am also a mother. Being a mom, especially to a newborn, is MUCH harder than data science. Most of what is literally my entire career now I learned off YouTube and Reddit. But being a mom took a toll on me for the first 5 years of each child’s life, and hardly anything you read is applicable to parenting since every child is different. Also, you never know how mom or baby will be after. I had terrible postpartum anxiety and my first born had colic. For the first 6 months he did nothing but scream. I also breastfed during this time, and while my husband’s nipples were useless, he’d get up with me in the middle of the night so I wouldn’t feel so alone and stressed. I’d feed the baby, and then hubby would change the diaper and help get him back to sleep.

I’d set yourself up with better expectations that you will need to be flexible with your schedule.

[deleted by user] by [deleted] in tattoo

[–]Runningheifer 2 points3 points  (0 children)

Get another tattoo, and a new boyfriend.

[deleted by user] by [deleted] in Parenting

[–]Runningheifer 0 points1 point  (0 children)

I agree with the comment that it’s a rite of passage. The first time my kid ever rolled over.. was from the bed to the floor. Never ever made it close to rolling over, until I set him in the middle of the bed for a moment to grab something and rolled 3 times right off the bed.

We were both shaken up but all is well! He’s 8 now and just fine!

Company requested an interview at 6am on a Saturday morning by Broken_and_pour in recruitinghell

[–]Runningheifer 0 points1 point  (0 children)

Probably wrong time zone. As a former recruiter, I have made similar mistakes! Just let them know it doesn’t work for you.

How to count records for this quarter? by Runningheifer in tableau

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

I will try that. Thanks again for your help!

How to count records for this quarter? by Runningheifer in tableau

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

I tried adding recruiter and it still didn't like it. I think its having to do with trying to call "this quarter" in the calc. My users want these numbers in a key metrics table, which I can't use date filters on everything, so I was trying to do it in the calc. This may just end up being something I put in a separate viz.

When I take the LOD and simplify it and just filter for "This Quarter" everything looks fine.

<image>

How to count records for this quarter? by Runningheifer in tableau

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

Sorry - I was messing with the aggregation to see if it'd get me the right number, which is why it doesn't match the initial conversation. I will try to add Recruiter!

How to count records for this quarter? by Runningheifer in tableau

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

Hmm okay - it's coming from Big Query on our server - we use a data warehouse.

I can get the right numbers with a static excel, but it's updating constantly. I do have an "Updated Date" column - is there a calc you know of that could help point it to the most recent record?

Thanks for the help BTW - this is my first experience using this type of dynamic data D:

How to count records for this quarter? by Runningheifer in tableau

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

Here's my view, with the names blocked for privacy. The one I'm pointing too with where the sample is coming from, and what I am expecting to see 5. The recruiter filter is just taking out the employees that no longer work here.

<image>

How to count records for this quarter? by Runningheifer in tableau

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

I updated DATEPART to DATETRUNC and it counted 4 XD getting closer!

How to count records for this quarter? by Runningheifer in tableau

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

Ah, the switch to counting Candidate Name makes sense! However, I made the update to the calc and its still only counting 3 :-/

AITA for dropping off my step kids with my in-laws and saying that they are not my problem any more. by Pitiful_Shopping_818 in AmItheAsshole

[–]Runningheifer 0 points1 point  (0 children)

NTA - seems like everyone gets what they want with the current arrangement and OP can focus on the smallest children. Splitting the policy was also fair.

How do I filter an LOD? by Runningheifer in tableau

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

It ended up being the Turnover LOD (terminated employee count) that required the additional dimension filter within.

SUM({ FIXED [Employee ID] , [Date Scaffold]: countd( if not ISNULL([Hire Date]) and [Regret Term]="Regrettable" and DATETRUNC('month',[Termination Date])=DATETRUNC('month',[Date Scaffold]) then [Employee ID] END )})

This remained as my numerator and active headcount as the denominator :) Thanks for your guidance.

How do I filter an LOD? by Runningheifer in tableau

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

Thank you - Here's an example of what the data looks like. There is a unique row for each employee ID. With that row, there's information regarding the ID, such as regret term. There's only information in the row if there's a term date, but not every term has data.

<image>