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.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives