Try ERPNext Buy Support Partners Foundation

Report Chart Doesn't Recognize Numeric Values

My query report chart will not recognize numeric columns to choose as the Y-Value of my chart. Is there something I am missing to populate the Y-Value drop down menu? The values are integers in the database and I am specifying integer in the query format.

SELECT
tabEntry.bears as “Bear Name::200”,
tabEntry.bear_cubs as “Cubs:Int:200”
FROM
tabEntry

Which then gives me this screen where the X menu is populated but the Y menu is not.

Screenshot%20from%202020-07-08%2022-38-50

hello, I’m having the same issue. Do you find the solution yet?

No, I never made it work. Maybe a script report would be a work around.