Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
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.
Not sure what you mean by lost. In your example, the 2nd chart's data looks fine (all dates are shifted by slider).
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