Thank yoiu so much for the help. In all honesty I am a total newbie at Tableau (taking a class for my masters) and I am not super sure about the calculated fields you created and how you came up with them to be able to get these results to display. So I will break those down first but the other question I have is how would you suggest I go about visualizing this as opposed to just another Spreadsheet view? Is that something that is possible with this data set? This "spreadsheet" does show what I want but I need to make it pretty you know what I mean? Also Just so I know that I am munderstnding the way the info is displayed in the Count Accepted Diet column those numbers break down as such male number of participants number of female participants adn the total number of participants? Thanks again and sorry for all the follow up questions I just want to make sure I am absorbing the information you provided.
No worries about being a newbie with Tableau! We were all there at one point or another. Here are a couple of examples, just duplicate the table of data and then use 'Show Me' in the upper right-hand corner to see what Tableau recommends based on the available data. Drag 'Gender' to color and click color to edit color for either Male or Female.
To answer your 2nd question, yes, it is break down within Accepted Diet Name, how many males vs females accepted the diet, with a subtotal for that particular group, overall percentage is for all 106 participants.
The only calculation I provided you is a sum total of all the percentage values already provided. Not sure about the underlying data collection methods and results? If you were to turn each of those numbers into an actual percentage and not a decimal you'll see percentages greater than 100%.
A person wouldn't lose over 100% of their body weight but some of those values added up would indicate that. So maybe go back to the provider of the data to better understand what those values mean? Then total as appropriate. I provided you the calc as an example of how to get there. To see the calculation, simply right click on the pill Total Loss and click edit. It may be that the 28-day value is the final value and the other values shouldn't be summed - but only you'll know your data better than me .
What I did get out of it is something like the following: 17% of all respondents accepted the Slow-Carb Diet, which was the highest acceptance rate, and also had the highest weight loss, whereas 3% of respondents using the Flossing Diet actually increased their weight significantly.