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, 2019 in Tableau by banu
54 views

1 answer to this question.

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, 2019 by Cherukuri
• 32,460 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,530 points
683 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,240 points
3,697 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,240 points
560 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,820 points
44 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, 2019 in Tableau by Cherukuri
• 32,460 points
979 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, 2019 in Tableau by Cherukuri
• 32,460 points
1,751 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, 2019 in Tableau by Cherukuri
• 32,460 points
438 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, 2019 in Tableau by Cherukuri
• 32,460 points
2,904 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, 2019 in Tableau by Cherukuri
• 32,460 points
87 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, 2019 in Tableau by Cherukuri
• 32,460 points
57 views