Hi ALL ,
I have a scenario , where the users want to see something like below : - which is just a trend against how much percentage of customers are new in domestic and how much percentage of customers are new in international
I got. a below view in tableau , what I did is to pull both the dimensions i.e (domestic/intl and new/existing) in my rows and see the sum (transactions) ( sum using "Percent of total ") pane " down "
and got a line chart as below :
Where as my actual requirement is to have only "NEW" customers shown in the above chart , in order to obtain that if I put a filter on "NEW Existing" column then I get a chart which looks like what is there in attachment .
Which as you can see is wrong , as it is showing 100% for new customers , which I understand why , as am using "Percentile of total " as "table down" , when I exclude "Existing " and "missing" , it is considering all are new customers .
But how do I deal with this situation ?
Is there a way to hide / not show the existing and missing , but show only new customers , without effecting the calculation .
I know we can hide existing and missing values in desktop , but I cant see that feature in web server . is there any other workaround ?
Since your % is from a table calculation, what I will suggest is to provide a sample workbook with some mock up data, but reflect your issue so that people could look into it and provide a solution