Visualizations in Report Builder

Visualizations in Adobe Learning Manager Report Builder turn a saved report into charts and dashboards. You can compare groups, spot trends, and share results without reshaping data in a spreadsheet tool.

IMPORTANT
Visualizations (charts and dashboards) in Report Builder are available only to Adobe Learning Manager Ultimate customers. They aren’t available with the Prime edition.

About visualizations in Report Builder about-visualizations

A visualization is a chart, or a dashboard of charts, built from a report you saved in Report Builder. You choose which report columns to plot, and Report Builder draws the chart from the report data. You can plot columns directly, or plot summarized data from a report.

  • Build charts for a report: Open the report, select Visualization, and create charts. See Create a chart from a report.
  • Group charts on a dashboard: Choose reports as a data source, and then add charts from them. See Build a dashboard.
  • Share and view: Share a dashboard with Administrators, who view and filter it in read-only mode.

Charts work in two modes:

  • Configure mode: You create or edit the chart.
  • View mode: You filter what the chart displays without changing how it is built.

Chart types and when to use them chart-types

Choose the chart type by the question you want to answer.

Chart type
Use it to
Example
Line
Show how a value changes over time.
Enrollments by creation month
Bar or column
Compare values across categories. Grouped, stacked, and 100% stacked layouts are available.
Learners by enrollment status
Pie
Show each category’s share of a whole. Segments under 1% are grouped into an Others segment.
Enrollments by catalog
Big number
Highlight one key metric.
Total completions this quarter
Table
Show exact values. You can choose a subset of columns, and show one date column as rows instead of columns (column-to-row view).
Learning time spent per user, per month
NOTE
Line charts built from trend reports, such as enrollments by month, show the current snapshot of your data grouped by date. They don’t show how the data looked at each past date. For more information, see Report Builder concepts and terminology.

Visualization terms visualization-terms

Term
Meaning
Report
A saved Report Builder configuration of columns, filters, and grouping. Charts are built from reports.
Chart-level filter
A filter you set when you create or edit a chart. It limits the data the chart plots.
Page-level filter
A filter a viewer applies to all charts on a page or dashboard. It can narrow, but not widen, the report’s own filters.
Report Builder dashboard
A page of charts that you build in Report Builder.

Create a chart from a report create-chart-from-report

Create a chart from a saved report to see enrollment, completion, or time-spent data at a glance. You configure the chart once, and it draws from your report data each time you open it.

Before you create a chart before-you-create-chart

Confirm the following:

  • Save the report. The option to add a chart appears on the Report Builder page after you save the report.
  • Use your own report. Duplicate a shared report to create your own copy, and then use it to create charts.
  • Check the size. A report with more than 10 million rows can’t be plotted. A summarized report with more than 10,000 data points isn’t plotted. See Chart and dashboard limits.
  • Know your columns. The chart’s X axis (dimension) and Y axis (measure) come from your report’s columns. To summarize the report itself, use Group by and aggregates. For more information, see Apply group by and aggregations.

Configure a chart configure-chart

  1. Sign in to Adobe Learning Manager as an Administrator.

  2. Select Reports, and then select Report Builder.

  3. Select the Reports tab, and then open a saved report. For this example, select a user login trend report, which shows the number of users who logged in to the learning platform on each date.

  4. In the left navigation, select Visualization. A panel opens with Setup and Style tabs.

    Visualization panel with the Setup and Style tabs

    note
    NOTE
    After a chart exists, select Edit, and then select + to add another chart.
  5. In Chart type, select a type, such as Line chart. This field is required.

  6. Next to Dimension - X Axis, select the add icon, and then select the report column. For a date column, also select a Date granularity, such as day or month.

    Dimension - X Axis settings with a date column and granularity {width="650"}

  7. Select Add to add the date dimension.

  8. Next to Measure - Y Axis, select the add icon, and then select the report column and how to aggregate it, such as Count.

    Measure - Y Axis settings with a column and aggregate {width="650"}

  9. Select Add to add the measure.

  10. (Optional) Select Add filter to limit the plotted data to a range, such as the last 30 days. Select Add.

    Add filter dialog with a date range {width="650"}

  11. (Optional) Add a Sort column, and then select Ascending or Descending. Select Add.

    Sort settings with the Ascending and Descending options {width="650"}

  12. (Optional) For a line chart, set Gap handling for missing data. See Gap handling for missing data.

  13. In Max data points, enter the number of data points to plot on the chart. The default is 100 points, and the limit is 10,000.

  14. Turn on Group rest of the points as ‘others’. Report Builder displays individual data points up to the Max data points value, and combines everything beyond that limit into one additional category called Others.

    For example, if Max data points is 150 and your query returns 200 points:

    • Report Builder displays 150 points individually.
    • Report Builder combines the remaining 50 points into Others.
    • The chart shows 151 plotted points: 150 plus Others.
  15. Select Next. You can now customize your chart.

    Setup tab with the Next button {width="650"}

