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. Idea is that Col formula wont be affected by the filter and by adding extra rows we can force those values to appear always