Looking for workaround when grouping in Reports so that Primary Column does not display on a Chart.
Apparently it is expected behavior in a Report when using grouping to have the primary column automatically moved to the far left. The problem with this is that when I try to use this report to show data on a chart in a Dashboard, it shows the Primary Column titles as the Horizontal Axis. If I deselect "Use first column as series labels" it does not display the chart correctly and there are no horizontal labels. The dropdown for the Columns Included in the chart are limited and does not display the column that I want to be displayed on the Horizontal Axis. Has anyone found a workaround for this?
Best Answer
Answers
-
Thank you! I was able to create a metrics sheet and use the column headers as the independent variables on the x-axis. The charts widget on the dashboard are very touchy.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives