CarlosMeneses Posted October 23, 2019 Report Share Posted October 23, 2019 Hello, I am trying to obtain a 3 and 5 year average price line for my combined line chart and report graphI have a data graph with price/lb being shown, these are filtered by years.I want to keep the values I already have for each year selected and I want a new one with the last 3 and 5 year price average on the same graph.The datapage is "Commodity $/lb":https://c1acp437.caspio.com/dp/e3508000c0016ad1f9354a93b00c Quote Link to comment Share on other sites More sharing options...
0 gillyr7 Posted January 29, 2020 Report Share Posted January 29, 2020 Hello, It looks like your datapage is no longer deployed so I cannot see anything... You should be able to show these values on the chart if you create a calculated field in the tabular report with what you need. Based on what it looks like, you might need to use SQL in your calculated field to get the 3/5 year averages. When you get to your chart, you can select the new calculated field in the chart. Quote Link to comment Share on other sites More sharing options...
Question
CarlosMeneses
Hello, I am trying to obtain a 3 and 5 year average price line for my combined line chart and report graph
I have a data graph with price/lb being shown, these are filtered by years.
I want to keep the values I already have for each year selected and I want a new one with the last 3 and 5 year price average on the same graph.
The datapage is "Commodity $/lb":
https://c1acp437.caspio.com/dp/e3508000c0016ad1f9354a93b00c
Link to comment
Share on other sites
1 answer to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.