Good Afternoon,
I am needing assistance with making a segment on my line graph dynamic based on the applied filters. Currently, I have a segment that sums the total spend by paid ad sources. However, when I apply filters for different sources the total segment number remains unchanged. Ideally, I would like this segment to reflect the total spend of the filtered sources.
For example, the initial graph displays various sources with a total segment shown in black. (Screenshot provided.) Suppose the total segment indicates $400,000 on 6/9, and the individual sources add up to this amount. If I filter to only include Amazon and Facebook, I want the total segment to update and reflect the combined total spend of those two sources, instead of maintaining the original $400,000.
Similar to how a nested bar graph works. Is there a chart property or setting I might be overlooking that would enable this dynamic update based on the filters applied?