Spotfire Tree Map graph, hierarchy not displaying correct info

[Iain]

Hi all,

 

currently got a tree map to display booked hour data based on each area. 

i am using a custom expression within the hierarchy section to display the area name and also the Sum of hours within that section. 

the size of each entry within the tree map is also dependent on the sum of hours within each area.

even though both hierarchy and size sections are both running the same custom expression "sum([Hours])", the size displays the hours within the section but the hierarchy custom expression displays hours of all the areas combined.

how would i go about formatting this expression to also provide the name of the area and the associated sum of hours within that area?

 

pic below of current hierarchy custom expression which is giving the result of name of area and all the areas hours combined

[David Boot-Olazabal]

Hi Iain,

You may want to try something like this:
<[Gate Desc] NEST Sum([Hours]) OVER ([Gate Desc])>

That would nest your sum([Hours]) withing the hierarchy and calculates it per [Gate Desc].

Kind regards,

David