Hope I get your question right. One possible solution is to create a dimension, and count the dimension to see the days where "a person checked in, but didn't swipe or didn't check in, but swiped then have by each user."
IF "Checked In" =1 THEN
IF " Swiped"
THEN "Checked In and Swiped"
ELSE "Checked In but not Swiped"
In your actual view, you can count the specific calculated field for monthly view. Since the null would not be counted and the Checked In is the primary data source, you should be able to get the monthly view. Hope it help!
1 of 1 people found this helpful
I realize you probably cannot pass security related data on a public forum so I dummied up some data to mimic your situation. Personally I'm not a fan of Data Blending unless used as a last resort. In the attached example (2018.1 version) workbook, I did a LEFT JOIN on Employee Id between two worksheets (1) Your sample primary for check-in (2) Door Swipes captured throughout a period of time, inclusive of capturing LL333 who did check-in but didn't swipe on two occasions.
Please look at the JOIN in the Data Pane window. I think Data Blending is probably complicating the issue. Tableau is great at passing the data through, but it gets complicated when you're trying to do calculations or LOD's thereafter. Hope this helps? If so, please mark this response as correct. Thx, Don
This helps Don, Thanks.
One question. I'd like to keep it to one record per person per day. Right now its as many of swipe in they have. Is there a filter I could add?
Dude, thanks so much. I appreciate it!
No worries - glad to help!