Adding and pivoting dimensions, sorting data

Adding dimensions for more detail

Add more dimensions to learn more about your data. For example, under the Geography drop-down, select County Name to add more detail about where Pulse data comes from during your selected time period.

To add a field:

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

  2. Click Run to re-run the query and reflect the added dimensions.

Adding the dimension for County Name splits the Categories by Pulse data deriving from individual Counties.

Sorting data

Data on the Explore page is sorted by default based on the following prioritization:

  1. The first date dimensions, descending

  2. If no date dimension exists, the first measure, descending

  3. If no measure exists, the first added dimension, ascending

However, you often may want to sort data differently. To change the way data is sorted, simply click on the desired tab and toggle between ascending and descending order. For example, if a query defaults to sorting by Total Pulse, you can instead sort by County Name, ascending or descending within your selected date range.

Note that if you reach a row limit, you will not be able to sort row totals or table calculations.

Pivoting dimensions

Multiple dimensions are often easier to look at when you pivot one of the dimensions horizontally. Each value in the dimension will become a column in your Look. This makes the information easier to consumer visually, and reduces the need to scroll down to find data. Centricity supports up to 200 pivoted values.

The pivot Explore results by a dimension:

  1. Click the Pivot icon for that dimension

  2. Re-run the query

  3. To unpivot results, click the field’s gear icon and select the Unpivot option, or simply click the Pivot icon in the field picker again. When a dimension is unpivoted, the pivot icon will appear gray.

If there is no row of data whose value would appear in a column, that is indicated with the null value symbol (a zero with a slash across).

You can also sort pivoted dimensions by clicking the title of the dimension. To sort by multiple pivoted dimensions, hold down the Shift key then click on the dimension titles in the order you would like them sorted. When sorting a pivoted measure, any rows with values in that column are sorted first followed by rows without data in that column (indicated by the null value symbol).

Reordering columns

You can reorder columns in the Data section by clicking on a column header and moving the column to its desired position. The Explore’s visualization will reflect the new column order after you click Run.

Columns are organized in the Data section by field type: dimensions, dimension table calculations, measures, measure table calculations, and row totals. For the most part, columns can be reordered within each field type but cannot be moved out of their field type section. For example, dimension table calculations can be rearranged among themselves, but you cannot place a dimension table calculation in between two measures. One exception, however, is that you can use the arrow next to the row totals checkbox on the Data tab to move the row total column from the far right of the data table to just after the dimension table calculations.

Columns under a pivoted dimension can be reordered, but the order of pivoted dimensions can be changed only by changing the sort order, not by manual reordering.

Removing fields

Remove a field from an Explore by:

  1. Clicking the selected field in the field picker or by choosing Remove from the column’s gear menu

  2. Re-run the query



 

 

More questions about Centricity? Check out our website or talk to our Support Team.