Icon

3. Projects_​Tableau

KBL: Producing data for Tableau
Workflow: Projects_Tableau In this workflow we prepare data to be displayed in areport.Starting from the accounting of a list of projects, onone branch we calculate the money in budget foreach year for each one of the project and on the otherbranch we calculate the money actually spent foreach project each year.We then report the money allocated, the moneyspent and the money remaining for each projecteach year. Calculating money spent for each project each year Calculating money in busget for each project each year Calculating money remaining for each projecteach year Projects filefrom KBLdatafoldermoney by project by yearmoney chartrenaming"<year>+Sum(...)" intojust "used <year>"enaming"<year>+Sum(...)" intojust "assigned <year>"calculatingremaining moneyby RowIDby RowIDNode 18money assignedto projecteach yearmoney used by projecteach yearproject name as RowIDproject name as RowIDMoneyTable.hyper File Reader GroupBy Data to Report Column Rename Column Rename Remaining Money Sorter Sorter Joiner Pivoting Pivoting RowID RowID Tableau Writer(Hyper) Workflow: Projects_Tableau In this workflow we prepare data to be displayed in areport.Starting from the accounting of a list of projects, onone branch we calculate the money in budget foreach year for each one of the project and on the otherbranch we calculate the money actually spent foreach project each year.We then report the money allocated, the moneyspent and the money remaining for each projecteach year. Calculating money spent for each project each year Calculating money in busget for each project each year Calculating money remaining for each projecteach year Projects filefrom KBLdatafoldermoney by project by yearmoney chartrenaming"<year>+Sum(...)" intojust "used <year>"enaming"<year>+Sum(...)" intojust "assigned <year>"calculatingremaining moneyby RowIDby RowIDNode 18money assignedto projecteach yearmoney used by projecteach yearproject name as RowIDproject name as RowIDMoneyTable.hyperFile Reader GroupBy Data to Report Column Rename Column Rename Remaining Money Sorter Sorter Joiner Pivoting Pivoting RowID RowID Tableau Writer(Hyper)

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: 2020-04-23
Last update: 2024-04-18
Created with KNIME version: v4.1.2
Tags: EducationKNIMEPressReportingAggregationPivotingTableau

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

Try NodePit Runner!