Jump to content
  • 0

average vs. last X values



1 answer to this question

Recommended Posts

  • 0
17 hours ago, yakisoba said:

Hi Guys,


Is it possible in Caspio to display my last 5 performances and compare it to my average? e.g. a chart showing the points I scored in the last 5 basketball games comparing it to my season average. Is this possible?


Thank you!

Hi, Yes, it's possible. You need to use combined chart and report datapage.

Sort fields by performance field and return only 5 records, add a calculated field and use the sql query like:

select avg(point_performance) from table name where user_id=target.[@field:user_id]

The calculated field should return the average value.

After that select combination charts and add two values there:

value1 - columns - chart type use performance field 

value2 - line - chart type - use calculated field 

If you need to hide report and display only chart, you may use solution described here

Hope that helps!


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.

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.

  • Create New...