Display Report Column Groups in Lightning Report and Dashboard Charts - Ideas - Salesforce Trailblazer Community
Trailblazer Community

All Ideas

Idea Details

Post an Idea
2,480  Points
Idea has been posted. Give it an upvote or downvote.

Display Report Column Groups in Lightning Report and Dashboard Charts

Customization & App Building

Currently in Lightning Report Builder you can't display Report Column Groups in a Bar Chart. 

This is especially problematic if you are on a mature org in Classic UX with a lot Charts and Dashboards that reference Matrix Columns and want to migrate to Lightning.  Because if you currently have a Report and Chart like this
User-added image

And you migrate to Lightning, you'll get something like this
User-added image

So in order to get the Chart you want you need to "swap" your Row and Column groups like this
*** Spoiler Alert: This will break any Report Summary Formulas that you have ***
User-added image

So your options are:
1. Rebuild every Matrix Report and Chart (and Report Summary Formula) on your org!
2. Leave the Report "as is" and tell your users they can't have the Chart they want.
3. Create 2 versions of the same Report so they can have the Report and Chart (but not together)
4. Remain on Classic UX
5. Vote for this Idea...  a LOT!!!

Merge Idea · Flag

  • Upvotes
  • Downvotes



from AppExchange

Help us to keep IdeaExchange clean by pointing out overlapping ideas. We'll investigate your suggestion and merge the ideas if it makes sense.



Thanks for your merge suggestion. We will review it shortly and merge the ideas if applicable.

Salesforce takes abuse situations very seriously. Examples of abuse include but are not limited to posting of offensive language or fraudulent statements. To help us process your request as quickly as possible, please fill out the form below describing the situation. For privacy and security reasons, the final outcome of an abuse case may not be revealed to the person who reported it.


Thank you for your feedback. We take abuse seriously and will investigate this issue and take appropriate action.