Building a query
Devo offers two different ways of building a query:
- Build a query using the query window tools - After opening a data table, you can use the tools in the query window to build your query and manipulate data as needed.
- Build a query using LINQ - For users familiarized 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. These operations help you turn your data into real, usable information and can be described as beloging 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 a 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.