Solutions to "Just KNIME It!" Challenge 03 - Season 2

:boom: New Wednesday, new challenge! :boom:

Join us this week to tackle a sales :moneybag: comparison problem and learn more about temporal data visualization :bar_chart: and KNIME components!

Here is the challenge. Let’s use this thread to post our solutions to it, which should be uploaded to your public KNIME Hub spaces with tag JKISeason2-3.

:sos: Need help with tags? To add tag JKISeason2-3 to your workflow, go to the description panel on the right in KNIME Analytics Platform, click the pencil to edit it, and you will see the option for adding tags right there. :slight_smile: Let us know if you have any problems!

And as always, if you have an idea for a challenge we’d love to hear it! :heart_eyes: Tell us all about it here .

3 Likes

Hello knimers,
This is my solution to the Challenge 3, it’s quite straight forward. I took the chance for exercising with R script within the chart visualizations:

BR

6 Likes

Hi @gonhaddock

Thanks for posting your solution. Very nice workflow based on R !

Just a short comment which may help others to run your workflow. I found the following problem when running it for the first time or when refreshing the generated web page:

This happened because the ‘lubridate’ library was missing from my R installation:

image

The instructions to install ‘lubridate’ found at the following web page solved the problem:

Hope this information helps others to enjoy your workflow solution :wink:

Best
Ael

2 Likes

Hi @aworker
Thank you for the tip (‘ymd’ is indeed a ‘lubridate’ function); I will work on the aesthetics and literature tonight. I will add the list of the necessary R packages in the component footer .

install.packages("lubridate")
install.packages("ggplot2")

Besides, I’m thinking to upgrade the challenge with a second twin component, purely based in knime chart nodes. I guess is doable. However i was in hurry because of the chance for posting first at once :sweat_smile:

BR

2 Likes

Hi all,

here is my solution:

1 Like

Here’s my solution. A month over month sales change line chart and a table for sales change between any two months. Made no attempt to hard wire a 12 month limit for the latter. The input haa a warning about the 12 month limit.

1 Like

HI. This is my solution. Maybe it’s a quite complicated flow, but it’s seems working fine…About the 12 month “problem”…I compared the two “period” date (chosen by the user) and I used a Case Switch to make a massage warning appear.

1 Like

Hi crazy KNIMErs

Here is my solution.
Just Knime It 2- 3

I have explained it in Spanish to expose it later in our Group Study :es:

2 Likes

Aquí está mi solución para JKISeason2-3: Comparing Monthly Sales

Fue un reto en cual explore mas a profundidad los widget y como hacer el refrescamiento de las tablas y graficos.

Exitos a todas.

2 Likes

Hi !
I didn’t know that KNIME was so useful.

1 Like

Hello KNIMErs
I’ve just updated the workflow taking advantage of the previous version.

Some changes had been implemented since the first posted version:

  • Simplified view with a unique chart (only ggplot2 R package) and table of values.
  • Parameter Analysis included in main view.
  • As requested in challenge description, month selector is available, aiming to compare with previous one. There is still the possibility of ALL Months view.

There is still pending a chart with KNIME ‘Bar Chart’ node…

BR

2 Likes

Hi all,
This is my solution.

2 Likes

Glad to hear that you found it useful yay! :slight_smile:

2 Likes

Here is my solution. It was quite interesting to create an interactive dashboard, I think this is the first time I used Refresh Widget node.

2 Likes

Hi all, here is my solution.
I couldn’t find out why Value Selection Widget for a prior month shows a drop down list inlcuding all the data, although it refers only to 12 months based on the first selection of a month…
Anway, the bar chart doesn’t show a prior month if more than 12 months before the selected month.

2 Likes

I had the same problem. You can use Domain Calculator in order to update the table specifications, hence the available options in the widget.

5 Likes

Hi @Artem , thank you so much, with Domain Calculator node, now the workflow works as I expected. Thank you for your kind input! Appreciated.

3 Likes

My posting for submission to challenge -3 .
Used string approach to select the period as other dates are missing .


4 Likes

Hello, all community,

This is my solution for the challenge:

  • The flow permit select any day of the month in the specific data period
  • The flow truncates the select month to the first date in the select month
  • It is possible to select more than one month to compare, versus the selected month on the calendar
  • When no month to compare was selected, only the show the data from the month selected on the calendar
  • I included the graphs of the:
    • Historical sales
    • Anual sales by month

This is the report when are no select months to compare:



This is the report when selecting months to compare:



5 Likes

Hi all,
This is my solution.

1 Like