Icon

23_​Export_​to_​BIRT_​Report - Solution

23_Export_to_BIRT_Report - Solution
Exercise BIRT Report1) Read data adult.csv2) Create a pivot table, by workclass, that counts the number of records for each income class3) Sort the pivoted table by workclass4) Send the data to BIRT for use in a report5) In the BIRT Report editor, use a grid to layout the following elements:- A report title- A formatted pivot table- BONUS: a bar chart of counts with workclass on the X-axis, and income classes in two differentseries on the Y-axis Increase the image size in theImage to Report node if the imagequality is poor in the report Read data adult.csvCreate a pivot table, byworkclass, that counts the number of recordsfor each income classSort the pivoted tableby workclassAssign colors toincome classesA bar chart of countswith workclassBar chartPivot tableRename missingworkclass as "Unknown" File Reader Pivoting Sorter Color Manager Bar Chart ExtractColumn Header Transpose Image to Report Data to Report Rule Engine Exercise BIRT Report1) Read data adult.csv2) Create a pivot table, by workclass, that counts the number of records for each income class3) Sort the pivoted table by workclass4) Send the data to BIRT for use in a report5) In the BIRT Report editor, use a grid to layout the following elements:- A report title- A formatted pivot table- BONUS: a bar chart of counts with workclass on the X-axis, and income classes in two differentseries on the Y-axis Increase the image size in theImage to Report node if the imagequality is poor in the report Read data adult.csvCreate a pivot table, byworkclass, that counts the number of recordsfor each income classSort the pivoted tableby workclassAssign colors toincome classesA bar chart of countswith workclassBar chartPivot tableRename missingworkclass as "Unknown" File Reader Pivoting Sorter Color Manager Bar Chart ExtractColumn Header Transpose Image to Report Data to Report Rule Engine

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: Maarit Laukkanen
Created at: 2020-04-20
On NodePit since: 2021-04-15
Last update: 2024-04-27
Created with KNIME version: v4.1.3
Tags: e-learningBIRTreporteducation

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!