Reflect's data explorer is an intuitive query tool that allows you to easily generate charts, tables and lists, without the complexity of traditional Business Intelligence tools. It helps you deeply analyze your HR metrics and gain valuable insights into your teams.
Accessing the Data Explorer
You can access the data explorer in two ways:
From the main menu : Click on the corresponding icon
in the main menu to open the data explorer.
From a dashboard : Hover over a specific module and click on the associated explorer icon. This icon may appear in three different forms, each representing a specific format detailed below. This will take you to the explorer view of the selected module.
The Different Visualization Formats
Reflect offers three visualization formats:
 KPI |  Chart |  List |
To visualize a measure with or without a dimension in table form. | To generate a chart (bar or pie) of a measure according to a dimension. | To display the data detail as a paginated list. |
Measures
To start using the explorer, click "Add measure" to choose an indicator or metric to visualize. In the measure selection menu that appears, several options:
Select one of the suggested measures (based on your recent searches)
Click on a category then the desired measure
Search for a measure in the search bar
💡 You can generate charts containing two distinct measures.
⚠️ When you are in the explorer view of a module, it is not possible to change the measure you are viewing (🔒). It is only the measure corresponding to that module.
Dimensions / groups
To choose a dimension, click "Add dimension" (or click on an existing dimension to edit it). In the dimension selection menu that appears, several options:
Select one of the suggested dimensions (based on your recent searches)
Click on a category then the desired dimension
Search for a dimension in the search bar
Advanced Features
KPI format
Row / Column
You can choose one or more dimensions as rows, and one dimension as a column. You can also choose no dimension, which will provide the raw measure over the selected time range.
Drilldown
To open the detail of a cell, click on it and get a condensed view of the list corresponding to the data you clicked on.
You can then open the associated list view in a new tab by clicking the icon
. This will directly apply the time and dimension filters.
Total
To display a row with the total of the columns at the very bottom of the table, check the "Total" box at the bottom left.
Percentages
To display percentages instead of exact values, check the "Percentages" box at the bottom left.
Chart format
Dimension / Group by (bar chart only)
You can choose a first dimension for the chart, then a second dimension used as the group within each segment. A chart requires at least one dimension to display.
Drilldown
To open the detail of a chart segment, click on it and get a condensed view of the list corresponding to the data you clicked on.
You can then open the associated list view in a new tab by clicking the icon
. This will directly apply the time and dimension filters.
Sort
To sort the data, either alphabetically / chronologically or from largest to smallest, toggle the "Sort" switch at the bottom left.
Show labels
To hide the source value labels on the chart, uncheck the "Value labels" box at the bottom left.
Percentages
To display percentages instead of exact values, check the "Percentages" box at the bottom left.
List format
Sort
To sort a column's data, click the sort button next to the title of the desired column.
Choose columns
To customize the columns displayed in the list, click the columns button then select the columns on the left, and arrange them in the desired order on the right.
Export data
To export the list data as-is to CSV or Excel format, click the Export button.
Filter the data
To apply a filter to your data, consult the documentation associated with the dimensional filters.