Hello QV Experts,
I have a line chart that shows count of Assets (Y axis) per Calendar Year (X axis). In the dashboard there is a list box for field Calendar Year.
When I select a value in Calendar Year list box (eg: 2013) the line chart gets updated such that it only shows 2013 in x axis. I know this is expected however a line chart with just one dimension value in X axis is not quite meaningful.
What I am trying to achieve is this:-
When a user selects a year in Calendar Year list box (eg: 2010) then I want the line chart to show 3 values in X axis: selectedyear-1 , selectedyear and selectedyear +1 (eg: when 2010 is selected in Calendar Year list box, the x axis of line chart should plot for: 2009, 2010 and 2011)
I am trying to get this done using calculated dimension with IF statements but no luck so far.
Ideas?
Thanks
Nakul
