Forum Discussion

ianyyz's avatar
ianyyz
Helper I
3 years ago
Solved

two line graphs on chart

hello,

 

here is sample data 

 

https://docs.google.com/spreadsheets/d/155Sr_GxzghNS9LV6ThM6sT8igQ6o83qq/edit?usp=drivesdk&ouid=113270003913045553839&rtpof=true&sd=true

 

I have a slicer based on the metric of YYZ and integrated, yyz, and All are linked to YYZ via metric

 

Having three separate line graphs for each yyz, integrated, and All work perfectly...that is,whenever i change the metric via the slicer, all three graphs update perfectly

 

 

what i'm trying to do here is actually have Integrated and 'All' on the SAME line graph...so when I move the "Σ value" from the "All" table to the "secondary y-axis" (i even tried double stacking the "y-axis") of the "INTEGRATED" chart, the "all" line graph is just a straight line.

 

 

it looks like it's giving me the TOTAL of the metric spanning the time period , not the individual data points (e.g., let's say time period is from Jan to Mar and the revenue was $1,$2,,$3, respectively. the line graph for the "all" is showing $6 (1+2+3) straight line, not upwarding sloping as in $1, $2, $3)

  • SOLVED

     

    i had to make a common, separate dates table and made all the other tables refernce this