function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Andrew EversleyAndrew Eversley 

Using Formula Fields Challenge - The 'Matrix of Leads' report does not have the Rating field as a column grouping.

Hello Salesforce Team,
I was just revisiting an old challenge that I haven't completed and came upon this error and wanted to see if anyone came up with a solution regarding it. It is the "Using Formula Fields Challenge"

Error Received  - The 'Matrix of Leads' report does not have the Rating field as a column grouping.

Please Advise. Thanx
Amit Chaudhary 8Amit Chaudhary 8
NOTE:- Column grouping should be by Rating
The report should be matrix format, show 'My Leads', and the date range should be for All Time
Row grouping should be by Lead Source

Please share your screen shot
 
Andrew EversleyAndrew Eversley
Amit, attached is my screen shot of the report below:
Criteria is detailed below:
Make a report that shows you a count of leads grouped by source and rating.Name the report 'Matrix of Leads' and save it to the 'Unfiled Public Reports' folder.
The new report should be of type Leads.
The report should be matrix format, show 'My Leads', and the date range should be for All Time.
Column grouping should be by Rating.
Row grouping should be by Lead Source.
We won't test for this, but hide details to simplify display.​


Matrix of Leads Report
Amit Chaudhary 8Amit Chaudhary 8
Hi Andrew Eversley,

It look like you created the summery report you need to create the matrix report. 
--> Column grouping should be by Rating
--> Row grouping should be by Lead Source

Please let us know if this will help u

Thanks
Amit Chaudhary
Jamie Morris 5Jamie Morris 5
Hi, 

Just wanted to jump on this as it is recent, I am doing the same challange, but am getting the error that my report is not in a matrix format, despite the fact it is. It is also saved in unfiled public reports. Screenshots below, any suggestions?

User-added image

 
Andrew EversleyAndrew Eversley
Thanx Amit, I will redo the challenge later, my issue it seems wasn't the report type but the Ratings field as a column grouping. I will redo it later on and see the results. Will let you guys know the outcome.
Sandeep BhanotSandeep Bhanot
Jamie - have you saved the report before clicking on the 'Check Challenge' button?
Ajit Shukla 15Ajit Shukla 15
Same Issue Andrew !!
Ashwin MallikarjunaAshwin Mallikarjuna
Hi,

Please add Annual Revenue to Column Grouping and then Rating. 

Because it accepts only summarizable fields.

Hope this helps.

User-added image


Thanks,
Ashwin
Hunter WeatherlyHunter Weatherly
That worked for me Ashwin, thanks for the suggestion.

It also works with adding rating and then annual revenue

matrix of leads report