3 questions on filters & components
Hello all, hope you’re having a great day.
Picture for attention/understanding mostly:
Within my flow, I would like to:
Filter the data by
Cluster (a group of country) and/or
Country
Date (year) and/or
Date (quarter) and/or
Date (month)
Some filter conditions above are interdependent (i.e. a Cluster will contain a set of countries)
Combine my filters and graphs in a component
I am trying to understand how “Nominal Row Filter Widget” works, however I am facing difficulties to:
Combine in a component nodes that are in different “position” in the flow. Ideally I’d like to have my filter conditions on top and the result below.
In the image above I had the items in the blue box as a component, I tried adding the Widgets but it didn’t work.
I am also exporting the data as excel which is why I placed my filters before the pivot (excel export not shown in image)
Manage interdependencies between filters. In my example, a Cluster will contain a set of countries and i’d like to avoid having to select both (one should feed the other). Likewise, if I select a year then I shouldn’t have to select the matching quarters or months.
For some reasons I haven’t figured out how the slider works (and many things in KNIME yet) so any help or pointers would be much appreciated.