Hi Everyone, I’m trying to create a chart to show some cost savings that are stored in a number column. My issue is, that only one of my groups is showing (ironically the only one I don’t need!) and I can’t pull any information through for the others. Any help is really appreciated! I’ve attached some screen shots below. It’s still in template form so full of dummy data.
This is an example of one of the groups I need to pull to the chart: it is the “Cost Savings (per month)” column I need to pull through.
In the chart settings I have the following:
Chart Type: Bar
X-axis: Group
Y-axis: Cost Savings (per month)
Groups: All Groups
When I change the y-axis to count items, this pulls through only one group. If I change x-axis to item, it only pulls through the items from the same one group.
Any help greatly appreciated! I usually have no issues developing charts or even multi-board dashboards, so its sending me crazy!!!