Icon

08_​BIRT_​Example_​Advanced

Advanced Example of Reporting with BIRT

Input data set contains inspection scores for local restaurants. Final report includes: - zip code selection page - tables with scores - score bar chart as images produced 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 one for each page. You can see this when exporting the workflow onto pdf or doc format.

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.Final report includes:- zip code selection page- tables with scores - score bar chart as images produced in the central loop- box plot of score distribution- bar chart of top and lowest score in each zip code areaAll bar charts are placed one for each page. You can see this whenexporting the workflow onto pdf or doc format. To edit the report:1) Execute the entire workflow 2) To access the report environment, clickthe “Open the report” button in the toolbar(make sure that the KNIME Report Designerextension is installed. If not, go to File, thenInstall KNIME Extensions/KNIME ReportDesigner)To export the report in your preferredformat:1) Select "Run" from the report environment 2) Choose your preferred format to see thefinal report.Note: If you have changed the KNIME Workbench,click View/Reset Perspective to see allpanels in the Report Designer. RestaurantInspection ScoresMost recentinspectionMerge back with scoresTop 10 locations by ZIPOnly ZIPs78750-78754,set using globalflowvarsEnd ZIP LoopLoop overselected ZIPsCleanupZIPHists by ZIPSimpleBoxPlotCalculate Quartiles, Min/MaxMax and Min Sites by ZIPby ZIP and scoreExtremes by ZipNode 37 Excel Reader (XLS)(deprecated) GroupBy Joiner (deprecated) Data to Report Row Filter Loop End Group Loop Start Column Filter GroupBy Data to Report Process Tables andHists for Report Data to Report GroupBy GroupBy Sorter Data to Report Send to Power BI 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.Final report includes:- zip code selection page- tables with scores - score bar chart as images produced in the central loop- box plot of score distribution- bar chart of top and lowest score in each zip code areaAll bar charts are placed one for each page. You can see this whenexporting the workflow onto pdf or doc format. To edit the report:1) Execute the entire workflow 2) To access the report environment, clickthe “Open the report” button in the toolbar(make sure that the KNIME Report Designerextension is installed. If not, go to File, thenInstall KNIME Extensions/KNIME ReportDesigner)To export the report in your preferredformat:1) Select "Run" from the report environment 2) Choose your preferred format to see thefinal report.Note: If you have changed the KNIME Workbench,click View/Reset Perspective to see allpanels in the Report Designer. RestaurantInspection ScoresMost recentinspectionMerge back with scoresTop 10 locations by ZIPOnly ZIPs78750-78754,set using globalflowvarsEnd ZIP LoopLoop overselected ZIPsCleanupZIPHists by ZIPSimpleBoxPlotCalculate Quartiles, Min/MaxMax and Min Sites by ZIPby ZIP and scoreExtremes by ZipNode 37 Excel Reader (XLS)(deprecated) GroupBy Joiner (deprecated) Data to Report Row Filter Loop End Group Loop Start Column Filter GroupBy Data to Report Process Tables andHists for Report Data to Report GroupBy GroupBy Sorter Data to Report Send to Power BI

Nodes

Extensions

Links