Enable hierarchy for columns

Resolved
Accobat Development asked on November 22, 2023

Hello,
 
We have a feature request regarding hierarchy for columns.
 
Currently, rows support multi-level hierarchies. There are some downsides to this but in general it fits our purposes.
 
However, there is no similar solution to columns. Sometimes this leads to our customers encountering very frustrating scenarios where child-columns are "cross-populated" across parents.
 
In a specific case we had a customer planning across the latter half of 2023 and the first half of 2024. I don't have a JSFiddle ready so I will just explain it:
 

2023
 
 
 
 
 
 
2024
 
 
 
 
 

6
7
8
9
10
11
12
1
2
3
4
5
6

Consider the schema above. This is what the user enters as column data.
 
And this is the FlexMonster output
 

2023
 
 
 
 
 
 
 
 
 
 
 
2024
 
 
 
 
 
 
 
 
 
 
 

1
2
3
4
5
6
7
8
9
10
11
12
1
2
3
4
5
6
7
8
9
10
11
12

 
Essentially the hierarchy is completely ignored and the colums cross-populate.
 
This is problematic in a large number of use-cases. There are workarounds such as specifying "0" values instead of null for all data points and then hiding all empty values (as the generated dimensions will have no data). Still, it is not ideal. It leads to a relatively large degree of frustration with customers who do not understand why their data is not being "respected".
 
We kindly request a feature to enforce hierarchy on columns or "disabling" this cross-population as it has a very high negative impact on the customer experience.
 
Best regards,
Jonas

3 answers

Public
Nadia Khodakivska Nadia Khodakivska Flexmonster November 23, 2023

Hello Jonas,

Thank you for reaching out to us.

Kindly note that the Flexmonster hierarchy has the same behavior in both rows and columns. Please check the following JSFiddle: https://jsfiddle.net/flexmonster/d3mkhsty/. There is no cross-population in the hierarchy in the columns section. If we didn't understand you correctly, please modify the JSFiddle above to show us the issue. It would greatly help us.

Looking forward to hearing from you.

Kind regards,
Nadia

Public
Accobat Development November 24, 2023

Hello Nadia,
 
Thank you for the reply. The part of our code base handling hierarchies is very old so I will take a look at it - from your JSFiddle it seems like the exact case we have is actually supported.
 
I apologize for the error on our part and thank you for the (always) expedient and professional help 🙂
 
Best regards,
Jonas

Public
Nadia Khodakivska Nadia Khodakivska Flexmonster November 24, 2023

Hello Jonas,

Thank you for the feedback.

You are welcome to write to us in case other questions arise.

Kind regards,
Nadia

Please login or Register to Submit Answer