Report Pivots

Report Pivots

Pivot mode allows the user to analyse the data loaded in the Report using a pivot table. The Rocket icon provides a guided tour of the pivot functionality in StockMate.

Pivots are created and saved against report configurations. Once the pivot is saved, it will remain available whenever that report configuration is used and can be run in future without needing to be recreated from scratch.
In order to use Pivot mode, data needs to be loaded into the Results section of the screen.

Setting up a Pivot

  1. To load data, input the relevant Search Criteria, select the required Report Configuration, Load.

  2. The data loaded in the report is visible in Data mode. This data feeds into the Pivot table which groups and summarises the data according to the Pivot table's selected fields.
  3. To add fields to the Pivot table, select Pivot, open the Field Chooser where you can select fields for the pivot table.

  4. In the Field Chooser window, select the fields to be included in each part of the pivot table.
    The columns from Data mode are available as 'fields' in Pivot mode. All the available fields are shown in the All Fields section in the Chooser.
  5. Fields can be added to the pivot table by dragging them from the All Fields section into one of the other sections: Row Fields, Column Fields, Data Fields and Filter Fields. At least one field must be added to each of the four sections in the Field Chooser. Select X.
    If a total count of the number of heads is required, ‘Total Animals’ must be included in the Data field. The Pivot function in StockMate cannot count the number of animals based on other fields such as 'EID' or 'NLIS ID'.


  6. The data is displayed in a pivot table. Select Save As... to save the Pivot. Rename the Pivot configuration, select Save.


  7. To display the pivot as a chart, select Add Chart.

  8. Select the Chart type from the dropdown box. Select Stacked, if desired, to change the way the chart is displayed.
  9. Type in the Title for the Chart. It can then be saved or printed. Select an Export format from the dropdown list.

Additional information about Pivots

  1. There are preset pivot report configurations for some Reports in StockMate as follows:
    Name of Report
    Preset Pivot Configuration
    Livestock Report
    Arrivals by Breed over time; Genders per Class
    Sessions Report
    Moves by Class
    Treatments Report
    Treatment Usage over Time; Treatments by Ailment
    Forecast by Weight Report
    Exit Week by Mob
  1. Select the Rocket icon to take a guided tour of the Pivot function in StockMate.
         
  1. The data in the Pivot is grouped, filtered and summarised by the fields you selected in the Field Chooser. The description of the sections in the Field Chooser are as follows:
    Field
    Description
    Row Fields
    These are used to group the data. If the user selects multiple row fields, then the grouping is nested. You can expand and collapse nested groups by clicking the row headers.
    Column Fields
    These are used to group the data in a second dimension. If the user selects multiple column fields, then the grouping is nested - you can collapse and expand nested groups by clicking the column headers.
    Data Fields
    These are used to calculate summary values in the pivot table's cells. These values summarise the data represented by the intersection of any given row and column in the pivot table.
  1. Pivot Configurations can be managed using the toolbar. A set of pivot mode settings - including selected fields, sorting, filtering and charts - can be saved as a Pivot Configuration. A saved configuration can be quickly loaded by selecting it from the drop-down list. Pivot configurations are saved within the current Report Configuration.
    Pivot Configurations can not be saved to StockMate Preset Report Configurations, instead a copy of the report configuration will be automatically generated on save.

    Use the Save button to save changes you've made to the current Pivot Configuration. Other tasks such as renaming and deleting Pivot Configurations can be performed from the Report Configuration editor.

    Individual Pivot Configurations can be added or deleted and renamed. A Pivot Configuration can be selected for editing by clicking it. The selected one is highlighted in dark blue. Select Save.


    • Related Articles

    • Report Configurations

      Report Configurations can be used to tailor the data displayed in reports for specific needs. Report Configurations can be shared across an organisation so all users have access to them, made private for personal use, and added to a Starred list for ...

    • Head Days Report (web)

      The Head Days Report provides a summary of the time animals spent in a Paddock, or other specified state, over a given date range. It has practical uses in assisting with Carbon Capture reporting, or assessing carrying capacity. This is a summary ...

    • Position Statement Report (web)

      The Position Statement Report provides a summary of Ins, Outs, and Deads for a given date range. It may be useful for providing a snap shot of animal arrivals, transfers and exits over a month, quarter or year. This is a summary report only, ...

    • Livestock Report (web)

      The Livestock Report displays Active animals, as at the report date, in StockMate. If required, the user can select to include Dead, Missing or Exited animals. The report can be highly customised to display a summary or detailed view as desired. ...

    • Treatments Report (web)

      The Treatments Report displays stock treatments. It can be highly customised to display a summary or detailed view, as desired. Generating the Report Select Reports, Treatments. Select the desired Report Configuration from the dropdown, specify ...