Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to display the current year-date graph data This is the code that shows the unmodified graph
And the picture below is what I want, framed in red
Displaying results with a mixed granularity is possible with a "classical" dimension but not overlapping values like the months and the YTD of 2023 are. A way to create such objects may be not to use a (calculated) dimension else n expressions (for each bar one) by labeling them appropriate as well as the needed set analysis conditions. Even by 15 expressions (3 years + 12 months) the efforts are moderate because the most could be done per copy & paste and just the labels and conditions needs an adjustment.
If it's not a single view else such logic is wanted for multiple views it would be better to transfer the logic into the data-model and using nativ dimensions for such requirements. These dimensions could be created with a logic like: