Skip to Content

Returning NULL values in a table based on "buckets" defined in a variable

Hi again all,

As simply as I can put it, I have created a table which lists "bucket" values based on what I have defined in a variable (see screenshot attached). The issue I'm trying to overcome is that I want the bucket values that have returned NULL to still be listed in the table with a value of 0 next to it. For example, the bucket "+9-10" (as per the screenshot attached) has returned a null value so it isn't listed in the table, my goal is that I'd still like it to be displayed along with the other NULL buckets with a value of 0. I want to do this as I'm trying to display a graph next to the table which will always display all of the buckets in order regardless of their value. For reference, the dimension [D] is a measure of days difference between two other dimensions in the universe. The environment I'm using is WEBI 4.1.

I can't quite get my head around what exactly I would need to do in this scenario. Any help would be greatly appreciated.

Many thanks,

Nick

Capture.PNG (60.1 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Jul 12, 2016 at 11:50 AM

    have you tried with checking "Avoid duplicate row aggregation" checkbox under the right click ->Format table?

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 19, 2016 at 07:52 AM

    Hi everyone. Apologies for bumping but I thought I'd give this one last try on the front page as I still haven't found a solution.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.