In salesforce lightning, no matter what I do when I create a report and group by Account Owner and even another field the "X-Axis" only allows Record Count. I do not want to show a record count, how can I group on any other field aside from Record Coutn on the X-Axis. When I group by additional rows it allows me to change the Y-Axis, but never the "X-Axis".


The X axis is used to show things like sum or average values of a numeric field. To have other options available than Record Count, you need to modify the report to include at least one summary option.

Summarize Field

Choose X Axis Options

Different chart types will also offer different options (e.g. pie charts have fewer options than bar graphs).

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.