Gap handling for missing data gap-handling

Gap handling defines what the chart does when one or more observations in a series have no numeric value, such as NULL, NA, NaN, or an empty cell.

Suppose the data is:

X
Value
Jan
10
Feb
15
Mar
NA
Apr
NA
May
25

The following table shows the three behaviors.

Gap handling
Conceptual result
How it is plotted
Line to zero
10 -> 15 -> 0 -> 0 -> 25
Treats missing values as 0.
Skip
10 -> 15 25
Doesn’t plot the missing points, and breaks the line.
Connect
10 -> 15 ----> 25
Doesn’t plot the missing points, but connects the valid observations on either side.
NOTE
Connect is not interpolation. If March and April are missing, connecting February directly to May only draws a visual line between the two known values. It does not create actual March and April values.

Customize the chart customize-chart

Customize a chart to make it clear and easy to read. On the Style tab, you can add a title, show or hide axis titles and legends, position and align the legend, and set a color for each series. Style changes affect only how the chart looks. They don’t change the data it plots.

  1. To show a title above the chart, select Show title for chart. To hide it, turn the option off.

  2. In Chart title, enter a title for the chart.

  3. Select Show title for X Axis and Show title for Y Axis to label the axes.

  4. To show a key that identifies each line, select Show legends.

  5. In Legend position, select the left, center, or right icon to align the legend.

  6. Under Line color, select the color swatch next to a series, such as Number of users.

  7. In the color picker, choose a color from the palette, or use the custom tab to define your own.

  8. Repeat the previous two steps for each line you want to recolor.

  9. Select Create to add the chart. If you’re editing an existing chart, select Save.

    Style tab with the chart title, legend, and line color options {width="650"}

The chart appears with your titles, legend, and line colors.

TIP
  • Choose colors that contrast clearly with each other and with the background. Keep titles and the legend on so that color isn’t the only way to tell the lines apart.
  • The Legend position, Legend alignment, and Line color options apply only when Show legends is turned on.
  • Each line in the chart has its own swatch, one per measure you added on the Setup tab.

To arrange charts on a single page, see Build a dashboard.

Create a pie chart create-pie-chart

Use a pie chart to show how a whole divides into parts, such as the share of employees who completed mandatory training, or the mix of course formats. Each slice shows one category’s share of the total.

About pie charts about-pie-charts

A pie chart draws one slice per category. The slice size shows that category’s share of the total measure. A legend identifies each slice, and each slice displays its value.

Use a pie chart to show parts of a whole across a few categories, when viewers need proportion more than exact values. To compare many categories, use a bar chart. To show change over time, use a line chart.

Steps to create a pie chart pie-chart-steps

Before you begin, save a report that you own. Include one column for the categories and one column to measure.

  1. Select Reports, and then select Report Builder. On the Reports tab, open the saved report.
  2. In the left navigation, select Visualization.
  3. In Chart type, select Pie chart.
  4. Next to Dimension - Segment, select the add icon, and then select the column that defines the slices. For example, select Transcript (Learning Object) - Status.
  5. Next to Measure - Value, select the add icon, and then select the column and aggregate that size the slices, such as Count.
  6. (Optional) In Max data points, enter the maximum number of slices to draw. The default is 100.
  7. (Optional) To combine minor categories, turn on Group rest of the points as ‘others’.
  8. Select Next to customize the pie chart.

