Stacked Bar Graph - Reflect 3 columns

System Employee Admin
This discussion was created from comments split from: Stacked Bar Graph - Reflect 3 columns.


  • Chris Holt

    I have a similar situation. I'm trying to compare how many of a specific type of requests are fulfilled each quarter, via different methods and by different individuals. Here is an example of what I'm talking about. I wouldn't mind a stacked bar chart, or one that is broken down by each person.

  • Genevieve P.
    Genevieve P. Employee Admin

    Hi @Chris Holt

    There are a few different ways that you can display the data, depending on what you'd prefer. Personally, I would break it out per-person, and create one Chart Widget for each of the sections you have above, broken down by Quarter and Method, like so:

    Notice that at the bottom I have some Pie charts per-quarter showing the percent of the different Method Types. I did this by creating a Totals section of data at the bottom of the metric sheet.

    You can then customize the colours in each chart to match up, so Blue always represents "Email - Personal" across all your widgets, etc. Would this work for you?

    As an alternative, you could create a Helper Column to add together the text from your Name column and Method Type.

    This would create a unique text identifier for the Chart Widget's x-axis. You can Sort the Sheet by Method Type so they are grouped together, then do a chart like so:

    Or you could do the opposite to what I showed in the first example above, where you have one chart widget per-method type: the title of the chart would be the method type and the x-axis would show the Name, the bars showing each person's data. Let me know if you want to see an example of what I mean and I'm happy to create another demo.