FarmQA's Analytics tool is used to analyze the data that you've imported to your account through scouting and metric upload. You can setup a metric for whatever data source you want to track from various sources, like pest observations from scouting reports or NDVI data from a map layer. After setup is complete, all metric enabled questions will automatically populate in the Analytics report tab. Metrics can be visualized as graphs and stored in a dashboard. There's a lot to unpack with Analytics, so check out the article below to learn more about getting Analytics setup.
Table of contents
Settings up Metrics
The first thing you need to do is setup the metric(s) you want to track. Follow the instructions below to learn how to do this.
- Log in to your FarmQA account from the web app.
- Click on the Analytics icon on the left-hand side of the screen, then navigate to the Metrics tab.
- Begin setting up a new metric by clicking the blue + New Metric button. Metrics can be setup to track Numeric or Picklist datasets (pictured below).
- Numeric datasets contain numbers (i.e. insect observations, crop yield).
- Picklist datasets contain a set of values to pick from (i.e. rating disease severity as low, medium, or high).
- Fill out the basic metric information, including the metric Name, Category, and Title.
- Name and Title are what the metric will be called. The Name and the Title can be the same.
- Category will be used to store and organize your metrics. For example, all of your soils data could be stored in a 'Soil' category.
- For Numeric data, set the Number of decimal places you want your data reported to, the Range of data you want reported, and the Color scale you want to use to represent your data.
- For Picklist data, add the data values you would like to include in your dataset, and select the colors you would like to use to represent these data.
- Metric data can be imported either from Scouting reports or Map layers. Scouting report data will be added to your dataset when the scouting report is sent in from the FarmQA mobile app.
- Once you have completed these steps, select the Save icon above the Name box to save your new metric.
Using Metrics designer to view your maps and graphs
After you have setup a metric to track, you can set up a visualization for your analyzed metrics in the Metrics designer tab.
- Log in to your FarmQA account from the web app if you aren't already.
- Click on the Analytics icon, then navigate to the Metrics designer tab.
- If you have previously created any visualizations, then will load on the screen. To create a new visualization, click the black at the top of the screen (pictured below).
- Select your desired metric under the METRICS header on the upper right-hand side of the screen to begin data visualization.
- Choose the organization you want to collect data from under the FARMS AND FIELDS header. Use the two dropdown menus at the upper right-hand side of the screen to choose what chart type you want to display and the time frame you want to collect data to summarize over.
- Check the box next to each crop under the CROPS header that you want included.
- Finally, adjust the chart type and the duration over which to summarize metrics using the two dropdown menus at the top of the page (pictured below).
- To adjust how you want to view your data, select one of the following options:
- Line chart: Graphs the average value of the desired metric across all fields over the users desired time period (pictured: Stand Count over the past year to date).
- Heat map: displays observation density on a map using a heat map format.
- Field averages map: displays the average value for your selected metric on each field over the time period you selected.
- Range chart: displays the highest and lowest values recorded for your selected metrics within the desired time period.
- Bar chart (Picklist only): displays the counts of each Picklist option for the selected metric over the desired timeframe.
Once all the proper information has been selected, your desired graph or map will be displayed.
- Saving a map will add the map to your Dashboard.
NOTE: Any metric parameter (i.e. Name, Category) can be edited later after being created.
Metrics that you have setup using the Metrics designer are all loaded into your Dashboard. All maps and graphs on your Dashboard are fully functional: fields on maps and points on graphs can be selected to view values, and data stored at different times on maps can be displayed.
Report tab and sorting
All of your data that has been assigned to a metric will be displayed in the Report tab as a sortable table. The Report table can be manipulated in a few ways. On the header of each column there are three vertical dots that, when clicked, opens the menu for sorting that column (pictured below). Find below a set of instructions for how to use these functions:
- Group by this column: the table will be sorted based on the values in this column. This function is discussed further below in the Grouping columns section.
- Sort Ascending: sorts the column from smallest value to largest value. For text values, it will sort in alphabetical order.
- Sort Descending: sorts the column from largest value to smallest value. For text values, it will sort in reverse alphabetical order.
- Columns: hover your cursor over this option to gain access to a menu that you can use to turn the other columns in the table on and off.
- Filter: allows you to filter your column by an entered value. Filter options include Equal, Greater Than, Greater Than or Equal, Less Than, Less Than or Equal, and Not Equal to the entered value.
- Freeze: all columns to the left of and including the frozen column will remain in place while the other columns can be scrolled through. This function is useful if you have a large table and want to keep track of certain columns while you scroll through it.
- NOTE: if you have the Freeze feature turned on, you the Group by feature cannot be used at the same time.
Other useful sorting options
Grouping columns: Metrics reported in the table can be sorted by one or more categories.
- Start this by dragging a column header (i.e. "Farm" as pictured below) into the Drag a column header here to group its column rectangle above the analytics table.
- The table will now sort all values by that category. In this case, you can see that MN Farm and ND Farm are separated (pictured below). You can add a second category to sort by by repeating the previous step.
- Now our analytics table is sorted by farms, then crops. This sorting can be undone by pressing the "x" in the right-hand side of text box for each category in the blue rectangle above the analytics table.
Search: Any term that appears in the table can be searched using the Search box in the upper right-hand corner of the screen. All rows that do not include the search term will be excluded from the table (see below: searching for "Corn" removes all rows that do not have "Corn" recorded in them).
Please contact FarmQA Support with any further questions