I'm creating a trend chart with 3 series: a [3*stddev] line, a [2*stddev] line, and a [count] line. I've placed my date dimension on columns and measure values on rows. I added the 3 measures to the measure values box and colored the 3 lines by measure names. I wanted to add a trend line and average line to the chart, but doing so gives me 3 trend lines for all 3 measures and 1 average line for all 3 measures. I wanted to display an average line and trend line for ONLY the count line. How can I do this?
Please attach some Workbook. Otherwise, use One Measure using Dual Axis and Create Trend and Average for that.