Operational Data · Track 2 · Tutorial 7 of 8

Show operational data in dashboards and Insight Packages

Dashboards are where most people will see the operational data: a chart of units by product, a table of headcount by department. And an operational report can go straight into the month-end pack.

You will needA dashboard you can edit, and the Units sold dataset.
By the endA Units sold by product chart and table on a dashboard, and the Units sold report as a section of an Insight Package.

1Chart it

  1. Open the dashboard in the editor and click Add Widget.
  2. In Add Card, choose Chart and the Chart Type Bar.
  3. In Data Source, under Operational Data, choose Units sold.
  4. In Group by, keep Product, and save the card.
Step 1: Chart it: Open the dashboard in the editor and click Add Widget.; In Add Card, choose Chart and the Chart Type Bar.; In Data Source, under Operational Data, choose Units sold.; In Group by, keep Product, and save the card.
What you do in step 1.

Group by offers the dataset’s dimensions, and Account if its rows have one; it appears when there is more than one to choose from. A dataset with a Scenario column also offers Scenario. At group level, matching datasets from several companies are one source.

2Tabulate it

  1. Click Add Widget again and choose Table.
  2. In Table Type, under Operational Data, choose Units sold, and choose a Data Type, such as YTD.

The table lists each product with Value and Share %; Records and Avg Value can be added under Columns. vs Budget and vs Forecast vs Budget are offered when the dataset holds those scenarios.

Check

The chart has a bar for each product, and the table’s values match the dataset page for the same months.

3Put it in an Insight Package

  1. Open the Units sold operational report from Reports, and arrange it as the pack needs it.
  2. Click Add to Insight Package, choose the package under Select Package, and click Add.

The report is added as it stands, with its layout, filters and months, as a section on a new page titled with the dataset’s name. Pulse does not read operational data.

4If something goes wrong

What you seeWhat to do
The dataset is not under Operational DataIt has no rows for this company yet. Upload its data.
That section is already in this package.The package already has this report from the same company. Open the package to see it.

Want more detail? See the documentation