Apex Code Development You need to sign in to do that
Don't have an account?
Clement George Identify most recent 20 records, calculate average of lowest 8
Hi all:
I am trying to build a handicapping system for my clay target club. The requirement is to average the best 8 scores of everyone's last 20. There are 10 different games.
The custom objects I've built are:
shooter__c - the individual's name + associated data
games__c - a listing of the 10 different games
rounds__c - looks up shooter and games, plus a field for their score. Diff__c is a formula field that subtracts their score from the perfect score.
For each individual, for each game, I would like to average the diff__c on the rounds__c object. I am currently doing this by manually flagging the most recent 20 and the subset of the best 8 and then filtering on those flags = y on my report.
I have two flags on the rounds__c object:
Most_recent_record__c which should be flagged if it is one of the twently most recent records as determined by the date__c field
Lowest_8__c which should be flagged if that score is one of the lowest 8 from the most recent 20.
I'm not married to Apex updating those flags if there is another way, but I thought a trigger might be the best way about this.
Thank you in advance!
I am trying to build a handicapping system for my clay target club. The requirement is to average the best 8 scores of everyone's last 20. There are 10 different games.
The custom objects I've built are:
shooter__c - the individual's name + associated data
games__c - a listing of the 10 different games
rounds__c - looks up shooter and games, plus a field for their score. Diff__c is a formula field that subtracts their score from the perfect score.
For each individual, for each game, I would like to average the diff__c on the rounds__c object. I am currently doing this by manually flagging the most recent 20 and the subset of the best 8 and then filtering on those flags = y on my report.
I have two flags on the rounds__c object:
Most_recent_record__c which should be flagged if it is one of the twently most recent records as determined by the date__c field
Lowest_8__c which should be flagged if that score is one of the lowest 8 from the most recent 20.
I'm not married to Apex updating those flags if there is another way, but I thought a trigger might be the best way about this.
Thank you in advance!
You can use the Query like
"SELECT id FROM rounds__c order by CreatedDate DESC LIMIT 20" this query will help you in finding the Latest 20 record or
if you need the Last 20 record of each individual then you can use aggregate result query like
"SELECT id,shooter__c.Name FROM rounds__c ORDER BY CreatedDate DESC GROUP BY shooter__c. Name"
then after getting the latest record you can calculate the average of the required field.
In case you find any other issue please mention.
If you find your Solution then mark this as the best answer.
Thanks and Regards
Suraj Tripathi
"SELECT id FROM rounds__c order by CreatedDate DESC LIMIT 20" this query will help you in finding the Latest 20 record or
if you need the Last 20 record of each individual then you can use aggregate result query like
"SELECT id,shooter__c.Name FROM rounds__c ORDER BY CreatedDate DESC GROUP BY shooter__c. Name"
then after getting the latest record you can calculate the average of the required field.
In case you find any other issue please mention.
If you find your Solution then mark this as the best answer.
Thanks and Regards - Hindi Me (https://www.niodemy.com/)