Customize the pie chart customize-pie-chart

  1. To show a title, turn on Show title for chart. Turn it off to hide the title.

  2. In Chart title, enter a title, such as Mandatory Compliance Completion.

  3. In Chart style, select Pie for a solid circle, or Donut for a ring.

  4. Select Show legends to display the legend on the chart.

  5. In Legend position, select where the legend appears.

  6. In Legend alignment, select left, center, or right.

  7. Select Create for a new chart. When you edit an existing chart, select Save, and then select Save on the Visualization page.

    Pie chart with a legend {width="650"}

Report Builder creates the pie or donut chart.

Create a bar chart create-bar-chart

Use a bar chart to compare a measure across categories, such as training status by team or learning time by customer. Bars are easy to compare and rank, and you can group or stack them to add a second breakdown.

About bar charts about-bar-charts

A bar chart draws one bar for each category on the X axis. The bar’s length shows the measure on the Y axis, such as a count of learners. You can draw bars vertically (columns) or horizontally.

Use a bar chart to:

  • Compare values across categories, such as teams, partners, or customers.
  • Rank categories from highest to lowest.
  • Show a second breakdown inside each bar, such as status within each partner.

Before you create a bar chart before-you-create-bar-chart

  • Save the report, and use a report you own.
  • Include a column for the categories and a column to measure.
  • Keep the report within the limits in Chart and dashboard limits.

Steps to create a bar chart bar-chart-steps

  1. Select Reports, and then select Report Builder. On the Reports tab, open the saved report.

  2. In the left navigation, select Visualization.

  3. In Chart type, select Bar chart.

  4. Next to Dimension - X Axis, select the add icon, and then select the column that defines the categories. Select Done.

    Dimension - X Axis settings for a bar chart {width="650"}

  5. Next to Measure - Y Axis, select the add icon, and then select the column and how to aggregate it, such as Count. Select Done.

    Measure - Y Axis settings for a bar chart {width="650"}

  6. (Optional) Add Filters to limit the data, and set Sort to order the bars by a column.

  7. In Max data points, enter the maximum number of data points to plot. If you enter 150, Report Builder displays up to 150 individual data points, and combines everything beyond that limit into one additional category called Others.

  8. Select Next to customize the bar chart.

Customize the bar chart customize-bar-chart

Use the Style tab to set the title, orientation, grouping, legend, and colors. Style settings change how the chart looks, not the data it plots.

  1. Select the Style tab.
  2. To show a title, turn on Show title for chart. In Chart title, enter a title, such as Most Popular Courses.
  3. To label the axes, turn on Show title for X Axis and Show title for Y Axis. Turn an option off to hide that title.
  4. In Chart style, select Vertical for columns, or Horizontal for bars that run sideways. Horizontal bars leave more room for long category names.
  5. In Bar grouping, select one of the three icons to set how multiple series share a category: grouped, stacked, or 100% stacked.
  6. To identify each series, turn on Show legends.
  7. In Legend position, select where the legend appears. In Legend alignment, select left, center, or right.
  8. Under Bar color, select the swatch next to a series, and then choose a color.
  9. Select Create for a new chart. When you edit an existing chart, select Save.
NOTE
Bar grouping matters only when a bar has more than one series, such as two measures. Keep the legend on and show data labels, so color isn’t the only way to tell series apart.

Create a big number create-big-number

Use a big number to show one key metric as a large, easy-to-read figure, such as total learners, overdue enrollments, or active users. Big numbers work well at the top of a dashboard, where viewers check key figures first.

About big numbers about-big-numbers

A big number is a tile with two parts: a value and a label. The value is a single number calculated from your report, such as a count or a sum. The label tells viewers what the number means. A big number has no axes, legend, or categories.

