Skip to Content
avatar image
Former Member

How to define fixed aging bucket in WEBI variable

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • May 10, 2017 at 06:11 PM

    Hi,

    Verify the table properties

    Add comment
    10|10000 characters needed characters exceeded