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
957 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
• 33,030 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 9, 2018 in Tableau by ffdfd
• 5,550 points
4,765 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
9,832 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
3,069 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
732 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
• 33,030 points
4,315 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
• 33,030 points
21,132 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
• 33,030 points
15,812 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
• 33,030 points
11,626 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
• 33,030 points
907 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
• 33,030 points
758 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP