Forum Discussion
Bar Chart with Dynamic Floating Points Numbers on X-axis
Thanks, Ibendlin. I used the terminology wrong, I actually want a column chart. i.e. the bin index on the x-axis, and the counts as vertical heights.
However, I did try using a bar chart, and that visualization also wouldn't let me drag my bin center measure to the x-axis.
Please provide sanitized sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.Thanks for looking at this, Idendlin! Some sample data:
Seg1 Seg2 Val A X 5 B X 3050 B X 3080 C Y 4 C Y 4.2 C Y 4.2 C Y 4.6 C Y 7.7 C Y 9.8 C Y 10 I want to be able to select filters, and a number of bins (from 1 to 50), and then dynamically calculate bins and their count, based on those parameters.
For example, suppose the user selects Seg1=C, Seg2=Y, and numBins=4. The values now range from 4 to 10, so we divide the range [4,10] into four equal-sized bins, and calculate the center and then count how many values of Val lie within each.
bin_lower bin_upper binCenter binCount 4 5.5 4.75 4 5.5 7 6.25 0 7 8.5 7.75 1 8.5 10 9.25 2 If we had instead selected numBins=3, we would divide [4,10] into three equal-sized bins, as follows:
bin_lower bin_upper binCenter binCount 4 6 5 4 6 8 7 1 8 10 9 2 And if we had selected Seg1=B, Seg2=unfilitered, numBins=3, we would divide [3050,3080] into 3 equal-sized bins:
bin_lower bin_upper binCenter binCount 3050 3060 3055 1 3060 3070 3065 0 3070 3080 3075 1 I've already written the measured to dynamically calculate binCenter and binCount, and I can show them in a table or scatter plot. Just not in a column chart.
I have 10^7 different values of Val, and so after the user selects the filters and the number of bins, there are over 10^18 possible values of binCenter, so I can't pre-compute all the possibilities, I have to calculate them dynamically.
Idendlin, just wanted to check in to see if you (or anyone else, of course) had any ideas on this.
