average vs. last X values

[yakisoba]

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!

[Mathilda]

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!