Icon

percentiles_​example

Add a cumulative sum of QTY per row per group Identifying the pernctiles Joining and renaming Add a cumulative sum of QTY per row per group Identifying the pernctiles Joining and renaming First calculation of percentiles on first defined group within thedata Second calculation of percentiles on second defined group withinthe data Third calculation of percentiles on third defined group within thedata Fourth calculation of percentiles on fourth defined group within thedata ... ... ... ... ... ... Node 2464Add the 'value' fieldfrom the row that has beenidentified as the 50 PercentileNode 2466Calc. which row is closest to50%Select per groupthe line that is closestto the 75%Calc. which row is closest to75%Node 2470Add the 'value' fieldfrom the row that has beenidentified as the 75 PercentileSelect per groupthe line that is closestto the 50%Select per groupthe line that is closestto the 25%Rank the data on the value of which thepercentiles need tobe identifiedsAdd the 'value' fieldfrom the row that has beenidentified as the 25 Percentilecalculate within eachgroup how much the QTY on row level is compared to the total QTY Node 2478Node 2479Node 2480Calc. which row is closest to25%join the calculated sumfrom previous node to thedefined groupDefine grouping onwhich percentile calc.need to be executed+ calculated the totalsum of volume for this groupNode 2484Node 2485Node 2486Node 2505Node 2509Select per groupthe line that is closestto the 75%Node 2511calculate within eachgroup how much the QTY on row level is compared to the total QTY Node 2513Add the 'value' fieldfrom the row that has beenidentified as the 25 PercentileSelect per groupthe line that is closestto the 25%Node 2516Calc. which row is closest to75%Select per groupthe line that is closestto the 50%Rank the data on the value of which thepercentiles need tobe identifiedsNode 2520Calc. which row is closest to25%Node 2522Node 2523Add the 'value' fieldfrom the row that has beenidentified as the 50 PercentileDefine grouping onwhich percentile calc.need to be executed+ calculated the totalsum of volume for this groupjoin the calculated sumfrom previous node to thedefined groupNode 2527Add the 'value' fieldfrom the row that has beenidentified as the 75 PercentileNode 2529Calc. which row is closest to50% Moving Aggregation Joiner Column Rename Math Formula GroupBy Math Formula Group Loop Start Joiner GroupBy GroupBy Rank Joiner Math Formula Loop End Column Rename Joiner Math Formula Joiner GroupBy Joiner Table Creator Column Filter Concatenate Column Resorter GroupBy Joiner Math Formula Group Loop Start Joiner GroupBy Column Filter Math Formula GroupBy Rank Column Rename Math Formula Joiner Moving Aggregation Joiner GroupBy Joiner Column Rename Joiner Loop End Math Formula Add a cumulative sum of QTY per row per group Identifying the pernctiles Joining and renaming Add a cumulative sum of QTY per row per group Identifying the pernctiles Joining and renaming First calculation of percentiles on first defined group within thedata Second calculation of percentiles on second defined group withinthe data Third calculation of percentiles on third defined group within thedata Fourth calculation of percentiles on fourth defined group within thedata ... ... ... ... ... ... Node 2464Add the 'value' fieldfrom the row that has beenidentified as the 50 PercentileNode 2466Calc. which row is closest to50%Select per groupthe line that is closestto the 75%Calc. which row is closest to75%Node 2470Add the 'value' fieldfrom the row that has beenidentified as the 75 PercentileSelect per groupthe line that is closestto the 50%Select per groupthe line that is closestto the 25%Rank the data on the value of which thepercentiles need tobe identifiedsAdd the 'value' fieldfrom the row that has beenidentified as the 25 Percentilecalculate within eachgroup how much the QTY on row level is compared to the total QTY Node 2478Node 2479Node 2480Calc. which row is closest to25%join the calculated sumfrom previous node to thedefined groupDefine grouping onwhich percentile calc.need to be executed+ calculated the totalsum of volume for this groupNode 2484Node 2485Node 2486Node 2505Node 2509Select per groupthe line that is closestto the 75%Node 2511calculate within eachgroup how much the QTY on row level is compared to the total QTY Node 2513Add the 'value' fieldfrom the row that has beenidentified as the 25 PercentileSelect per groupthe line that is closestto the 25%Node 2516Calc. which row is closest to75%Select per groupthe line that is closestto the 50%Rank the data on the value of which thepercentiles need tobe identifiedsNode 2520Calc. which row is closest to25%Node 2522Node 2523Add the 'value' fieldfrom the row that has beenidentified as the 50 PercentileDefine grouping onwhich percentile calc.need to be executed+ calculated the totalsum of volume for this groupjoin the calculated sumfrom previous node to thedefined groupNode 2527Add the 'value' fieldfrom the row that has beenidentified as the 75 PercentileNode 2529Calc. which row is closest to50% Moving Aggregation Joiner Column Rename Math Formula GroupBy Math Formula Group Loop Start Joiner GroupBy GroupBy Rank Joiner Math Formula Loop End Column Rename Joiner Math Formula Joiner GroupBy Joiner Table Creator Column Filter Concatenate Column Resorter GroupBy Joiner Math Formula Group Loop Start Joiner GroupBy Column Filter Math Formula GroupBy Rank Column Rename Math Formula Joiner Moving Aggregation Joiner GroupBy Joiner Column Rename Joiner Loop End Math Formula

Nodes

Extensions

Links

Download

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

Download Workflow
Created by: A412973
Created at: 2020-02-19
On NodePit since: 2022-02-06
Last update: 2024-04-27
Created with KNIME version: v4.1.0

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

Try NodePit Runner!