Jump to content
  • 0

Combined Chart and Report - Chart Value


CarlosMeneses
 Share

Question

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

  • 0

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.

Link to comment
Share on other sites

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.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...