You'd need Quick Table Calculations, "Percent of Total" in particular. Refer to this document for reference. Attached the workbook.
I created dummy data in Excel and loaded into Tableau,
Click on "Number of Records" in Marks Card > Quick Table Calculation > Percent of Total > Click again on Number of Records > Edit Table Calculation > On the pop-up window > Select Specific Dimensions > De-Select Division and close the window.
This is how it should look,
Hope this helps.
Rebecca_v10.2.twbx 10.7 KB
thanks for your reply.
Here i have under the blue mark (call it Div A) 7 none files and 2 yes files.
I follow your steps for the table calc but it returns 100%
More than 7 days is the same as your response field in your example
. Also if i take the date out, tableau automatically counts the figures above rather than the number of rows? It gives me the overaall % when i need it at a row level right, as i know the first option is 77%
Could you try this?
Create a calculated field, say "% of total", type this
THEN 1 ELSE 0 END)
change the number format to percentage. See if this works.
Also refer to this article for further reading on types of calculations.
I've attached a workbook which may help you. Please use this LOD calculation I have here:
This will fix the general total number of records per division, and look at the total number of records for each type of response.
Please place this field into text on your marks card:
This will give you the row level % I think you're looking for. You can also remove that date field from the rows shelf and it'll give you correct result:
Please let me know if this works for you.
Sorry attached the workbook here! The first worksheet Row Level % gives you the LOD calculation which I mentioned in my previous response.
The second worksheet Number of Records % uses the same table calculation method as Shivaram.
If you have any questions, let me know!
% of Total.twbx 87.6 KB