Display Chart for Multiple Groups in Report

tylersmiles ✭✭
edited 03/08/24 in Formulas and Functions

I am hoping for some help. I currently have a report created that is grouped and counting what I need. The goal is to count how many bugs and enhancements there are per category. I want to be able to create a double bar graph off these counts but not able to get the chart to display how I want.

My report looks like the following with the product area, then organized by bugs and enhancements and then the count associated with each:

My current Chart is pulling like this:

I am hoping the graph would have the following:

Does anyone have any suggestions on how I can get a graph to display all these items above?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!