Icon

4. Projects_​Spotfire

KBL: Preparing data for Spotfire
Workflow: Projects_Spotfire In this workflow we prepare data to be displayed in areport.Starting from the accounting of a list of projects, on onebranch we calculate the money in budget for each year foreach one of the project and on the other branch wecalculate the money actually spent for each project eachyear.We then report the money allocated, the money spent andthe money remaining for each project each 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 money 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 RowIDProjects.txt filewith path relative to"current workflow"MoneyTable.stdf GroupBy Data to Report Column Rename Column Rename Remaining Money Sorter Sorter Joiner Pivoting Pivoting RowID RowID CSV Reader TIBCO SpotfireFile Writer Workflow: Projects_Spotfire In this workflow we prepare data to be displayed in areport.Starting from the accounting of a list of projects, on onebranch we calculate the money in budget for each year foreach one of the project and on the other branch wecalculate the money actually spent for each project eachyear.We then report the money allocated, the money spent andthe money remaining for each project each 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 money 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 RowIDProjects.txt filewith path relative to"current workflow"MoneyTable.stdfGroupBy Data to Report Column Rename Column Rename Remaining Money Sorter Sorter Joiner Pivoting Pivoting RowID RowID CSV Reader TIBCO SpotfireFile Writer

Nodes

Extensions

Links