Understanding Data Processing

Steps for Data Processing:

Step 1: Import data from various sources (CSV, SQL databases, APIs, etc.)
Step 2: Apply transformations (aggregation, filtering, sorting).
Step 3: Apply Editor to edit to edit the query.
Step 4: Preview and save the graph

Import data from various sources & Add Aggregator to transform the data

Double click on Aggregator after that click on get columns and add columns which we require

after that select the column to which aggregation needs to be done and add required info (e.g sum,avg)

if want can add a editor to edit the query so select editor from transformation tab and double click on editor to edit the query

add the function what we have to work on (eg,datediff) and click on validate & update

At last add preview to view and check the aggregated & edited columns and save the graph