Join us this week to tackle a sales comparison problem and learn more about temporal data visualization 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.
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. 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! Tell us all about it here .
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:
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:
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 .
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
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.
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.
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.
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.