Forum Discussion
Microsoft EmployeeBar Chart with Dynamic Floating Points Numbers on X-axis
Super UserPlease provide sanitized sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.
Microsoft EmployeeThanks 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.