• 0
Login to follow this  
yakisoba

average vs. last X values

Question

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!

Share this post


Link to post
Share on other sites

1 answer to this question

  • 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!

 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

Login to follow this