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.

Adding_Dimensions_and_Measures.png

To add a field:

  1. Click a field from the field picker to add it to the query.

  2. Click Run to execute the query.

Pivoting dimensions

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.

Pivoting_Dimensions.png
  1. Hover over the dimension in the field picker and click the pivot icon.

  2. Click Run to re-run the query.

  3. 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.

Sorting data

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).

Sorting_Data.png

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.

Sorting_Data_2.png

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

Row limits

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.

Row_Limits.png

Displaying totals

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.

Displaying_Totals.png

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.

Next: Data Explorer: Saving Work as Looks

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

Did this answer your question?