We have updated WebDataRocks EULA, effective as of April 18, 2024. Learn more about what's changed.

How to expand specific column by default?

Answered

Hi,
instead of doing in this way

'rows': [
{
'tuple':[
'Category.Food'
]
},
{
'tuple':[
'Category.Food'
]
}
]

Is there any solution to expand all sub-category under ‘Category’ by default?
Thank you 🙂

3 answers

WebDataRocks Team WebDataRocks June 7, 2019

Hi Elisa!
Thank you for your question.
 
It’s possible to expand all the hierarchies on the grid by setting the expandAll property to true. Please refer to our documentation to learn more about the structure of an Expands Object of a Slice object
Hope this demo will be helpful for you.
 
 
Best regards,
WebDataRocks Team
 

Elisa June 9, 2019

Thanks for your answer.
However, what I mean was that if I want to expand three columns and left one column to be hidden by default, would that be possible? 

WebDataRocks Team WebDataRocks June 13, 2019

Hello Elisa,
 
In case you want to expandAll except some specific row, you can do this.
Please refer to the updated sample: https://codepen.io/webdatarocks/pen/rEVRQq
Also, you can always experiment by configuring report via UI and then saving JSON using Save button.
 
Hope it helps.
 
Regards,
WebDataRocks Team