I have several questions from my usage of the grid component with a JSON data source :
- Is it possible to define nested “dimensions“, so that fields can be grouped in “folders” and “subfolders” ?
- Fields with exact same captions but in different dimensions are not differentiated when selected as lines/columns. Any way to have the dimension specified as “Dimension / Field” without modifying the field caption? (similarly to hierarchy being a prefix when a field is selected? i.e. “Hierarchy / Field”)
- Is it possible to combine dimension and hierarchy? i.e. Having fields defined as hierarchy and grouped inside a dimension with other fields? I tried to configure such report, to no avail: http://jsfiddle.net/7e1Lvcf4/
Thanks for your answers.