Multi-diagram - how to make a formula to not be displayed for (TODAY)?

[datanibbler]

Hi,

I have a multi-diagram with a quota that's represented by a line. The tricky thing is, there is no current data for (TODAY), so the quota seems to be 100% for today, but it isn't...

Is there any way to make the formula to be displayed only up to (Yesterday)?

I don't want to mess with the dimensions - there should be six days displayed from Monday on, with or without data. Making the background_color WHITE() is not a solution, either as that would cut right through the columns and would look a bit weird.

Can anyone give me a hint on how to do this?

Thanks a lot!

Best regards,

[jonathandienst · Accepted solution]

Hi

Add a condition to the expressions to exclude today. Something like this:

     Sum({<Date -= {"$(=Today())"}>} Sales)

(assuming your date field is called Date and is a date only (now time portion) and is formatted in your models default date format)

Hope that helps

Jonathan

[datanibbler]

Hi Jonathan,

many thanks!