Get Free Trial

Column Orders for flat and classic

Answered
Subramanian asked on March 15, 2021

Hello,
As I have to maintain the different column orders for Classic and Flat options. For example,
In the flat option, I have to maintain in this order [str1, str2, num1, num2, str3, date1] so I can add all these column names in slice -> rows.
In classic option, I have to maintain in this order -> rows: [str1, str2, str3], measures: [num1, num2], columns: [date1].
When I switch flat to classic or vice versa should maintain the order. Could you please assist me to achieve this?
Note: All these should be done programatically

2 answers

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster March 15, 2021

Hello,
 
Thank you for reaching out to us.
 
We want to draw your attention to the flatOrder property of the Slice Object. It defines the order of the hierarchies for the flat grid type.
It means you can preserve the structure of the classic form (rows: [str1, str2, str3], measures: [num1, num2], columns: [date1]) in the flat form and define custom order:

slice: {
  rows: [str1, str2, str3],
  columns: [date1],
  measures: [num1, num2],
  flatOrder: [str1, str2, num1, num2, str3, date1]
},
options: {
  grid: {
    type: "classic"/"flat"
  }
}

 
Please let us know if it helps.
Our team is looking forward to hearing from you.
 
Regards,
Illia

Public
Subramanian March 15, 2021

Cool… It is working as expected. Thank You!

Please login or Register to Submit Answer