In my last post (Missing bars in bar Chart) I was wondering how I can add missing bars in a bar chart with a predefined bin size. i.e i want to plot the Count of y where y =(0,1,1.5,5,6) in a bar plot with bins 0-2, 2-4, 4-6 and i want to see the bin 2-4 with Count 0.
Now my next question: I want to have a more dynamical bar chart where i always see around 10 bars independent of the drilldown level ( or another Number depending on a user input, but i don't include this since probably not all of you have this add-on). To achive that i created the variables: vminy=min() and vmaxy=max().
In vN the desired number of bins are stored.
The Dimension has the form [bins for y dynamically] = class(y , ( $(vmaxy)-$(vminy) )/ $(vN) )
In the bar chart I plot [bins for y dynamically] and Count(y).
If I drill down much into y i see jumps between the boundaries of the bins.
I would like to add bins which show a count 0 betwwen. ( see Level2.png) I attache my testworkbook: test.qvf (and 2 png files to clarify my question
Yes it is really close! Some differences to my initial idea but this doesn't matter.
I think i will Change the rounding behaviour in the class function but this isn't to important.
One things still bugs me: If I select the bins 0<=x<93 and 1767<=x<1860 and drill down on them i end up with only 2 bars and the intermidiate bars are missing. If i drill down only on a single bar this doesn't happen.
if you select two non-consecutive bars, there are no values in the middle to build the classes from. Sorry, that's the downside of my approach. The dimension built on still relies on the selection of , and if you select values in two different groups, there are no values in the middle, and therefore no corresponding values in the middle.