Need your help on a calculated field which i am currently stuck at.
I have sample data with plan and actual numbers.
My requirement is to show Actual and plan numbers separately for current quarter(Q2 2018).But historical quarters should show plan as actual as same numbers
(Actual and plan numbers should overlap for historical quarters and show a single line chart as shown below)
This calculation is not working for quarter_view but works for month_view. Please see the screenshot.
Please help me by changing my logic without altering any other calculation
Since the view is different depending on historical vs current differently, I suggest using two different views and a sheet selector. Here is a great article on building this sort of view: Sheet Selection on Steroids | VizPainter