Can you share a packaged workbook?
I wonder why you are using MIN(Number of Records) to create the axis. Maybe you can try using MIN(1) or AVG(0).
But as Ken pointed, it will help us if you can share the twbx.
can you please attach sample workbook. it would be easy to help you
Thanks so much for reaching out.
I talked to my stakeholders and it seems they want to view just the current month and not the future months, which solves the issue.
The data is showing up correctly as mentioned earlier for the current months, but few future months show the donut slices in wrong places.
For your reference i checked the data in the crosstab as suggested by Simon Runc and i did notice that for few cost centers the columns and rows are getting messed up.
You can refer to the screenshots about the issues that i mentioned above. But for now since i removed the month filter it seems to have solved the problem.
Since my workbook contains confidential data i am unable to share it. However i will appreciate if anyone of you has an idea how to troubleshoot the issue that i came across in the crosstab data.
Glad the problem resolved itself!
For completeness here is one way to deal with Small Multiples/Trellis charts when there are different numbers of elements within each multiple.
The problem comes from using index() which is counting things. Instead we use RANK_DENSE (as a separate field ...so we can run it independently over State) so (in my example) the RANK_DENSE of state remains the same for every mark, for that state.
Let me know if anything doesn't make sense
Hi Simon Runc thanks for the reply. But i am unable to open the workbook you sent. Its giving me an error.
I would appreciate it if you can revise the workbook version to 10.4 because I believe it might be issue related to my Tableau version.
Hello guys coming back to the original problem i had on this thread.
I have tried several ways to trouble shoot the error on the donut slices. But still the names are not showing up correctly on a particular category (in this case Under Allocated/over allocated).
Can anyone please let me know what calculation mistake i am doing when creating the donuts?
I have added the Category and Cost center TLT hierarchy in the tooltips so that it would be easy to identify the mismatch of names on the slices.
Please help since on my original dashboard the January month is showing up correct slices but the future months are getting messed up.
Book1.twbx 3.9 MB
1 of 1 people found this helpful
It doesn't look like you'd changed the Small-Multiple/Trellis chart Row and Column calculations to the ones using RANK, as per my example!
Here you go.
Kevin Flerlage has also just done a great blog on Small Multiples ...definitely worth a read
Hey Simon Runc,
Awesome, thanks so much!. I did try your small multiples method on the previous dashboard but that didnt work. I re-created the entire dashboard (which was quick since this time i knew what i was doing ) i was able to get the donut slices correctly.
Now for any month in the filter the slices are showing up correctly.
I really appreciate your help and thanks once again for your valuable tips.