How to Create a Query - NEW

The new Query Tool brings more power to your deep database.

If you need a better understanding of Measures, Dimensions, and Filters, click this link to be directed to the end of this article for Definition/Examples of Measures, Dimensions, and Filters.

1. Once logged into your PCS account, select the "Analytics" tab and then select "Create a Query".
   
   
2. Name your Query in the Query Name section.  As you add items to your query, you will see the Query Preview side populate with your selections.
   
   
3. In the Measures section, you will want to add attributes by using the dropdown, deciding if you want to query the Min, Max, Avg, Sum, or StdDev. 
   
   
   
   
4. Change the Label name, if desired.
   
   
5. Click the "+" button to add them to your query.
   
   
6. While building your query, you can always:
   1. Drag and drop to change the order.
   2. Edit by clicking the Edit icon or the token.
      Make the desired changes, the click the "Set" button.
   3. Remove added Measures, Dimensions, and/or Filters by clicking the "X" button.
      
      
7. After you have all of your Measures added, decide how you want those summarized in the Dimension section.
   1. 1. You have three options for adding Dimensions:
         1. Adding Dimensions that are Unique (Crop Year, Zones, Product, etc.).
         2. New User Defined that have not been previously saved, which gives you the control over the classification ranges and labels.
            Once you're satisfied you can Save this classification in order to use it again, or you can use it just once by clicking the "+" and adding it to the query.
            
            
         3. Using a Saved classification by selecting it from your saved list in the dropdown.
            
            
            1. You do have the option of editing your saved classification, which will save it in the future.
               
            2. If you wish to edit it just once, do so in the Query Preview side.
               
               
8. Lastly, include any filters that you may want to add.  Note: These filters remove at the Cell Level, not at the aggregated data level.
   1. By default, "Dry Yield > 0" is added to your query.  You can edit this if you wish or delete it/leave it as is.
      
      
   2. You can add other numerical filters (GDD, Rainfall, specific agronomic environments (high fertility, low fertility, high CEC, low CEC, etc.)
      
      
      
      
   3. Or filter by crop or zones.
      
      
9. You can execute this query on a Group at this time if you desire.
10. Or you can save it and run it at a later time on a group/groups.
    
    

Definition of new terms:

• Measure:  Allows you to see the value of an attribute's data based upon the dimension attributes used
  • Example: Average Dry Yield.
• Dimension:  Allows you to incorporate additional ways to slice your data.
  • Example: Seed Variety or Management Zone.

• Filter:  Allows you to eliminate data that might not be helpful in your results. 
  • Example: Dry Yield > 0 eliminates all fields for which yield has not yet been loaded.

To help you visualize it, here is an example:

Measures

• • Soil Test Potassium Average
  • Soil Test Phosphorus Average
  • Dry Yield Average
  • Dry Yield Standard Deviation Average

Dimensions

• • Crop
  • Company
  • Variety
  • Soil Type
  • Actual Population