Formulas Superbadge Unit|| Challenge 2|| Support Visibility and Decision Making for Service Team

#Data #trailheadchallenge #superbadge
#trailheadchallenge #superbadge #completesolution #Formulas Superbadge Unit
Watch Formulas Superbadge Unit|| Challenge 1|| Build Lead Score and Rating Fields here:
• Formulas Superbadge Un...
Visit Formulas Superbadge Unit Playlist here:
• Formulas Superbadge Unit
Challenge 2
Created a solution to Support Visibility and Decision Making for Service Team
-- Description --
I have created these videos for your guidance. So, kindly at least understand what is happening. If you have any issue in this video or in your solution, kindly mention in the comments or if you have done this differently, kindly give the tips in comments. Appreciate your help.
Formulas Superbadge Unit|| Challenge 2|| Support Visibility and Decision Making for Service Team

[@mariusbordeianu3404]

Any news about challenge 3? Thank you.

[@trailheadbrothers-bw9gz]

Hi @mariusbordeianu3404, It will be posted today. Keep an eye out.

[@liliangarcia9059]

@@trailheadbrothers-bw9gz I am taking issues with challenge 3: We can't find the 'Close Month' column with the expected settings in the 'Case Severity By Month Last Year' report. Make sure there's only one report in your org with the original title and it has a description.....
Not sure why I am not able to find the Close Month column

[@trailheadbrothers-bw9gz]

Hi @liliangarcia9059 , My challenge 3 video is ready for upload but I was tired yesterday due to my 9 hour job shift. Very Big apologies. Will do it today.
As for this issue, There can be many cases. I am gonna mention some common solutions below:
1 - Use the existing "Case Severity By Month Last Year" report in your salesforce org.
2 - Create a row level formula with title "Close Month" and description (Just write anything).
3 - Remove severity column and include Severity (Number) column.
4 - Group the report on row level formula field "Close Month".
That's it for now. Give me a day, I will upload the video today for challenge 3.
Thank you for your support.

[@liliangarcia9059]

@@trailheadbrothers-bw9gz Thanks for your time, I really appreciate

[@trailheadbrothers-bw9gz]

Hi @liliangarcia9059, Here is the link to Challenge 3 video : th-cam.com/video/nNhztnW0BEA/w-d-xo.html. Thank you for your continued support

[@Hamster_kombatis]

Can i have a video for challenge 3: Enhance Reporting with Business Logic Thank you!

[@trailheadbrothers-bw9gz]

Hi @GM-db8ci , Sure. I am working on this right now and will upload challenge 3 this weekend. Thank you for your support.

[@carlosmn95]

Part 3 would be awesome! I'm stucked with the Close Month column and this videos are so helpful!

[@trailheadbrothers-bw9gz]

Hi @@carlosmn95 , Thank you for your kind words. Post production for challenge 3 video is nearly complete. Will upload it this weekend. Keep an eye out.

[@Santivi]

@@carlosmn95 Hi Carlos, you just need to make a row level formula using this formula:
CASE(
MONTH(DATEVALUE(CLOSED_DATEONLY)),
1, "01 - January",
2, "02 - February",
3, "03 - March",
4, "04 - April",
5, "05 - May",
6, "06 - June",
7, "07 - July",
8, "08 - August",
9, "09 - September",
10, "10 -October",
11, "11 - November",
"12 - December"
)

[@carlosmn95]

@@Santivi Wow, I was doing it in 2 steps and a " - " on the middle... I don't know why I didn't think about it just like you just said. Thank you very much!