Help get this topic noticed by sharing it on Twitter, Facebook, or email.

Creating a chart from a view

I created a database view which does all the grouping for me at the database level which produces a one line record. It displays year, total expenditure, budget for the year and the difference between the two.
Example: 2019, $100.00, $2000.00, $1900.00
I was hoping to enable charting so I could display this in a chart format but from what I can see the charts view is not available if the data (model) comes from a database view. Can anyone advise me on the best way to do this
1 person has
this question