Compare hours of day with another variable

Hello! Very new to knime and just getting the hang of it, just wanted to ask something. So I have a data set that contains the year, month, day, hours as 4 different variables. It starts at 2010 Jan 1 0h and ends after exactly 2 years. Theres also another variable called PM2.5(Haze) levels. How do I compare the average haze levels to the hour of the day? I want to display my data in such that I know when these levels are at the highest, maybe at the 12th houur or the 1st hour of the day. How can I do this? I was able to extract the day of the week though and compare it to the average haze levels

Hi @FiidisksDiduui, welcome to the forum.

The first thing that comes to mind is using the GroupBy node: group by your hour column, and aggregate your haze level column using average.

1 Like

It worked. Thanks for the help! @elsamuel

@elsamuel is there a way I can present this information in like a bar graph? Like each hour has a bar to represent its average pm2.5 levels?

Have you already tried any of the Bar Chart nodes?

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