histogram -show string categories on Xaxis

KNIME Analytics Platform
#1

I have a simple data set like this one

ID, Incidents,Date, State

1,23,032012,TX

2,56,042013,TX

3,2,052012,MA

5,54,062012,CA

6,23,122012,CA

When I try creating hist plot it does not give me option to select x-axis variable as 'State' which is string (just give Int and Double variables as options in drop down)

The results histogram should be:

x-axis: TX CA MA ....

y-axis (row counts) : 2 2 1 

How do I do this ??

#2

Which kind of 'Histogram' node are you using? In the 'Histogram' node in the 'Views' section you would typically configure the 'Binning column' as 'State' (i.e. the x-axis) and then select 'Row count' as aggregation method within the node's view (i.e. the y-axis).

Philipp

#3

Thanks Phillip I got it working.