Calculating max/min difference in context
Hi there i want to reduce a range of time series lines into a single area spanning the max and min values in each time point. I've had a go with creating an Fx but i suspect i need a context calculation? the filters are cascaded to make the chart and those will be changed regularly by the user to change the chart content.
Here's an image of the line chart, id like to be able to create a version where single area fills the hatched area please. Thanks :)
4 replies
-
Perhaps try the stream area chart or a waterfall chart.
-
Thanks Avi, the stream comes close is look but what i need to do is calculate the max and min for each point on the x, and display the breadth of data in a single area, i don't need to stack them.
-
Hi again, ok so I've used n-of-n to get the max value in each date, and the geography that it belongs to. I thought i could total each column to get the max value at each date point, and that could drive the top of the area chart, another n-of-n would create the minimum of the area.
But i cant use "total" with n-of-n, and this seems a very long winded way to get a "max" and "min" value out of the data? -
Ok think I've sorted this, noting here for benefit of others or in case it turns out to be a dead end. I've made two formula calculations and they appear to be working within the context of the vis which is cool, next step will be overlaying a comparator line but maybe that's another thread.
just need to change the purple area to white and it's done.
