Populating dimension values based on the selection

[Anonymous]

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

[Clever_Anjos · Accepted solution]

Please check if fits your needs

[Anonymous]

works like a charm! Thank you Anjos.