Column Sort

<< Click to Display Table of Contents >>

Current:  Create Data Set > SQL Data Set > Data Governance 

Column Sort

Previous pageReturn to chapter overviewNext page

In metapane of SQL Data Set, Excel Data Set, Mongo Data Set, Data Mart Data Set, Embedded Data Set, Custom Data Set ,add  Sort properties:

sortcolumn1

 

[Data Source Sorting] List dimensions and measures in the order they are listed in the basic data source. The newly added expressions will be ranked last in the order of creation.

[Alphabetically Sorting] In the data set, dimensions and measures are listed in alphabetical order according to their field names; in the report, dimensions and measures are listed in alphabetical order according to their field aliases.

sortcolumn2

 

The order of the columns in the Data Details is as follows:

sortcolumn3

 

Switch to Alphabetically Sorting, the order of metadata columns is as follows:

sortcolumn4

The order of the columns in the Data Details is as follows:

sortcolumn5