Icon

08_​BIRT_​Example_​Advanced

Advanced example of reporting with BIRT

Final report includes:
- zip code selection page
- tables with scores
- score bar chart as images prodced in the central loop
- box plot of score distribution
- bar chart of top and lowest score in each zip code area.

All bar charts are placed once on each page. You can see this when exporting the workflow into pdf or docx format.


To edit the report:

1) Execute the entire workflow
2) To access the report environment, click the “Open the report” button in the toolbar (make sure that the KNIME Report Designer extension is installed. If not, go to File, then Install KNIME Extensions/KNIME Report Designer)

To export the report in your preferred format:

1) Select "Run" from the report environment
2) Choose your preferred format to see the final report.

Note: if you have changed the KNIME Workbench, click View/Reset Perspective to see all panels in the Report Designer.

Data obtained on April 16, 2018 from this URL:

https://data.austintexas.gov/Health-and-Community-Services/Restaurant-Inspection-Scores/ecmv-9xxi

Grouping Method 1 Grouping Method 2 Box Plot Advanced Example of Reporting with BIRTInput data set contains inspection scores for local restaurants.A report is generated with several different visualizations.For more information see the workflow metadata. Find it here:View -> Description Most recentinspectionMerge back with scoresTop 10 locations by ZIPOnly ZIPs78750-78754,set using globalflowvarsEnd ZIP LoopRestaurantInspection ScoresLoop overselected ZIPsCleanupZIPHists by ZIPSimpleBoxPlotCalculate Quartiles, Min/MaxMax and Min Sites by ZIPby ZIP and scoreExtremes by Zip GroupBy Joiner Data to Report Row Filter Loop End Excel Reader (XLS) Group Loop Start Column Filter GroupBy Data to Report Process Tables andHists for Report Data to Report GroupBy GroupBy Sorter Data to Report Grouping Method 1 Grouping Method 2 Box Plot Advanced Example of Reporting with BIRTInput data set contains inspection scores for local restaurants.A report is generated with several different visualizations.For more information see the workflow metadata. Find it here:View -> Description Most recentinspectionMerge back with scoresTop 10 locations by ZIPOnly ZIPs78750-78754,set using globalflowvarsEnd ZIP LoopRestaurantInspection ScoresLoop overselected ZIPsCleanupZIPHists by ZIPSimpleBoxPlotCalculate Quartiles, Min/MaxMax and Min Sites by ZIPby ZIP and scoreExtremes by Zip GroupBy Joiner Data to Report Row Filter Loop End Excel Reader (XLS) Group Loop Start Column Filter GroupBy Data to Report Process Tables andHists for Report Data to Report GroupBy GroupBy Sorter Data to Report

Nodes

Extensions

Links