I am currently trying to calculate the average or mean of the calender weeks for each quarter of a specific year.
This would be an example of my data:
Does anyone know how to possibly solve this issue? I was also wondering what to do if a year has more or less than 52 weeks ? How would you specifiy this?
Thank you very much for your support!
Welcome to KNIME Community Forum!
I suggest for these kind of logic calculations to have a local reference file that would suggest definition/logic. In your case it would be a file containing weeks (in format you written above yyyy/week) in one column and in other information to which quarter they belong to. Best is to do this manually as you should know your business logic best.
Following above logic I have created an example workflow and here is a print screen of it:
After you read both data into KNIME (files are in data folder within workspace) you pretty much join them and then using GroupBy node calculate mean
Take a look at attached workflow and if any questions feel free to ask.
2019_05_03_Week_Mean_in_Quarter.knwf (18.7 KB)
This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.