10 Replies Latest reply on Jan 17, 2019 3:23 PM by Ajinkya Sirsikar

Donut chart not showing up correctly

Ajinkya Sirsikar Jan 3, 2019 2:05 PM

Hi All,

I am working on a Donut Chart, I was successful in creating the Donut charts however the portions in the Donuts are getting mixed up.

I have 12 donuts on my viz and each donut is separated into 4 categories: Fully Allocated(blue), Over Allocated(yellow), Not allocated(red), under allocated(grey).

However when i change the fiscal period, from january to february the donuts get messed up and the name category from one donut shows up in another. When i keep the current month the tooltip shows correct results, but when i change the month it messes up.

Please refer to my screenshots. My first screenshots show the tooltip and the donuts for the month of january and the next ones show the results and tooltips for the month of february.

From the screenshots we can see that the Under allocated from the Network processing department shows up in issuer processing.

Please help. I have been trying to understand the issue but havent been able to find it.

Thanks,
Ajinkya

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?
Like Show 0 Likes(0)

Actions
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
Like Show 0 Likes(0)

Actions
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
Like Show 0 Likes(0)

Actions
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
Like Show 0 Likes(0)

Actions
5. Re: Donut chart not showing up correctly

Simon Runc Jan 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

Trellis Chart using Rank.twbx 1.0 MB
Like Show 0 Likes(0)

Actions
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
Like Show 0 Likes(0)

Actions
7. Re: Donut chart not showing up correctly

Simon Runc Jan 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
Like Show 0 Likes(0)

Actions
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.

Ken Flerlage

Simon Runc

seraj alam

Andy Kriebel

Book1.twbx 3.9 MB
Like Show 0 Likes(0)

Actions
9. Re: Donut chart not showing up correctly

Simon Runc Jan 17, 2019 8:14 AM (in response to Ajinkya Sirsikar)
hi 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

Trellis Chart using Rank_v10.4_SR01.twbx 3.9 MB

1 of 1 people found this helpful
Like Show 1 Likes(1)

Actions
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
Like Show 0 Likes(0)

Actions