You need to sign in to do that
Don't have an account?
Kiran Kumar Gottula
Dispaly opportunity records in table , week wise
I want to display 2 weeks Opportunities data in the fallowing table.
How to display ....?
Please help me
Statistics This Week (opportunities) Previous Week (opportunities)
Total Amount(Sum of Amount ) 4000 4500
No of Opp (Count) 10 12
This SOQL will return the opportunity created in last week.
Hi,
I have no record for prev wekk in Databse. I am only writing for today.
You need to write 2 soqls for prev week only.First you run and see, today's Opp detail are right.
This is page
This is class:
Thank you
:
This is not an exact syntex, but query will be similar to something:
Select SUM(Amount) tAmount, Count(Id) counter from Opportunity Group By CalenderWeek(CreatedDate)