-
1. Re: Data Transition Excel-->Tableau
Hari Ankem Dec 21, 2017 3:55 PM (in response to Daniel Livsey)Is this what you need?
You can create a calculated field like this to get you the efficiency.
I have attached a 10.2 workbook. Hope this helps.
-
Productivity.twbx 21.0 KB
-
-
2. Re: Data Transition Excel-->Tableau
Norbert MaijoorDec 21, 2017 4:11 PM (in response to Daniel Livsey)
Hi Daniel,
Find my approach as reference below and stored in attached workbook version 10.3 located in the original thread
1. P1. Efficiency: [Productive]/([Productive]+[Non-Productive])
2. P2. Job count: count([Job])
3. P3. Efficiency per Category: {fixed [Category]:avg( [Productive]/([Non-Productive]+[Productive]))}
Regards,
Norbert
-
avg_nalmai_10.3.twbx 20.2 KB
-
-
3. Re: Data Transition Excel-->Tableau
Daniel Livsey Dec 28, 2017 9:04 AM (in response to Hari Ankem)thank you muchly for your help! Used this and it worked great!
-
4. Re: Data Transition Excel-->Tableau
Daniel Livsey Dec 28, 2017 9:06 AM (in response to Norbert Maijoor)Thanks Norbert, this helped a lot. One comment though, on the efficiency by category, your equation was taking an average of the data points, instead of summing the sub-data and totaling.
I combined your other 2 equations with the addition of sum() from Hari above and everything is working out.
Thanks to you both!
-
5. Re: Data Transition Excel-->Tableau
Hari Ankem Dec 28, 2017 10:28 AM (in response to Daniel Livsey)You are welcome.