I had a look through your workbook, the issue seems to be that you don't have Appointment_LPTID_1 on the Detail shelf for the Chart sheet.
Not having this means is causing issues with the table calc's that you have set up.
The entries that are getting bundled seem to be Appointment_SERVICEID 6 and 12704, these both have an Appointment_LPTID_1 value of 6.
Let me know if this solves the issue for you...
Also, kudos for doing such cool stuff with Tableau after only a few months!
Thank you v much. That's done the trick. Although I don't really understand why! Showing my lack of experience.
SERVICEID is a greater level of detail than LPTID so how can Tableau bundle 2 different SERVICEIDs together? In my Crosstab sheet it seemingly makes no difference whether I have [Appointment_LPTID_1] on the Rows shelf or not because [Appointment_SERVICEID] is also there. So why does it make the difference in the Chart?
If you have time to help me understand that, it would be greatly appreciated.
1 of 1 people found this helpful
Glad I could help
The issue arose due to the way you have the Index() function set up. If you edit the Index table calc, and under Compute Using select "Advanced" you can see that the original set up was like this:
Specifically, that you were partitioning the data on 'Day of Appt' and Indexing each 'Appointment_SERVICEID'.
If you create a view with Day of Appt and then Appointment_SERVICEID on the Rows shelf, and add the Index function to the Text shelf, you can see more clearly what's happening.
For your graph, the issue was that there were two Appointment_SERVICEIDs on 2009-10-07:
By adding Appointment_LPTID_1 to the detail shelf, the Index function is automatically updated to partition on it. So that there is only one entry for each occurrence (which is what you want because you are after a basic count).
Let me know if you're still having trouble with it and I build a quick workbook out and send it on.
Thanks v much. That makes sense after following it through. So much to remember!