Use a big number to:

  • Show a headline figure that someone checks regularly.
  • Give context to a dashboard before the detailed charts below it.

Steps to create a big number big-number-steps

Before you begin, save a report you own. Decide the one number you want, and which column and aggregate produce it.

For example, training Administrators report each month on how much training the organization completed. Leaders want one headline figure, not a list of enrollments, and Administrators want to refresh it without rebuilding the report.

  1. Select Reports, and then select Report Builder. On the Reports tab, open the saved report.

  2. In the left navigation, select Visualization.

  3. In Chart type, select Big Number.

  4. In Measure - Value, select Transcript (Learning Object) - Status, and then apply the Count aggregate. Select Done.

    Measure - Value settings for a big number {width="650"}

  5. Select the number of digits to show after the decimal point. You can select at most two digits.

  6. In Display unit, select how large numbers are shortened. Select K for thousands, M for millions, B for billions, or None to show the full value. Auto selects the appropriate unit automatically. Select Next.

    Display unit options for a big number {width="650"}

Customize the big number customize-big-number

Use the Style tab to customize the legend properties of the big number.

  1. In Legend title, enter the text that names the number. For example, enter Total Course Completions.

  2. In Legend position, select one of the two icons to set where the title appears.

  3. In Legend alignment, select left, center, or right.

  4. Select Create for a new chart. When you edit an existing chart, select Save.

    Big number with a legend title {width="650"}

Create a table or pivot chart create-table-pivot-chart

Use a pivot table to summarize a number across two categories, such as how many learners in each manager’s team have completed, started, or not started required learning. You can also switch to a pivot-style view, where dates or categories run across the top of the table, so each learner or course fits on one row.

About table and pivot charts about-table-pivot

A pivot table is a grid with one category down the side, one category across the top, and a number in each cell. Each cell shows the measure for one row value and one column value. You build it with three settings on the Setup tab.

Setting
What it does
In the example
Dimension - Columns
The values of this field become the column headings across the top.
Transcript (Learning Object) - Status: Completed, In Progress, Not Started
Dimension - Rows
The values of this field become the row labels down the left side, one row for each value.
User - Manager Name
Measure - Value
The number in each cell. You choose a column and an aggregate, such as Count. It appears as the column name followed by Aggregated by: Count.
Count of learners

A dimension is a field you group by. A measure is a number you calculate.

Before you create a table chart before-you-create-table-chart

  • To use column-to-row view, group the report by the column you want as headings, such as a date.
  • If you group by more than one date column, you pick one of them for the headings.

Steps to create a table chart table-chart-steps

  1. Select Reports, and then select Report Builder. On the Reports tab, open the saved report.

  2. In the left navigation, select Visualization.

  3. In Chart type, select Table / Pivot.

  4. Next to Dimension - Rows, select the add icon, and then select User - Manager Name.

  5. Next to Dimension - Columns, select the add icon, and then select Transcript (Learning Object) - Status.

  6. Next to Measure - Value, select the add icon. Select the measure Transcript (Learning Object) - Status, and then select Add.

    Setup tab with the rows, columns, and measure for a pivot table {width="650"}

  7. Turn on either or both of the following options, based on your reporting requirements:

    • Show grand total for columns: Displays the grand total for each column. For example, if the table displays sales data across different regions, the grand total shows the total sales for each column.
    • Show grand total for rows: Displays the grand total for each row. For example, if the table displays monthly sales across different products, the grand total shows the total sales for each row.
  8. In Number of rows to be displayed (max 20), enter how many rows to show in the table at one time. The default is 10, and the maximum is 20. For example, 15 displays 15 rows per page.

  9. Select Next.

Customize the table customize-table

Use the Style tab to add the chart title, color the table header, and color the table rows.

  1. In Chart title, enter the title you want to display, such as Status of Learning.
  2. Select Header row color to apply a background color to the header row.
  3. Turn on Highlight alternate rows to apply alternating colors to rows for easier reading.
  4. Select Color 1, and choose the first color for the alternating rows.
  5. Select Color 2, and choose the second color for the alternating rows.
  6. Select Save to apply the style settings to the chart.

