6 Replies Latest reply on Jul 31, 2018 2:16 AM by Gowri Shanmugam

# Percent of dimension value to its total

Hi,

I need to set up status dashboards and show percentage of tasks 'completed' as a summary.

I have the data as below:-

A         Completed

B         Yet to start

C         Completed

D         In progress

Now I need to get the percentage of 'Completed' as 50% (Tasks A and C over total)

How is this achievable in Tableau??

Thanks!

• ###### 1. Re: Percent of dimension value to its total

Hi Gown,

Group A& C using grouping option in Tableau - Check this link how to group your data

Step 1: Drag Status to Rows now you can see completed, Yet to start and In Progress

Step 2: Create a calculated field like below

sum(measure value)/total(sum(measure value))

now you can see status wise % compared total value

BR,

NB

• ###### 2. Re: Percent of dimension value to its total

Hi Naveen,

My dimension values are string based such as A, B, C , D

The formula provided is for measures.

How do we count/ perform percentages for dimensions?

• ###### 3. Re: Percent of dimension value to its total

Hi Gowri,

I didn't understand the question perfectly

> Do you want to see what is the proportion of status A in whole data set ?

If that the case use the NUMBER OF RECORDS in the place of measure values in above formula

If not could you please attach sample screenshot how you need the Ouput

BR,

NB

• ###### 4. Re: Percent of dimension value to its total

Gowri,

You can create a calculated measure as:

• ###### 5. Re: Percent of dimension value to its total

Hi Gowri,

I created sample Data Set as below

Step 1: Group the Task A and B

Step 2 : drag Number of records to Text and select the % of Total

Step 3: You can find the 50% for completed

this is  one way achieving the result

Hope this helps kindly mark this answer as helpful and correct so that it will help others

BR,

NB

• ###### 6. Re: Percent of dimension value to its total

Thanks!