Report Builder

Report Builder allows you to run reports in an easy-to-use, drag & drop interface. Quickly build reports and view your data as needed, or use Report Builder to generate a command that you will save and add to your Dairy Reports. Report Builder currently supports the LIST (SHOW), COUNT, and SUM commands.

You can find this feature under the DairyComp, Reports menu. Click the Build Report button on the top right of the page to build a new report.

Use the tabs at the top of the page to switch between building different commands: 

To build a LIST command, drag and drop items from the left column into the appropriate areas on the right:

1

Command Output: Drag and drop items from the left column onto the report. Reorder the columns by dragging and dropping the item names or click the x next to the item name to delete it.

2

Filters: Drag and drop items from the left column into the Filters area. Then choose an Operator from the drop-down and set a Value.
3

Sorting: Drag and drop items from the left column into the Sorting area, and the choose the sort order: 

  • A - Z: Ascending sort (low to high, earliest to latest)
  • Z - A: Descending sort (high to low, latest to earliest)
4

Switches: Choose whether to include alive, dead, or all animals.

To build a COUNT command, drag and drop items from the left column into the filters area on the right:

1

Command Output: Provides a preview of how the COUNT results will display after the command is executed. This area is read only.

2

Filters: Drag and drop items from the left column into the Filters area. Then choose an Operator from the drop-down and set a Value.
3

Switches: Choose whether to include alive, dead, or all animals.

To build a SUM command, drag and drop items from the left column into the appropriate areas on the right:

1

Command Output - Group By Items: Drag and drop items from the left column onto the report to set the animal groupings. The item placed at the top is the first grouping.

For example, if you set the Group By items to

,

the results display grouped first by Pen and then by LACTClosed Lactation number: 

Reorder the Group By items by dragging and dropping the item names or click the x next to the item name to delete it.
2

Command Output - Average Items: Drag and drop items from the left column onto the report. AVG (Average) is automatically added to the item name: 

Reorder the columns by dragging and dropping the item names or click the x next to the item name to delete it. Report Builder
3

Filters: Drag and drop items from the left column into the Filters area. Then choose an Operator from the drop-down and set a Value.
4

Switches: Choose whether to include alive, dead, or all animals.

For the SUM command, you can also control how some aspects of calculations are handled. Select one or both of the following options: 

  • Include zero values in averages and standard deviation calculations. Without the switch, average, standard deviation, mode, and median PULSE Platform calculations include non-zero values only.
  • Use sample values for standard deviation calculation. Without the switch, PULSE Platform calculates population standard deviation.
< Return to DairyComp > Reports OVERVIEW