Jetrail Data Analysis¶
This workflow reads in a dataset. It then calculates the monthly trend in JetRail Dataset and annalyses using graph.
Workflow¶
Below is the workflow. It does the following:
- Reads data from a sample dataset.
- Extracts date time field.
- Calculates count per month.
- Executes query for months.
- Print the results.
- Graphical analysis.
Extract date time field¶
It extracts year and month field from date time field of timestamp using date time field extract Node.
Processor Configuration¶
Processor Output¶
Calculate count per month¶
It calculates count per month using query by SQL Node.
Processor Configuration¶
Processor Output¶
Execute query for months¶
It executes query for grouping and selecting required fields, calculates sum of counts by SQL Node.
Processor Configuration¶
Processor Output¶
Prints the Results¶
- It prints the results after executing SQL Query
align: center width: 60%
