Hello, In Tableau CRM I am attempting to determine an attachment rate for a product and when I do, the system only pulls projects that have a value. I need to determine a % of the whole and not just the ones that have a value. For example if there are 100 projects and of the 100, 10 are product A and 20 are product B, I am looking to have 10% of Product A and 20% of Product B.
Thank you in advance.
1 个回答
Hi @Michael Kalousdian, You can achieve it using a compare table. Open the lens in Compare table mode > Group by Product > Add a new column > Add a Formula > Select Percentage of Group. Here is a screen shot for your reference
