Hi guys,
I have a marketing dataset including “Date” “channels” “clicks” and “Profit”. Due to the joiner logic，in the same date, the different channels have the same profit value but different clicks. I would like to make a new calculation to calculate the profit by the percentage of one-days clicks.
How can I calculate it by Knime?
Sincerely,
Kevin
Hi @Kevin723, welcome to KNIME Forum,
See this KNIME_project4.knwf (21.5 KB) . It uses a Group Loop (it loops every single day). And with the Math Formula (COL_SUM) , you can create a new distribution of the profit values).
gr. Hans
Hi Hans,
Really appreciate! It works as I expect! Really smart, thank you!
Kevin
Glad I could help, Happy KNIME-ing
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.