Hello,
Since it is not possible to create a graph from two different data tables in graph builder, I updated one data table with the data from a second data table:
I can now create the graph I need (below). The problem is the following:
I would like to apply data filter only on the data from the first data table, without influencing the added data from the second data table.
Meaning in the graph below, I would like to filter claimed quantity (Y axis left) by customer, while keeping the background graph (Total volume) the same unfiltered.
What is the best way to achieve this result?
I would definitely try to figure some other way to do this (maybe with background image or by drawn shape) but this can be done with a formula and by adding extra rows to data so all Customers have at least something on every date.
See attached datatable.
