Display of cumulative results based on a selection
I'm a bit stuck with one of my apps:
I've got 2 graphs, one with the sales per week, and beside one with the cumulative results of the first one.
Easy and correct for the whole periode, but to ease the reading of the graph, I'd like to display the final 30 weeks (30 is an example).
So it works properly for the week / week graph, but the cumulative one is only calculating the cumulative results for the last 30 weeks, without taking into account the data of the weeks before the selection.
So I'd like just to make a kind of zoom to read more easily the graph, with keeping the results of the cumulative option based on the whole period.
Re: Display of cumulative results based on a selection
did you find a kind of solution ?
I'm wondering if it is possible to zoom in a line chart for istance a part of it manteining as starting point of zoomed new chart the cumulated value present on original chart. I mean without loosing it and starting as usual from 0 first value.