Create a report in Salesforce for Geckoboard

In this article, we'll analyze the steps needed to create a report in your Salesforce account and display it on Geckoboard using our Salesforce integration.

Note

We cover the basics of using the Salesforce integration in this article. Here, we’ll focus on creating reports within Salesforce.

Building your Salesforce report

Before you start

Which version of Salesforce are you using? This article walks you through building a report using Lightning Experience. Click the Salesforce Classic tab below for instructions on how to create a report in Classic mode.

Note

For this article, we'll be using the report criteria of Closed Won opportunities in the Last FY grouped by Opportunity Owner.

To build a custom report from scratch using Salesforce Lightning, follow these steps:

  1. Click the Reports tab on the navigation bar.Salesforce Lightning main menu
  2. Click New Report.
  3. In the Choose Report Type list, type Opportunities in the search field, and then select Opportunities from the list that appears.
  4. Click Continue.
  5. To begin selecting the scope of the report using the standard filters, click the Filters pane.
  6. Click Opportunity Status to bring up the edit filter window.
  7. From the drop-down menu, select Closed Won, then click Apply.
  8. Click Close date to bring up the edit filter window.
  9. From the Range drop-down menu, select Current FY, then click Apply.Salesforce Lightning filters pane

    Note

    You might find the previewed report contains columns you don’t need for this report. If so, you can remove and rearrange the ones you do need to make better sense of the data.

  10. Click the Outline pane to show columns/fields.
  11. Click the close X next to the following fields: TypeLead source, Next step, Fiscal period, #Age, Created data, Owner role.
  12. Click the arrow next to Fields to Show all Fields.
  13. Search for the Stage Duration field and drag it into the Outline panel and drop it right below the Stage column.
  14. To select the grouping, click the down arrow by the Opportunity Owner column heading and select Group Rows by this Field.Salesforce Lightning group columns
  15. To add a summary field, click the down arrow next to the Amount column heading and select Summarize, followed by Sum.Salesforce Lightning summarize sum
  16. Click Save & Run, then complete the Save Report details by entering a Report Name, Report Unique Name and Report Description.Salesforce Lightning save report
  17. Select a Folder to save your report in.
  18. Click Save. The report format will automatically change to Summary since you selected the groupings.

Note

For this article, we'll be using the report criteria of Closed Won opportunities in the Last 30 Days grouped by Opportunity Owner.

To build a custom report from scratch using Salesforce Classic, follow these steps:

  1. On the Salesforce report builder click on New Report and then select the Opportunities report type.
  2. To begin selecting the scope of the report using filters, update the opportunity status to Closed Won.
  3. Set the range to Last 30 days.Salesforce scope
  4. You might find the previewed report contains columns you don’t need for this report. If so, you can remove and rearrange the ones you do need to make better sense of the data.salesforce clean-up
  5. To visualize your data you'll need to select the format and grouping for your report. In our example we want a list of all opportunities owned by our representatives, so we'll use the Summary report type and will group by the Opportunity Owner.Salesforce grouping
  6. To finish the report we'll Summarize the data based on the Amount of these opportunities.Salesforce summarize
  7. Click Save and run the report.
  8. Now that you have your report in the right format, you can display it in Geckoboard.

Further reading

Was this article helpful?

Awesome! 👍  Thanks so much for your feedback!