Lightning Experience Reports & Dashboards Specialist Challenge Create Support Reports


Lightning Experience Reports & Dashboards Specialist Challenge Create Support Reports




Create Support Reports Challenge

Report Name:- Top Case Drivers by SolarBot Ownership

Object :- Cases

Folder Name :- SolarBot Support Reports

Group By:- 

SolarBot Ownership

  • Create Bucket Coloumn on SolarBot Ownership :- 
    • Field :- Number Of SolarBots
    • Bucket Name:- SolarBot Ownership
    • Range :-
    • Number Of SolarBots<=0 -> No SolarBots
    • 0<Number Of SolarBots<3 -> Some SolarBots
    • Number Of SolarBots>3 -> Several SolarBots
    • Tick :- Treat empty Number of SolarBots values in the report as zeros.
  • Sort:- Descending

Case Reason

  • Sort:- Ascending

Coloumns:-

  • Account Name
  • Subject

Select Details Rows And Deselect all checkbox

Filter:- Show Me-> All Cases, Opened Date-> All Time, Units-> Hours


Report Name:-SolarBot Status Averages

Report Type:- SolarBots and Status Data

Folder Name:- Status Reports

Group By:-

  • Status Date:-
    • Sort:- Ascending
    • Sort By:- Status Date
    • Group Date By:- Day

Coloumns:-

  • Kilowatt Hours

Summarize:- Average

  • Panel Temperature

Summarize:- Average

  • Percentage Obscured

Summarize:- Average


Deselect:- All checkbox

Filter:- Show Me-> All SolarBots, Created Date-> Current FQ

Comments

Post a Comment

Popular posts from this blog

Lightning Experience Reports & Dashboards Specialist Salesforce Superbadge - Challenge#2

Image
 Lightning Experience Reports & Dashboards Specialist Salesforce  Super badge - Challenge#2 Prerequisites Steps:- Step 1:-    Create a new trailhead playground. Step 2:- Go to Setup -> Object manager -> search & select "Opportunity" Object. Step 3:- Select field "Type" picklist -> add new picklist value " SolarBot " Step 4:- Install unmanaged package. Step 5:- Search for  SolarBots  app from app launcher -> click on " Data Import " tab and click on "import" button. Step 6:-Setup -> search public group -> click on New button -> create below public groups Executive Team Report and Dashboard Administrators Research and Development Team Sales Leadership Team Sales Team Support Team Lightning Experience Reports & Dashboards Specialist Salesforce Superbadge - prerequisites
Read more

Lightning Experience Reports & Dashboards Specialist Challenge #3

Image
Lightning Experience Reports & Dashboards Specialist Challenge #3 Folder Administration and Report Cleanup:- Create 4 Folder Using Below Name:- SolarBot Executive Reports SolarBot Sales Reports SolarBot Support Reports -> Status Reports(New Folder) SolarBot R&D Reports Folder Shared Permissions to Public groups :- Folder Name -> Shared Permissions SolarBot Executive Reports -> Report and Dashboard Administrators(Manage), Executive Team(Edit) SolarBot Sales Reports -> Report and Dashboard Administrators(Manage), Executive Team(View), Sales Leadership Team(Manage),Sales Team(View) SolarBot Support Reports -> Report and Dashboard Administrators(Manage), Executive Team(View), Sales Leadership Team(View),Support Team(Edit), Research and Development team(View) SolarBot R&D Reports -> Report and Dashboard Administrators(Manage), Executive Team(View), Research and Development team(Manage) Report Cleanup :- Folder -> Move Report Name SolarBot R&D Reports -...
Read more