Dashboard X & Y Axis Plotting & Pie Chart Question

NCNWIncData

Good Afternoon,

I am relatively new and attempting to pull through a Sheet, see below, through the Chart Widget on the Dashboard.

I would like the highlighted column above to be charted on the X axis and any of the following columns can be my Y axis which would show how many submissions I have received per each group which could be from Group 1, 2, or 3.

This is what I currently got, see below:

This is what I want it to look like, see below:

Thanks,

NCNW, Inc.

BullandKhmer

A couple of steps here

1. Resolve the no match issue, maybe wrap your formula with IFERROR( at the front and ,"") at the back

2. As is, your chart will not say "Group 1, group 2, group 3" just 1,2,3. If this is an issue adjust your formula to include "Group" + " " +{{Formula}}

3. So with all the above considered, adjust your column formula to "IFERROR("Group" +" " + {{Formula}},"")

4. Build a report, you will only need the primary column and the group column. Group your report by the "group" column and collapse the groups. Summarize the group column with count.

5. Build your chart off the report, not the sheet.

Cheers.