Icon

1. Dashboard - Project Report

<p><strong>Dashboard - Project Report</strong></p><p>In this workflow, we prepare and visualize the data in an interactive dashboard.</p><p>Starting from the accounting of a list of projects, on one branch we calculate the money in budget for each year for each one of the project and on the other branch we calculate the money actually spent for each project each year. We then report the money allocated, the money spent and the money remaining for each project in each year within the view of the component "Project Report".</p><p>When running the workflow on the KNIME Hub, the composite view becomes a web-based interactive dashboard in and can be deployed as Data App and shared with others.</p>

URL: KNIME Beginner's Luck (Book Homepage) https://www.knime.com/knimepress/beginners-luck

Workflow: Dashboard - Project Report


In this workflow, we prepare and visualize the data in an interactive dashboard.

Starting from the accounting of a list of projects, on one branch we calculate the money in budget for each year for each one of the project and on the other branch we calculate the money actually spent for each project each year. We then report the money allocated, the money spent and the money remaining for each project in each year within the view of the component "Project Report".

When running the workflow on the KNIME Hub, the composite view becomes a web-based interactive dashboard in and can be deployed as Data App and shared with others.

Calculating money spent for each project each year

Calculating money in budget for each project each year

Reading data

Calculating remaining money for each year

Create component composite view

Calculate remainingmoney for each year
Expression
Money assigned to project each year
Pivot
Renaming "<year>+Sum(...)" into just "assigned <year>"
Column Renamer
Renaming "<year>+Sum(...)" into just "used <year>"
Column Renamer
Inner joinon RowIDs
Joiner
Component for composite viewon KNIME Hub
Project Report
Money used byproject each year
Pivot
Projects.txt
CSV Reader

Nodes

Extensions

Links