Problem with colours in table

Question

I have problems working out how to get the colours of a table to reflect the correct values.

What I would like, is for the colours to reflect the numbers of responses within the subset who answered Yes, within each group, but so far I can only make it reflect the numbers across the whole table, or a percent I cannot recognise.

I have tried using percentages as it allows me to - supposedly - use Table Down, or the Group itself, but these numbers also come out as something other than what I want.

TWBX attached. The dashboard in the twbx has an overview of the data and the problem with a specific example.

I think the problem might lie in that colour is based on the whole group, and not on the relevant subset, but I'm not sure, nor sure how to test this theory.

Any ideas?

Naveen Reddy · Accepted Answer

RANK(COUNT([Ark1]),'desc') --> you can use rank to assign 1,2,3,4 and keep it in the color    Hope this helps :   If you like the answers, Please mark the answer as "BEST" Answer / UPVOTE BR, NB

Hideaki Shiihara · Answer

Hi,@Lise Kok Petersen Are you looking for something like the attached? Please check. There are six 0s in the column dimension, and two of each are used for the dual axis. This makes it possible to control the color for each dual axis. Areas that do not correspond to a group are entered with a large negative value such as -99 to clearly show the two colors blue and white, and NULL is changed to white. if attr([ResponseGroup])='Group1' then COUNT([Ark1]) else -99 end *If you get the best results from this exchange, I would appreciate it if you could choose the best answer or upvote.

Problem with colours in table

Tableau Desktop & Web Authoring

Aprendizaje relacionado

Más ayuda