I have attached my real data. The problem is the exam start date and exam end date will be in a different row. If you see my data you will be understanding it easily.
I have also attached my tableau work book.
If you see the viz, its working only for the start date. ie the line is showing only for the start date and not extending till the end date. For example, the student number 401-001 has the start date as 2013-06-05 and end date as 2013-06-11. So the line must be starting from 06-05 and needs to extend till 06-11. But in the workbook it shows only in 06-05.
I hope you can understand my requirement.
Data.xlsx 8.9 KB
Thanks for your response. I cannot edit the rows as I will be getting live data, so I can transpose the data while getting them from the live system and load it to the tableau. This will help me solve the issue.
Once again thanks for your help.
I took a look at this and there are at least three solutions that don't involve modifying your data.
In the first solution, I used a duplicate connection to the data to create a Tableau self-data blend that is only on the Student as a linking dimension, so that way for each student we can get the Exam Start Date as a dimension from the primary and the MAX(End Date) for the student from the secondary.
In the second solution, I used a Custom SQL connection to do a self-join on student, so instead of the student data being spread across two rows in the original data it's now spread across one row in the Tableau data source.
There's a third solution involving table calculations that would get overly complicated, it's unecessary here.
Workbook is attached.
start and end dates.twbx 23.0 KB
Thanks for your reply. This is what I was looking for. I will try this and will let you know if I have any questions.