Icon

Dashboard

KBL: Producing dashboard for WebPortal
Calculating money spent for each project each year Calculating money in busget for each project each year Calculating money remaining for each projecteach year Workflow: Dashboard In this workflow we prepare and visualize the data in a dashboard.Starting from the accounting of a list of projects, on one branch we calculate themoney in budget for each year for each one of the project and on the other branchwe calculate the money actually spent for each project each year.We then report the money allocated, the money spent and the money remainingfor each project each year within ´the view of the component "Dashboard" renaming"<year>+Sum(...)" intojust "used <year>"renaming"<year>+Sum(...)" intojust "assigned <year>"calculatingremaining moneyby RowIDby RowIDmoney assignedto projecteach yearmoney used by projecteach yearproject name as RowIDproject name as RowIDcomponent for composite viewon KNIME WebPortalProjects.txt filewith path relative to"current workflow"Column Rename Column Rename Remaining Money Sorter Sorter Pivoting Pivoting RowID RowID Project Report CSV Reader Joiner Calculating money spent for each project each year Calculating money in busget for each project each year Calculating money remaining for each projecteach year Workflow: Dashboard In this workflow we prepare and visualize the data in a dashboard.Starting from the accounting of a list of projects, on one branch we calculate themoney in budget for each year for each one of the project and on the other branchwe calculate the money actually spent for each project each year.We then report the money allocated, the money spent and the money remainingfor each project each year within ´the view of the component "Dashboard" renaming"<year>+Sum(...)" intojust "used <year>"renaming"<year>+Sum(...)" intojust "assigned <year>"calculatingremaining moneyby RowIDby RowIDmoney assignedto projecteach yearmoney used by projecteach yearproject name as RowIDproject name as RowIDcomponent for composite viewon KNIME WebPortalProjects.txt filewith path relative to"current workflow"Column Rename Column Rename Remaining Money Sorter Sorter Pivoting Pivoting RowID RowID Project Report CSV Reader Joiner

Nodes

Extensions

Links

Download

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

Download Workflow
On NodePit since: 2022-01-16
Last update: 2024-04-27
Created with KNIME version: v4.4.0
Tags: EducationReportingPivotingAggregationWebPortalKNIMEPress

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

Try NodePit Runner!