• v7.2.0
    • v7.11.0 (latest)
    • v7.10.0
    • v7.9.0
    • v7.8.0
    • v7.7.0
    • v7.6.0
    • v7.5.0
    • v7.3.0
    • v7.2.0
    • v7.1.1
    • v7.1.0
    • v7.0.8
  • Services & Support
  • Devo.com
  • Contact
    • Contact Us
    • Request a Demo
    • Partner Inquiry
  • Log In
    • USA Devo
    • EU Devo
PREVIOUS
Selecting unrevealed columns
NEXT
Data types in Devo

Searching data / Building a query

Download as PDF

Building a query

  • Overview
  • Video tutorial

Devo offers two different ways of building a query:

  • Build a query in the search window - After opening a data table, you can use the tools in the search window to build your query and manipulate data as needed. 
  • Build a query using LINQ - For users familiar with LINQ, Devo allows writing queries using this language.

When querying data in Devo, you can apply filters, create calculated columns, or apply aggregation operations. An aggregation operation computes a single value from a collection of values. These operations help you turn your data into real, usable information and can be described as belonging to four categories:

  • Filtering data - Filter the data in your table to either include or exclude rows that meet the filter conditions you specify. 
  • Group data -  Perform temporal or no temporal data grouping to display all the different row value combinations of the grouped columns. Grouped data can be then aggregated using different operations.
  • Aggregate data -  Apply mathematical calculations on sets of grouped values. To use these, your data must already be grouped by time period. The aggregation operation is then applied to the sets of values in each time period grouping.
  • Create columns - Perform calculations or use lookup tables to generate new columns based on data that already exists in your table.

Learn more about applying query operations using the search window tools and the LINQ language in the following articles. For a complete list of operations that you can apply to your queries, see the Operations reference.

For a general overview of the use of queries, you can check the following video: 

Download as PDF

PREVIOUS
Selecting unrevealed columns
NEXT
Data types in Devo

Export

See what Devo can do for you. Request a demo!
Discover what's new (Release notes)
  • v7.2.0
    • v7.11.0 (latest)
    • v7.10.0
    • v7.9.0
    • v7.8.0
    • v7.7.0
    • v7.6.0
    • v7.5.0
    • v7.3.0
    • v7.2.0
    • v7.1.1
    • v7.1.0
    • v7.0.8
  • Services & Support
  • Devo.com
  • Contact
    • Contact Us
    • Request a Demo
    • Partner Inquiry
  • Log In
    • USA Devo
    • EU Devo
  • +1 888 6830910 (USA)
  • +34 900 838 880 (Spain)
Copyright © 2019 Legal Terms Privacy Policy Cookies Policy

Powered by Confluence and Scroll Viewport