Click into the search bar at the top of the Data pane under the data sources.Īs you type in the search box, the contents of the Data pane are filtered to show items that contain the typed string.You can search the Data pane for items like fields, folders, or hierarchies. Clear the filter using the X in the search box. Select the Filter by icon next to the search box to show the clickable list of options: dimensions, measures, calculations, or fields with comments. You can filter the Data pane to only show certain types of fields. Lists the dimensions and measures in the order they’re listed in the underlying data source. Lists the dimensions and measures in alphabetical order according to their field aliases. You can sort by one of the following options: These Sort by options are also in the Data pane menu. Whether they're grouped by table or by folder, you can configure how fields are sorted. Or you can right click on a field and select Folder > Add to Folder > then choose the desired folder.įields can only appear in one folder, but you can duplicate (right-click > Duplicate) a field you want to have available in more than one folder.If the folder is expanded, you can drag the field into the general area of the folder. Drag a field on top of the folder name.Add fields to foldersĪfter you create the folder structure, it's time to put fields in the folders. You can start the folder name with a number to force them to appear in a specific order. In the Data pane, select the fields you want to group together and right-click (or right-click an empty area in the Data pane).įolders are sorted alphabetically in the Data pane.Create foldersĪfter you set the Group by option to Folder, you must create your folders. Some options only appear or are grayed out based on other settings (such as Create folder).īefore folders are set up, all fields are listed together with dimensions at the top and measures at the bottom. It's accessible from right-clicking on a field, right-clicking on white space in the Data pane, or using the drop-down menu by the search bar. If the menu doesn't have what you're looking for, try opening the menu from another place. Note: Many of the context menus in the Data pane change depending on how you access them.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |