-
1. Re: Donut chart not showing up correctly
Ken Flerlage Jan 3, 2019 6:13 PM (in response to Ajinkya Sirsikar)Can you share a packaged workbook?
-
2. Re: Donut chart not showing up correctly
Rodrigo Calloni Jan 3, 2019 7:22 PM (in response to Ajinkya Sirsikar)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.
Rodrigo -
3. Re: Donut chart not showing up correctly
seraj alam Jan 3, 2019 7:50 PM (in response to Ajinkya Sirsikar)can you please attach sample workbook. it would be easy to help you
-
4. Re: Donut chart not showing up correctly
Ajinkya Sirsikar Jan 4, 2019 10:24 AM (in response to Ajinkya Sirsikar)Hello Guys,
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.
Thanks,
Ajinkya-
Feb month crosstab view.png 142.6 KB
-
Jan Month crosstab view.png 120.1 KB
-
-
5. Re: Donut chart not showing up correctly
Simon RuncJan 4, 2019 11:17 AM (in response to Ajinkya Sirsikar)
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
-
6. Re: Donut chart not showing up correctly
Ajinkya Sirsikar Jan 4, 2019 11:28 AM (in response to Simon Runc)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.
Thanks,
Ajinkya -
7. Re: Donut chart not showing up correctly
Simon RuncJan 4, 2019 11:53 AM (in response to Ajinkya Sirsikar)
Yes I did it in 2018.3 ...here you go in 10.4
-
Trellis Chart using Rank_v10.4.twbx 1,013.8 KB
-
-
8. Re: Donut chart not showing up correctly
Ajinkya Sirsikar Jan 16, 2019 3:48 PM (in response to Ajinkya Sirsikar)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
-
-
9. Re: Donut chart not showing up correctly
Simon RuncJan 17, 2019 8:14 AM (in response to Ajinkya Sirsikar)
1 of 1 people found this helpfulhi Ajinkya,
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
https://www.kevinflerlage.com/2019/01/small-multiples-just-matter-of-long.html?m=1
-
10. Re: Donut chart not showing up correctly
Ajinkya Sirsikar Jan 17, 2019 3:23 PM (in response to Simon Runc)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.
Cheers,
Ajinkya