what if slider with data shift

[rdsuperlike]

I want to get the below data to shift to +- (1 to 5 )days through a wat if slider

Date       total

1/1/15   100

1/2/15    35

1/3/15     45

1/4/15    36

1/5/15    67

1/6/15    37

1/7/15     58

If i move by +1 days

OUTPUT should be

Date       total

1/1/15     -

1/2/15    100

1/3/15     35

1/4/15    45

1/5/15    36

1/6/15    67

1/7/15     37

1/8/15   58

Any approach is appreciated?

I used above. But couldnt get the corner cases.

eg: 1/8/15 58

[sicilianif]

I would think that it would be something like this:

set up vDays variable linked to slider.

Change dimension in chart to be a calculation: Date([Date Field]+vDays)

[rdsuperlike]

I attached my qvw to the main question.

I tried incorporating ur idea..but it doesnt work. It shifts the whole set by 1 day and the corner case is still lost.

[sicilianif]

Not sure what you mean by lost. In your example, the 2nd chart's data looks fine (all dates are shifted by slider).

[rdsuperlike]

I want 58 to come up adjacent to 1/9. But instead 38 comes bcz now the new set starts from 1/2 to 1/9 instead of 1/1 to 1/8. see 2nd staright table