Hello,
How can I show in tableau the count of students who failed more than once in last four months and also show the count of students who failed consecutively more than once in last four months? So this is the dummy data set, the original data set has thousands of records and include last 4-5 years data .
Currently I get the count but only when I place student in the row shelf which gives me those students but when I remove that it shows me nothing.
Hi @Shivam Garg
Thanks a lot for the appreciation and wonderful suggestion and above all
"The Challenge" to create the visual without any Data Operation. As they say
"When the going gets tough, the tough go to lunch" (Yogi Bear). Here is a really
cool solution that I just came up with and it works like a charm.
I have attached the twbx file and let me know if you have any questions.
Once again thanks for the challenge, I knew this could be done when I
started out earlier but chose the other approach ( Data join with Prev
Month) as it simplified calculations and did not need any Table Calculations.
Here are screenshots of the 2 cases you mentioned (to see if it works right)
Case 1
Case 2
In case this correctly answers your problem, please "Upvote" this solution
and "Select as Best" to close this thread. This way others with a similar question
will be able to access this solution. Take care and Best wishes !
Sincerely,
Soumitra
