I am new to salesforce and am helping creating a salesforce page for a start-up. I have gotten the site set up, however I am working on customizing the dashboard. I have populated many "Reports" with data. With those reports I have created a table from 5 different data points. The "Add Chart" button is grayed out because I have no grouping for the chart. I added a Report to the grouping which reflects "Baseline, Year 1, Year 2, Year 3, Year 4". My report now looks like this:
This information is set up correctly in the table, and I would like create a bar chart that reflects the data points. However, the "Add Chart" feature only allows me to create a graph that is sorted by record count. ALL RECORD COUNTS = 1 IN THIS SITUATION. To clarify, the values for "Baseline" should be (100,200,200,150,150):
Please advise on how I can create the graph I am looking for. Do I need to restructure the data? Use a different grouping? This is pro-bono for a friends start-up non-profit. Any help is welcome.