Problem - Tree map size value per area

[Iain]

Hello, looking to find out what i am doing wrong here

i am trying to make the size of tree map values dependent on a count of number of reworks, but this value isn't split up per area and instead is the same value across all the areas

this is my current code to gain number of defects for area, but when putting this into the tree map per location it does not record individual sizes

looking to see how i could resolve this, i have tried with "OVER [Dept Area]" but no use

thanks in advance :)

[Olivier Keugue Tadaa]

Hi @Iain

What does your data structure look like?  That will help answer your question.

[Iain]

Hi @Olivier Keugue Tadaa

I have individual parts that go through processes which has a location column, i also have another column that has a process id which is the [Vornr] above, this is classified with 4 numbers, if the number end in anything other than 0 then it is a rework through that process.

therefore above i am getting a count for number of reworks but unable to get the tree map to size by count of reworks per area

hope this help

[barchiel33]

Hello @Iain,

The real issue is your equation, what you have is:

Max(Case When Right([VORNR], 1) <> "0" Then Count([VORNR]) End) 

This is actually a double aggregation expression, so it first takes the Count of VORNR over the relevant rows and then it finds that Max of that expression. Since it's finding the Max of the expression (rather than a value), it's being performed over the entire column. Try this expression instead:

Count(If(Right([VORNR], 1) <> "0", [VORNR]))

Edited November 13 by barchiel33