Have you tried setting an index = 1 and then using table calculations to pull out the max (WINDOW_MAX)? Without seeing how the data is structured it is hard to see how I would pull in the attribute. I believe what I am referencing will give you the first in the list. You may have to create a numeric value for 'Baptism - Stonebridge', where 'Baptism - Stonebridge' then 1 else 0, and do a WINDOW_SUM on it.
Brandon Ohlaug thanks for the response. You note that, "without seeing how the data is structured it is hard to see how I would pull in the attribute". Is there a way that I can provide you this information? I assumed that when I attached the .twbx that it would let you view any necessary info.
And as a point of clarification, when I am use the word "attribute" in my original post I am using it to define an event/character trait in a person.... not as a Tableau function "ATTR".
Hey Ryan! Depending on how you want to visualize the data, this formula will at least allow you to filter the individuals who have one or both:
Step 1: Create a calc field that creates a column with a numeral value when the conditions are met:
max(if [Attribute] = 'Baptism - Stonebridge' and [Number of Records] > 0 then 1 else 0 end)
max(if [Attribute] = 'Profession of Faith' and [Number of Records] > 0 then 1 else 0 end)
Step 2: Filter the Individual ID based on the above calculation = 2 (to find those with both)
Or you can Filter the Individual ID based on the above calculation does not = 2 (to find those missing one). Then only select the attribute you want to see they do have.
I am seeing 15 people who have both attributes. I've created several tabs as experiments to show how you could visualize the data.
Hopefully this helps?
Amber Smart Thank you! The way you visualized this process is great! I never used the "Condition" filter before, so this was a great learning opportunity for me to learn more about that. Thanks again for your heart to serve in this capacity. You are making a difference in many organizations other than your own!
No problem! Happy to help if I can.