Adding Dimensions and Measures
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:
Click a field from the field picker to add it to the query.
Click Run to execute the query.
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.
Hover over the dimension in the field picker and click the pivot icon.
Click Run to re-run the query.
To unpivot results, click the field’s gear icon, select the Unpivot option, or click the dimension’s pivot icon again in the field picker.
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.
Saving your work
While exploring, you can save your work as a Look or as a Dashboard.
A Look is a single insight or visual you can create using Data Explorer.
A Dashboard combines one or more Looks/Insights/Tiles.
The user’s filters, visualizations, fields, and sorting choices are all saved.
You can always find more information on Data Explorer in our Support Center.