Skip to main content
Topics#Tableau Desktop & Web AuthoringTableau Community Forums Member (Inactive)'s Question
Tableau Community Forums Member (Inactive) (Salesforce) asked in #Tableau Desktop & Web Authoring
Nov 15, 2022, 4:15 PM

Nested Pie chart

Hi,

 

I have 5 measures

 

Count of Total Mac Outlook user 

Count of Authentication Prompt users

Count of A1 users

Count of B1 users

Count of C1 users

 

Where

Percent of Auth Prompt users = Count Auth Prompt user/ Count Total mac outlook user

Percent of A1 users = Count A1 users / Count Auth Prompt user

Percent of B1 users = Count B1 users / Count Auth Prompt user

Percent of C1 users = Count C1 users / Count Auth Prompt user

 

How can I show this in Pie chart which shows how many users out of total got the Auth Prompt and Out of Total getting Auth Prompt these many got on A1,B1,C1

 

THanks

1 answer
  1. Jim Dehner - Tableau Visionary HoF (Market Analytics LLC)
    Nov 15, 2022, 4:19 PM

    I would start by pivoting the data for the A,B and C users - on t then calculate the percents from there (also if A+B+C counts is equal to the total you don't need to calculate the percent - Tableau will do do that as you create the pie

    Thanks

    Jim - Tableau Visionary

Write an answer...
0/9000