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
⋅ 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
⋅ March 15, 2021
Cool... It is working as expected. Thank You!