creating 2 histogreams on 1 chart in advanced charts
I have a output data set that looks something like this;
where all the columns except "mac add" are intergers
I would like two (or more) columns on a common histogram (lets take rxsshb, and txsshb for this example) with bins at each descrete value, i.e. -50, -51, and so on. In other words I want the population of each value of rxsshb and txsshb to be visualized. in bars whose height is the population, and color is the column (rxsshb/txsshb), translucent appearing (so I can see overlay)
The funny thing if the basic chart does this "pretty good" by simply ctrl-left-click the second column name in the dialog, BUT....the bins seem to be "offset" a little.
When I try this in advanced, by assigning rxsshb to the domain dimension, and count(rxsshb) to the numerical axis, and setting everything appropriate to give me catagorized histogram, its perfect, but I cannot add the second set of values (txsshb) to the chart. Am I stuck using the basic chart for this?
Thanks in advance