Build a dashboard build-dashboard

A dashboard puts charts from one or more of your reports on a single page. Build one when you answer the same questions repeatedly, such as how many people completed training this month, or which teams are behind.

About Report Builder dashboards about-dashboards

A dashboard is a page of charts. You choose the reports it draws from, called its data source, and then add charts from those reports. Charts always come from reports, so create them first on each report’s Visualization page. You can use only reports you own. Scoping applies to every chart on the dashboard.

Create the dashboard create-dashboard

  1. Select Reports > Dashboards. The page lists all dashboards that you created.

  2. Select Create Dashboard.

  3. Enter the name and description of the dashboard.

    Create Dashboard page with name and description fields {width="650"}

  4. In Data source, select Add report to add the pre-created charts from the available reports.

  5. Select one or more reports from the list, and then select Add.

    Report list with the Add button {width="650"}

Report Builder adds the reports to the dashboard.

Dashboard with the added reports {width="650"}

View the charts in the dashboard view-charts

Select Charts in the left navigation pane of the dashboard.

Charts option in the dashboard left navigation pane {width="650"}

All charts from the available reports appear on the dashboard.

Dashboard displaying charts from the available reports {width="650"}

Move charts in the dashboard move-charts

  1. Select Edit in the upper-right corner of the dashboard. You can view the columns in each report that were used to create the charts. You can also create another chart to add to the dashboard.

    Dashboard in edit mode {width="650"}

  2. From the left panel, select the charts you want to add to the dashboard.

  3. Drag each chart to the position you want, and then release it to place the chart.

  4. Repeat the previous step to arrange the charts according to your reporting requirements.

  5. Select Save to save all changes in the dashboard.

Share a dashboard share-dashboard

Share a Report Builder dashboard with other Administrators so they can view the same charts and data.

Charts you create from a report are saved with that report. When you share the report, other Administrators get the charts too. Share a dashboard once instead of asking each Administrator to rebuild it.

Share a dashboard with other Administrators share-with-administrators

  1. Sign in to Adobe Learning Manager as an Administrator.

  2. Select Reports, and then select Report Builder.

  3. Select the Reports tab, and then open the report that contains the dashboard.

  4. Select Actions > Share.

  5. Under Share, select Edit.

  6. Select the Select users / usergroups field.

  7. Search for and select the Administrators or user groups you want to share with.

    Share dialog with the Select users / usergroups field {width="650"}

  8. Select Save.

The selected Administrators can now view the report and its charts in their Report Builder view.

NOTE
Administrators with shared access can view, duplicate, and edit the report.

Remove shared access remove-shared-access

  1. Open the report, and then select Actions > Share.
  2. Under Share, select Edit.
  3. Deselect the Administrator or user group.
  4. Select Save.

Best practices for sharing sharing-best-practices

  • Share one well-configured report instead of letting each Administrator build a variation. This keeps one authoritative version of the data.
  • Create the report with filters that apply to everyone you share it with, so all viewers see consistent charts.

Delete a dashboard delete-dashboard

Delete a Report Builder dashboard when you no longer need it. Deleting a dashboard permanently removes it and its associated sharing settings. You can’t undo this action.

  1. Sign in to Adobe Learning Manager as an Administrator.

  2. Select Reports, and then select Report Builder.

  3. Select the Reports tab, and then open the dashboard you want to delete.

  4. Select Actions > Delete. The Confirmation required dialog appears. It displays the dashboard name and the users with whom the dashboard is shared.

    Confirmation required dialog for deleting a dashboard {width="650"}

  5. Select one of the following options:

    • Edit sharing: Review or change the users with whom the dashboard is shared.
    • Cancel: Close the dialog without deleting the dashboard.
    • Delete dashboard: Permanently delete the dashboard and remove its sharing settings.
recommendation-more-help
learning-manager-help-migrated