your data are badly structure as shown and would benefit from pivoting
see the link Pivot Data from Columns to Rows - Tableau
then you will have Name Date and Status as dimensions and the value in date/name (the 1 and 0 as values and can use the 3 dimensions in calculations (table or not)
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Thanks for the response. But 1 and 0 are the count distinct of the USER_ID and 1 signifies the login to Tableau server and 0 says they have not logged even once to server.
So basically the In active status means - from current month through previous two months they have not even logged to Tableau server once. And if they logged in to server it means Active user.
I will try the pivot option but I would need the report to show something like which I have shown above thanks!~