Icon

Just KNIME It _​ Challenge 021

Just KNIME It _ Challenge 021
Just KNIME It! - Challenge 21: Eating Out Results Dashboard: Data: Challenge21Provided Data eating_out.csvFormat Date&Time 'Check In-Out' TimesGroup by $participantId$w. SUM Aggregation Method for Balances(1011 unique citizens)Calculate $participant_spent$ (Balances Difference)Calculate Time Interval$time$Include: Purpose == 'Eating'1) Table of top 10 participants spending the highest amount of money on eating.2) Participants money spent vs eating 'time spent' linear correlation w. r2 adjustment == 0.819 CSV Reader String to Date&Time GroupBy Math Formula Date&TimeDifference Row Filter Challenge 21Dashboard Just KNIME It! - Challenge 21: Eating Out Results Dashboard: Data: Challenge21Provided Data eating_out.csvFormat Date&Time 'Check In-Out' TimesGroup by $participantId$w. SUM Aggregation Method for Balances(1011 unique citizens)Calculate $participant_spent$ (Balances Difference)Calculate Time Interval$time$Include: Purpose == 'Eating'1) Table of top 10 participants spending the highest amount of money on eating.2) Participants money spent vs eating 'time spent' linear correlation w. r2 adjustment == 0.819 CSV Reader String to Date&Time GroupBy Math Formula Date&TimeDifference Row Filter Challenge 21Dashboard

Nodes

Extensions

Links