Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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
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
Hi Jonathan,
many thanks!