Question 1 of 30
In a Salesforce environment, a company is analyzing its customer data stored in various objects. They have a custom object called \"Customer Feedback\" that includes fields for \"Rating\" (a number from 1 to 5), \"Comments\" (text), and \"Feedback Date\" (date). The company wants to generate a report that summarizes the average rating per month and includes the total number of feedback entries for each month. If the company has collected feedback over a period of six months, how should they structure their report to ensure that it accurately reflects the data types and provides meaningful insights?
Group the data by "Feedback Date" month, calculate the average of the "Rating" field, and count the number of entries for each month.
List all entries in a single table without grouping, showing the "Rating," "Comments," and "Feedback Date" for each entry.
Create a pie chart representing the distribution of ratings without considering the time frame of the feedback.
Use a bar chart to display the total number of comments received each month without calculating the average rating.

Preparing for SalesForce Certified AI Associate Salesforce Certified AI Associate? Now land the interview.

73% of qualified candidates get rejected because of weak resumes. Build an ATS-optimized, recruiter-ready resume in under 5 minutes - free to start.

Build My Resume Free