Need Assistance with Reporting and Dashboard Widgets
I'm working on a project to create a request intake form which then goes through approval workflows.
Based on the requests submitted I need to be able to do some basic reporting such as #of requests, #of requests by approval status, #of requests by function, breakdown by month to see month on month trend etc.
Every time I try to do something with the chart widget I hit the wall with the error "Selected data range cannot be charted. Please select a new range".
I have tried everything from using sheets as the source, creating a report and using it as a source, creating a report with only a small subset of the columns and using that as a source. Nothing seems to work. It's a hit or a miss scenario with the error.
At times when I don't get the error, I'm unable to select the columns that I want to use in the charts, its defaulted to all columns and I cannot edit it.
Any inputs here would be helpful. I don't know what I'm doing wrong.
Help Article Resources
Check out the Formula Handbook template!