How to built a simple hystogram in KNIME

[Guglielmo]

Some time simple things seems to be complicate, surely for my inexperience with KNIME.
I would build an hystogram with following data:

like this one:

I tried in KNIME in different way but in all cases it seems that there are problem to bin in some way the data!
Below the original excel data.
Sample Data.xlsx (11.4 KB)

[ArjenEX]

Hi @Guglielmo,

What have you tried exactly so far? I have imported your data set into KNIME, connected the Histogram node it and got the following result:

Is this something similar to what you are looking for? I used the following bin settings:

Also have a look on the KNIME Hub to find some inspiration for Histrograms, there are a lot of example workflows listed there where people have used it → Histogram – KNIME Hub

Hope this helps!

[Guglielmo]

Bah I’m not able to understand!!!
If i read the data directly from workflow (same data!!) the result is the following one:

If I export the data in excel and successively I read the data from excel file the result is same of yours with same node settigs!! Which is the difference? Data set is the same!! Why in the first case the workflow return anomalous results?!

[ArjenEX]

I don’t see any obvious that quickly. I’m afraid we’ll need to see your actual workflow to see what’s going on.

[HansS]

Hi @Guglielmo

Try to add the Domain Calculator before the Histogram node.
gr. Hans

[Guglielmo]

Hi Hans,
your solution works, but I don’t fully unerstand the exact function of this node, the data set before and after the node seem the same apart for the column specification. This is before the Domain Calculator:

and these are after the the suggested node:

which are the right uper e lower bound.
Thanks … I always learn something new!!