Dashboard X & Y Axis Plotting & Pie Chart Question

Options

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.

Answers

  • BullandKhmer
    BullandKhmer ✭✭✭✭✭
    Options

    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.

  • NCNWIncData
    Options

    Good Evening,

    I took the following advice and did get my pie chart working. However, I now want my data to have two criteria based on Group No. (Group 1) and the Month Selected (in this case April), both of these columns are referencing from another sheet, see second image. I tried to use a few variations of the formula below but I keep getting incorrect argument or unparseable, see below:

    Any ideas on what I am doing wrong?

    Thanks,
    NCNWInc. Data