How to calculate work done for a given date or period of time?

0 votes
Hi, i have data regarding project stages, work completed , milestones, number of hours, for different projects over departments.

How to calculate work done for a given date or period of time?
Apr 1 in Tableau by banu
10 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
0 votes
Hi,

Follow these steps:

As per you question since you have work completed and milestones for every stage.

1. Convert the work completed into %.

2. Then calculate the work completed in row wise.

3. Add a new column to show the completed % from sum of all the other stages values.

4. The new column contains the % of total across row.

Hope this helps you.
answered Apr 1 by CHERUKURI
• 13,940 points

Related Questions In Tableau

0 votes
1 answer

How to calculate the percent of records within a group in tableau?

 You can click the measure SUM(Number of Records) and ...READ MORE

answered May 8, 2018 in Tableau by Atul
• 5,470 points
67 views
0 votes
1 answer

How to color code cells of a column based on the text value in Tableau

You can use the following steps to ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,200 points
948 views
0 votes
1 answer

how to get the count of non zero values in a row

In first part you should solve the ...READ MORE

answered Apr 4, 2018 in Tableau by Atul
• 10,200 points
77 views
0 votes
1 answer

How to change months for a calendar year

Hey, you can try this & Change ...READ MORE

answered Apr 20, 2018 in Tableau by QueenBee
• 1,810 points
12 views
0 votes
1 answer

Rank measure values and show percentage of measures in Tableau

Hi Sindhu, 1. First create a table with ...READ MORE

answered Mar 8 in Tableau by CHERUKURI
• 13,940 points
43 views
0 votes
1 answer

Tableau- Pie Chart with Multiple Measure Values

Hi Nithin, Pie chart is used to show ...READ MORE

answered Mar 11 in Tableau by CHERUKURI
• 13,940 points
116 views
0 votes
1 answer

Display Percentage in a Row in Tableau

Hi Sindhu, You can follow below steps: 1. Create ...READ MORE

answered Mar 13 in Tableau by CHERUKURI
• 13,940 points
11 views
0 votes
1 answer

How to show percentages on the slices in pie chart in Tableau?

Hi sindhu, You can manually move the labels ...READ MORE

answered Mar 13 in Tableau by CHERUKURI
• 13,940 points
125 views
0 votes
1 answer

How to show outliers for a given set of points.

Hi Anshuli, Follow below steps: 1. Create a line ...READ MORE

answered Apr 17 in Tableau by CHERUKURI
• 13,940 points
32 views
0 votes
1 answer

How to find first n months profit/sales for a given year

Hi Sindhu, You can use Calculated field to ...READ MORE

answered Mar 8 in Tableau by CHERUKURI
• 13,940 points
11 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.