Setting up workflow with GroupBy

Hello,

I am working on a course project where I have to set up a workflow with GroupBy.
The task is the following:

But my data basis has no total number of orders. I just have an amount of 10.000 records.
How can I determine the number of orders to set up a calculation with average profit and campaign type.

The current workflow is the following:
image

Thank you for any suggestions.

Hi @Steph and welcome to the KNIME community forum,

Since it is your course project, I provide you with some hints so that you can complete the project on your own:

To find number of orders per X (the grouping column(s)), you need to “Count” the orders in each group.

To find the average of profit and activation per X (the grouping column(s)), you need the “Mean” of the profit and activation in each group.

You need one GroupBy node for each task.

I hope this would be helpful to you.

:blush:

2 Likes

Hi @Steph -

Welcome to the forum! What course is this for, if you don’t mind my asking?

1 Like

Hello @armingrudd
Thank you for your adviese. That helps me to understand better how to process with the task. I’m gonna try it with several individual GroupBy Nodes.
:slight_smile:

2 Likes

It’s a data analysis course using the knime software.

Steph I am doing the same assignment and can you help me in it. ?

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.