Forum Discussion

perpor's avatar
perpor
Icon for Helper V rankHelper V
8 years ago

Treemap - help - order with two values is possible?

I do not know if it is possible with the current version to create a treemap with two levels of values:

 

I would like a graph where the most external rectangles are sorted by an index1, and the most internal rectangles with index2.

 

It seems that with the current version, which accepts only one value as 'values', such as index2, the inner rectangles are ordered correctly, while the rectangles outside have an order that I do not understand

 

thank you

Need Help

4 Replies

  • perpor's avatar
    perpor
    Icon for Helper V rankHelper V
    8 years ago

    The two values are indices, values tha can not be summed up, eg. 5.61, 5.45, 5.22, 4.98, etc ... for the index of the most external level,
    similar values for the most internal index.
    The elements of the most internal level are hierarchically dependent on the external layer:

    a11, a12, a13, etc. depend on A1
    b11, b12, b13, etc. depend on B1
    .....

    • perpor's avatar
      perpor
      Icon for Helper V rankHelper V
      8 years ago

      And in the test chart I used the average of that index...

      • perpor's avatar
        perpor
        Icon for Helper V rankHelper V
        8 years ago

        I mean there are currently two datasets, one for the top and one for the level
        lower ones that contain the data, index1 in the first and index2 in the second,
        even if the data type is the same, for index1 and index2, for example as sales,

        values that are indexes anc can not sum up.
        I would like to get this type of graph without having to restructure existing datasets
        creating for example a unique index, which I think would solve the problem ...