4 Replies Latest reply on Jan 7, 2012 8:52 PM by Richard Leeke

# Table Calculation Help Needed for a Newbie

I am relatively new to Tableau and could use some help with a table calculation issue.

Here is the scenario I am trying to solve:

For each successive Monday, starting with an arbitrary date defined by a parameter, I'd like to count how many employees I have that have been employed less than 60 days.  To make such a calculation, I need to count every record for each Monday that is true for these criteria:

Parameter - [startdate] >0 and <60

[termdate] > Parameter

So, for example, if my parameter was 12/5/2011, then I would want this count for 12/5, 12/12, 12/19, 12/26, etc.

Is this achievable with a table calculation?

Thanks for any help provided,

Jason

• ###### 1. Re: Table Calculation Help Needed for a Newbie

Hi Jason, I thought I saw this question got answered, but now the forum is showing zero responses. Did you get an answer? Or did you figure it out? If not, post a sample workbook of what you've go so far and I'm sure you'll get an answer -- the problem doesn't sound that difficult (but then what do I know). --Shawn

• ###### 2. Re: Table Calculation Help Needed for a Newbie

Shawn,

Thanks for the response.  I have not received a response yet.  I have attached a copy of the data and you can see that I am able to make the calculation that I want for any given date in time without using a table calculation.  However, what I want to do is make this calculation for every Monday starting with a given date.  Hopefully that can be accomplished with a table calculation.

Thanks,

Jason

• ###### 3. Re: Table Calculation Help Needed for a Newbie

Jason, I worked on this several hours last night and couldn't come up with anything workable. Sorry it's beyond my skill level. Maybe Joe or Richard will jump in. --Shawn

• ###### 4. Re: Table Calculation Help Needed for a Newbie

The way I would tackle this would be to modify the data source and add a table listing the dates of the Mondays - and define a cross product between that and your existing table.  The answer will fall out easily then.

I don't think you can do it just with table calculations off your existing data source - though as always, I'll be happy for Joe to prove me wrong.