How to create a histogram with the year without the years adding up in other columns?

I’m using KNIME 4.7.2. In the project I have data with the year column and I would like to create a histogram or bar chart with the year columns. I created it, however, the number of records is always wrong and, depending on the adjustments of the parameters in the histogram node, or the number is added to the first column of the year or the last, has anyone gone through this or knows how to solve it?
Here are some images:
Image 1 - Example of the flow
Image 2- Result of the “Group By” node
Image 3- Result of the “Histogram” node
Image 4- Configuration of the “Group By” node

Image 1

Image 2

Image 3

Image 4

As seen in image 2, the histogram does not show all the years with their correct amounts, how to adjust this?

Hi, with this kind of data, it is best to use the Bar Chart node, since your groups/binning (i.e., the years) are already well defined. The Histogram node is better suited for continuous data that requires some binning to be performed before plotting.


@nan, thanks for the answer. In the option “Category Column”, it’s don’t shows the column year “Ano Tweet”. In the image I put my options.

The execution of this node is taking more than 15 minutes and to show the graph another 10 minutes and sometimes it does not generate anything on the graph. After many minutes it generates a graph, but I have no way of knowing if it is processing.



Hi @nan , I Got it! I changed the year column to String.

Thanks! :+1:t6:

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