I have a data set about student enrollment. It includes several enrollment statuses such as Returned and Graduated. These fields have values of zero and one. Each student should have exactly one status with a value of 1, while the rest should be zero. I would like to validate this by making Tableau Desktop total the students' values and see if each student's total is one or not.
The problem is that Tableau Desktop won't let me use Row Totals. Can you explain why, and how would you recommend performing the validation? A workbook with sample data is attached.
Hi, measure names and measure values is not a dimension of your data. It is an artificial/built in dimension not in your data, but in the worksheet metadata. Totals work only with dimensions/calculated dimensions in your data set.
On the other hand, I would modify your calc to handle null values (1+null = null) (1+zn(null)=1+0=1)
{ FIXED [Student ID] : SUM(
ZN([Grad Not Returned])
+ ZN([Grad Returned])
+ ZN([Grad Transfer])
+ ZN([Graduated])
+ ZN([Not Returned])
+ ZN([Returned])
+ ZN([Transfer])
) }
If this post resolves the question, would you be so kind to "Accept this Answer"?. This will help other users find the same answer/resolution and help community keep track of answered questions. Thank you.
Regards,
Diego Martinez
Tableau Visionary and Tableau Ambassador
