We can solve your questions by using calculations at Tableau level.
We can use XL or Database in back end.
What exactly have you tried yourself so far?
@Tom I am stuck ... I am still working on it..
@Tableau Kumar Could you please attach a Sample worksheet with the solution.. :-)
Note: The Chart / Table should dynamic in nature as the data will keep changing.
And all that information should be accommodated in single chart (Stagged for Hire,Termed and Attrition % on secondary axis as Line)
Syed -- Usually the burden for supplying a sample worksheet is on the guy asking the question.
Package up a sample workbook with some data in excel and you're way more likely to get people to work with you. Package what you have so far.
Syed Ahmed wrote:
@Joe I am sorry for that I thought the data which I posted in orignal post will do.. (My mistake).
I hope the attached file will do... :-) Thanks!!
You still haven't actually shown any attempt to solve the problem yourself though.
Personally I'd prefer to help if you could articulate what the specific problems are you're having versus just doing the work to give you the end result.
I am new to Tableau and just trying to learn and explore it .. I am not a person who simply pass things .. I have tried it a lot with the knowledge which I gained with the Tutorials and have searched WEB but wasn't able to make and I realized that this is real challenge as we need to take a Help of SQL Query or do a Outer Join...
I do not want to go with the SQL stuff and Data blending doesn't allow me to do Outer Join... Now if you want to try .. You can give it a try.. Thank you!!!
Let me start you off with this.
I have created two sheets. The first just displays raw data.
The second displays the count of hires by time period. By default it shows by-year, but the user can expand that with basic tableau functionality to months.
You can do the same for terminations. Were you able to do that already?
Yes Joe, That I am able to do .. But the problem is arising when we wanted to show the Total Hire and Total Termed in a Year in a Single chart..
Suppose I wanted to show Hire Vs Term in a particular year we are getting incorrect count
Please reffer to the attached sheet I want to show Active Sheet Numbers and Inactive Sheet Numbers in One single graph... The the values in the respective Years
Lets take 2008, In that Year we have hired 8 resources and Terminated 8 resources and it should reflect that way along with the Total number of Associates presently active in the system..
I really appreciate your time on this..
1 of 1 people found this helpful
I showed you how to use some calcs. How to get those numbers with those calcs. Now you can take it the rest of thwe way and make it look the way you want it.
This is all basic stuff.
Thanks Joe.. I really appreciate your time and assistance .. :-)
I will work on it and once gets the end result will post result.. :-) Have a wonderful day ahead!!