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.
Jetrail Data Annalysis

Reading from Dataset

It reads from sample Dataset file.

Processor Configuration

Jetrail Data Annalysis

Processor Output

Jetrail Data Annalysis

Extract date time field

It extracts year and month field from date time field of timestamp using date time field extract Node.

Processor Configuration

Jetrail Data Annalysis

Processor Output

Jetrail Data Annalysis

Calculate count per month

It calculates count per month using query by SQL Node.

Processor Configuration

Jetrail Data Annalysis

Processor Output

Jetrail Data Annalysis

Execute query for months

It executes query for grouping and selecting required fields, calculates sum of counts by SQL Node.

Processor Configuration

Jetrail Data Annalysis

Processor Output

Jetrail Data Annalysis

Prints the Results

It prints the results after executing SQL Query
align:center
width:60%

Graphical analysis

It will graphically represent month with count using GraphValue Node.

Processor Configuration

Jetrail Data Annalysis

Processor Output

Jetrail Data Annalysis