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

Table Calculation Help Needed for a Newbie

jasonmischel0 Dec 30, 2011 12:11 PM

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

Shawn Wallwork Jan 4, 2012 3:35 PM (in response to jasonmischel0)

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
Like Show 0 Likes(0)

Actions
2. Re: Table Calculation Help Needed for a Newbie

jasonmischel0 Jan 5, 2012 11:50 AM (in response to jasonmischel0)
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

length_of_service_-_light_version.twbx 30.7 KB
Like Show 0 Likes(0)

Actions
3. Re: Table Calculation Help Needed for a Newbie

Shawn Wallwork Jan 6, 2012 6:31 AM (in response to jasonmischel0)

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
Like Show 0 Likes(0)

Actions
4. Re: Table Calculation Help Needed for a Newbie

Richard Leeke Jan 7, 2012 8:52 PM (in response to jasonmischel0)

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.
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community Forums

Table Calculation Help Needed for a Newbie

1. Re: Table Calculation Help Needed for a Newbie

2. Re: Table Calculation Help Needed for a Newbie

3. Re: Table Calculation Help Needed for a Newbie

4. Re: Table Calculation Help Needed for a Newbie

Actions

More Like This