Using Custom Reports

This article helps explain how to use custom reports in the system.

Teddy Hook avatar
Written by Teddy Hook
Updated over a week ago

In LineLeader Enroll, we've redesigned our custom reporting interface so you now have complete control over how to configure and display your reports.

Overview

  1. In the left-hand navigation, click Reports > Custom.

  2. Click the button for the desired data source.

  3. Select the desired options and click View.

  4. Manipulate the data until it displays the information you want.

  5. (Optional) Do something with the results: save, export, share and/or schedule.


Step 1: Click Reports > Custom

Step 2: Click the button for the desired data source

Data Sources

Step 3: Select the desired options and click VIEW

Select Report Options

Step 4: Manipulate the data until it displays the information you want

LAYOUTS

Layouts can be changed by clicking Options near the top right:

LAYOUT: FLAT FORM

After clicking a Data Source, the data displays in flat form—a view that shows all the data available in a table:

In Flat Form, you can:

  • Drag and drop columns to rearrange their order.

  • Sort data by mousing over a column header and clicking on the arrow that appears.

    • Sort data for multiple columns by holding down Ctrl while clicking to sort.

  • Filter data by clicking the Add Filter button near the top right.

  • Resize data by dragging the edge of the column number.

  • Click “Fields” to remove data you don’t need.

LAYOUT: CLASSIC & COMPACT FORMS (PIVOT TABLES)

Pivot tables organize and summarize your data and perform calculations on your data:

In Classic and Compact Forms, you can:

  • Design your pivot table by clicking Fields and deciding which field(s) should be broken out into different rows, which should be broken out into different columns, which should be used to filter your results and which should have calculations done on them.

    • For example, you could create a pivot table that counts task types (the calculation and the field being calculated) by area and by task type (fields to be broken out into rows and columns) and filtered to just show completed tasks.

CHARTS

You can visualize data by hovering over “Charts” and the clicking one of the chart options. (Don’t move too quickly or else the system won’t catch your click!)

  • Switch back to your data table by clicking “Grid”.

  • The chart will mirror your data table. For example, if your data table is sorted alphabetically or by values in ascending order, your graph will be the same way.

  • You can hover over a chart element to see the data it represents.

  • You can drill down into the data by clicking a chart element.

FORMATTING

You can apply formats to any layout by hovering over “Format” and selecting “Format cells” or “Conditional formatting”.

Step 5: Do Something with the Results (optional)

Once you have the data organized and displayed the way you want (whether as a table or a graph), you have several options:

  • Export the data by hovering over “Export” and selecting a format.

  • Save the data. This will create a new button under My Saved Reports labeled however you want. When you click the button, the exact format and view you saved will reappear. (To have a report update over time, for example a report that shows you data from the previous week or month whenever selected, have a field that contains time in your filter, and use “Last” followed by the timeframe desired. Every day you open that saved report it will show updated data.)

  • Share saved data by clicking “Share”. This puts your saved report under other people’s My Saved Reports section.

  • Schedule saved data by clicking “Schedule”. Selected recipients will get an email linking to your saved report.

Saving, Exporting, Sharing and Scheduling Reports
Did this answer your question?