All values presentation

[#1]

Hi there,

i want in the attached application to have a table which will show the values for the selected day and 7 days before. Everything works fine when the dates have data but the day is missing when there are no although i have clear the Suppress Zero values flag. Any ideas?

[swuehl]

That's because you limit your data in your set expression also to certain values of CUST_BUS_STATUS_ID, so your working set only contains TempDates that are contained in table Table.

You can work around this by using an if-statement instead of the set expression for CUST_BUS_STATUS_ID, or remodel your fact table that it contains all combinations of TempDates and CUST_BUS_STATUS_ID.

[swuehl · Accepted solution]

There is another solution with a hidden expression that enables access to all dates.

[#4]

Hi swuehl,

thank you for your both correct solutions, do you suggest to work with one of them for better performance? If yes, which one? The second?

Regards,

Helen

[swuehl]

The solution with the if() statement should work in all charts, while the one with the hidden expression probably won't work in all charts and settings.

From a performance point of view, an if() statement will perform worse in most cases (even with the additional hidden  expression), but it's depending on your data if this is really the case in your setting and if it does really matter).

So it's up to your setting. Just give it a try.