ptauk1 Posted April 17, 2012 Report Share Posted April 17, 2012 Is it possible for a search and report datapage to contain a field that calculates an average from another datapage/table? Quote Link to comment Share on other sites More sharing options...
0 plance Posted April 17, 2012 Report Share Posted April 17, 2012 Good question.. I'm interested in this answer as well ! - Paul Quote Link to comment Share on other sites More sharing options...
0 ShWolf Posted April 24, 2012 Report Share Posted April 24, 2012 Hi, Unfortunately, this is not possible when using standard Bridge functionality. You can try to create one more datapage with aggregations, deploy it in your host page, for example in div with style="display:none" and using javascript in the first datapage take needed values from the second hidden datapage. Quote Link to comment Share on other sites More sharing options...
0 LunaLovegood Posted October 15, 2018 Report Share Posted October 15, 2018 Hello @ptauk1, You can insert a Calculated Field in a Search and Report DP and use SQL Select statement to pull the average of a column of a different table. like, SELECT AVG(field_name) from Table_name — Luna — Quote Link to comment Share on other sites More sharing options...
0 NailDyanC Posted January 15, 2022 Report Share Posted January 15, 2022 Hi, just to add and update this post. For functions that you can use in your calculation or formulas, you may go directly to this link: https://howto.caspio.com/function-reference/ Quote Link to comment Share on other sites More sharing options...
0 cheonsa Posted January 24, 2022 Report Share Posted January 24, 2022 Just to add, you can also use Triggered action to calculate the average from different Table. You may check this link for details: https://howto.caspio.com/tables-and-views/triggered-actions/ Quote Link to comment Share on other sites More sharing options...
0 NailDyanC Posted January 29, 2022 Report Share Posted January 29, 2022 In addition to the trigger workaround, you may check this videos as well: Quote Link to comment Share on other sites More sharing options...
Question
ptauk1
Is it possible for a search and report datapage to contain a field that calculates an average from another datapage/table?
Link to comment
Share on other sites
6 answers 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.