Ranges (intervals) in query

[Former Member]

Dear Experts,

There is a requirement to design a Query with Graph where I want to show on X-Axis the value range from zero to ten (0-10), then ten to twenty (10-20) and so on. The intervals are not constant for example, after 10-20, next interval could be 20-25, and then 25-30,....... And, the "Number of Records" (which is a key-figure) should be summarised within these above intervals.

Kindly care to share your invaluable thoughts on how to achieve this.

Thanks,

Shalini.

[Former Member]

What determines the variation in the intervals? Also, what do the intervals refer to? So you have X number of records in interval 0 - 10, but what does 0 - 10 mean?

For instance, do you mean that there is a difference between the "size" of the range (in terms of spread from minimum to maximum value) between different or columns...

OR

...do you mean that each time the query is run the range can change (e.g. report run today give 0 - 10, 10 - 20, etc., report run tomorrow gives 0 - 5, 5 - 10, 10 - 25, etc.)?

[Former Member]

Hi Khaled,

I have to build a graph where x axis represents interval values say 0-10, 10 20 so on and in y axis i have to show source percentage. To achieve this i have to first design in bex query.These intervals shuld summarise the number of cases done i.e., if number of cases done is 9 it shuld show "9" within the interval of 0-10 and so on. Source % means number of cases done divided by grand total. It will come in "y" Axis.

Hope i made my self clear

Thanks for your reply

Shalini