Quickly add a chart to report in SalesForce Ligthning

Adding a chart to a report in SalesForce Lightning

When the button add chart is greyed out in a  report created in SalesForce‌  do not panic - a simple manipulation has to be made to be able to create a chart from that report, and the trick can be used anytime when creating reports in SalesForce: group records together for chart generation.

Solve add chart SalesForce report grayed out: group report data on one field
Add Chart button is disable on my report screen

Get around the greyed out add chart button by grouping data

Open your  report created in SalesForce‌  and click on the edit button in the top right corner of the report visualization screen to access report options and get around the greyed out button.

The next step is to add a group of data. For example, if you want to report on how many Mister, Miss and Doctors are available in your list of  SalesForce accounts‌  and  SalesForce contacts‌  then select the salutation field for grouping.

The raw data that can be used to  exporting data from SalesForce to Excel‌  in the report table view is now grouped by the salutation field as you can see in the preview tab.

However, data hasn't been set yet and report hasn't been yet updated. To do so, click on the RUN button.

unable to add chart to custom report

Generate chart from report

Back on the report visualization screen, the button Add Chart is now available for data that has been grouped on one field!

After clicking on the add chart button, the chart creation screen will be displayed, with a standard chart visualization selected by default, which might depend on the type of data that was available in the report, and the field used for grouping.

Click on chart properties to change the type of chart used.

Different types of charts are available: bar, column, stacked bar, stacked column, line, donut, funnel, scatter plot, and much more.

Depending on the grouped data, different charts will be available or not for the chart generation from report.

Selecting a donut visualization, the new chart created from report will be available and can be used and reused in  SalesForce dashboards‌  or for  exporting data from SalesForce to Excel‌  and create beautiful reports with charts.

Add a Chart to a Report

Comments (0)

Leave a comment