Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
BrianDH
Creator II
Creator II

How do I Create a Trend Line in a Combo Chart or Bar Chart?

I have a chart (Dim = V_ENTERED_DT) (Mes = V_GROSS_AMT) (Alt-Mes =  linest_m(total aggr(if(sum(V_GROSS_AMT),sum(V_GROSS_AMT)),V_ENTERED_DT),V_ENTERED_DT)*  only({1}V_ENTERED_DT)+linest_b(total aggr(if(sum(V_GROSS_AMT),sum(V_GROSS_AMT)),V_ENTERED_DT),V_ENTERED_DT))

Secondary axis set to line.

 

I get no errors, i also get no lines.   Not sure where to go from here.

 

Labels (2)
1 Solution

Accepted Solutions
BrianDH
Creator II
Creator II
Author

Solved:  First create a Line Chart, then after you see your trend line convert to a Combo Chart

https://youtu.be/dBrKlORa1Tc

 

View solution in original post

1 Reply
BrianDH
Creator II
Creator II
Author

Solved:  First create a Line Chart, then after you see your trend line convert to a Combo Chart

https://youtu.be/dBrKlORa1Tc