Caption and container folder for dimension
Do we have any way to define caption or title for the column that import from CSV file? For example, I have: SaleQty, TotalAmount column in CSV file and after importing I want to display it like: Sales Qty, Total Amount in Drag Dimensions section.
And also can we define the container folder for each column. For example: SaleQty, TotalAmount will belong to Measure folder; City, Country will belong to Area folder in Drag Dimensions section.
Hi Quan Hieu,
Thank you for posting your questions.
Unfortunately, the options you are asking about are unavailable for CSV data source, but they both are available for JSON. Here is a sample that illustrates (1) how captions can be defined and (2) how fields can be grouped in folders: http://jsfiddle.net/flexmonster/aepvpc6e/
More details about JSON data source can be found in the documentation http://www.flexmonster.com/doc/json-data-source/
Please let me know if JSON can work for you.