How to define fixed aging buckets in WEBI variable

[Former Member]

Hi All,

I have a requirement where i need to create fixed aging buckets even though the values dont exist in the report .

For example:

i have an object called "Aged days" now this has many values like 3,4,5,40,127 etc...

Now they want fixed aging buckets like "under10", "11-20","21-30"etc to display in one column and in the next column they want count of the days within each bucket like the example below.

Age Group Count

under 10 4

11-20 10

21-30 0

But the issue is in the object "aged days" there is no value between 20 and 30 so that row is not getting displayed.

I have created the following variable to create the age buckets

=If([Aged Days Fulfillment In Process] > 180; "180 +";If([Aged Days Fulfillment In Process] > 120; "121 - 180";If([Aged Days Fulfillment In Process] > 90; "91 - 120";If([Aged Days Fulfillment In Process] > 60; "61 - 90";If([Aged Days Fulfillment In Process] > 40; "41 - 60";If([Aged Days Fulfillment In Process] > 30; "31 - 40";If([Aged Days Fulfillment In Process] > 20; "21 - 30";If([Aged Days Fulfillment In Process] > 10; "11 - 20";"Under 10"))))))))

Please any help or suggestions is appreciated.