Dimensions and measures are the starting point for all exploration. A dimension can be thought of as a group or bucket of data. For example, Project Name, Cost Code, and Employee Name are a few dimensions. Standard Time and Count of Projects are a few measures. Dimensions appear as blue columns, and measures appear as orange columns in Data Explorer.

To add a field:

Multiple dimensions are easier to look at when you pivot one of the dimensions horizontally. Each value in the Dimension will become a column in your Look. Data Explorer supports up to 200 pivoted values.

Data Explorer allows users to sort by one or more fields. Click the arrow next to the field name that shows the sorting order (ascending or descending).

Users can sort by multiple columns by holding down the shift key and then clicking on the column headers in the order that they want them sorted.

NOTE: If you reach a row limit, you will not be able to sort row totals or table calculations.

Users can also set row limits. When selecting a row limit, the Data Explorer will only display up to the number of rows set. It will warn you if you might be hiding data by setting a row limit too low.

NOTE: Your sort order is essential in these situations; Rhumbix Data Explorer first applies the sort and then applies the limit.

Sometimes a summary of a user’s data is valuable. You can add column totals to your report by clicking the Totals checkbox in the upper right and then running the report.

While exploring, you can save your work as a Look or as a Dashboard.

The user’s filters, visualizations, fields, and sorting choices are all saved.

Next: Data Explorer: Saving Work as Looks

You can always find more information on Data Explorer in our Support Center.