Full accumulation with month dimension: line extends even though I have no data
I am creating an accumulated graph, showing only the current year, with actual figures (green), budget (pink) and last year's actuals (blue). I have one dimension (month) and three expressions with full accumulation, in which I use set analysis to "lock" year to the current.
As you see in the image, the green line continues over the whole year even though I only have data for january. I want the green line to be discontinued at the latest month for which I have data for actual figures (meaning that I, for example, only want a green dot right now in January). I have tried "suppressing zero values" and similiar options. Anyone know how I can accomplish this?
Re: Full accumulation with month dimension: line extends even though I have no data
Thanks Mario, an interesting read. I tried to hide the line after the current month by making it thinner and changing color to the background color, but the result was not great. Especially when I made selections in the date dimension.
I'm still looking for a more stable and permanent solution.