Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
I need to create bar graph with missing dates and dates in nearby future, as shown in below example:
By Using current expression -> Sum({<Year = {"$(=Year(Today()))"},IDATE = {">=$(=Date(Monthstart(Today())))<=$(=Date(Monthend(Today())))"}>}Sales), i get the data till today only.
Thanks,
MAK.
check your IDATE as data till the end of the month or till today
in dimension check box allow null value
Thanks for your reply, I want to use expression in dimension.
ur expression is good just do this attach
Thanks, i know this... but still it does not show the date where data is not available