Imagine you have sales data on the right y axis in an area plot and you have on the left area plot the claims occuring over time.
You want to see the sales data over the whole period of time you have in the data table but filter the claims based of e.g. supplier, claim reason, product, and may some more filters. The filter will adjust also the sales data.
Besides manually replicating the data on all filter categories (which could be done for one filter but not usable for many filters), is there a way to achieve this?
I also tested with copy frame content, but the filter refreshes the graph builder and loses the background as soon you filter. Guess it will not be checked for and therefore lost. With a background image and locking the size it might be possible to get close to it, but if new data arrives it is not feasible to redo images to change the background and it is not for sure that the scaling would align with the dates on the x-axis.
Thanks for suggestions or solutions. For simplicity I made up a file to illustrate the behavior with the filter. Run the script in the data table and then filter. The sales data in light blue should not change, just the bars of the claims should change and appear/disapear based on filters.
@XanGregg
