1 2 Previous Next 18 Replies Latest reply on Jun 28, 2017 11:39 PM by Saket Metkari

# Parameter Calculations

Hi Team,

I have Excel file where I have names of all employees and their start dates and end dates in this format.

How to prepare 2 parameters in tableau-

Start Date

End Date

So that I can filter by starting date of employee and ending date of employee.

I have attached sample tableau workbook.

Here if you see, 1 is used if the employee is active and 0 is used if the employee have left the organization.

Help is much appreciated !

Thanks a lot !

SAKET

• ###### 1. Re: Parameter Calculations

Team,

Please find attached Excel for reference.

Thanks !

SAKET

• ###### 2. Re: Parameter Calculations

Hi Saket,

I believe you are looking for this ?

If you see from date range, only two records lies in between your given range.

• ###### 3. Re: Parameter Calculations

Hi Sandip,

Thanks for the instant reply.

Yes sort of, I am looking for this. (I have flag Column - Active and Inactive)

I need, for instance - All the name of Employees working from Sep 2016 to Mar 2017,

But using Start Date and End Date field.

Can you please share sample tableau workbook for this.

Thanks,

SAKET

• ###### 4. Re: Parameter Calculations

Hi Team,

Can you please let me know the soluon for the problem !

It would help a lot.

Thanks !

SAKET

• ###### 5. Re: Parameter Calculations

Hi Saket,

Please find attached HC workbook developed in 10.3

1 of 1 people found this helpful
• ###### 6. Re: Parameter Calculations

Hello Saket,

Please refer the below snapshot. If this is what you are looking at please refer the attached updated workbook.

AK

• ###### 7. Re: Parameter Calculations

Hi Akhilesh,

Thanks a lot for your help !

The only problem is now I am getting wrong Head-Count, the total count is 158, but I am getting in thousands.

Thanks !

SAKET

• ###### 8. Re: Parameter Calculations

Hello Saket,

I am not able to get which headcount you are talking about.

1) Active

2) Inactive

3) Active + Inactive.

Ak

• ###### 9. Re: Parameter Calculations

Hi Akhilesh,

Both active + inactive.

Total of head Count, if you go the measure (Head-Count), I am not getting it accurately, that is the problem.

Thanks for your help !

Thanks !

SAKET

• ###### 10. Re: Parameter Calculations

Hello Saket,

As i am looking on your data. There are 2212 rows, which is equals to total headcount.

Please correct if still my understanding is not what you are saying.

Ak

• ###### 11. Re: Parameter Calculations

Hi Akhilesh,

That's the problem, the records have been repeated number of times.

in my excel I have 159 rows only, but when I created Start Date and End Date like you mentioned in above comments, the record got repeated number of times.

That is what I am not able to figure out how.

If I use COUNTD then it will show me 125 records, but my records in my excel file are 159

Here I need your help to show accurate count, if you need anymore inputs from me please let me know.

Thanks !

SAKET

• ###### 12. Re: Parameter Calculations

Please share that excel file.

• ###### 13. Re: Parameter Calculations

Akhilesh,

Please find attached Excel.

I cannot share the Actual file as it is confidential, please find a demo one.

I request you to please help in doing the changes in attached tableau workbook.

After completing the logic of Start Date and End Date, my count gets wrong.

Thanks !

SAKET

• ###### 14. Re: Parameter Calculations

One update, if this is just about duplicate. You can replace your Aggregate measure with CountD(Full Name).

1 2 Previous Next