Unable to select Column with Number type in Bar chart

[zeel-codder]

I'm trying to create a bar chart using the Todo DocType from idx->Count of Records with given idx. But In the x-axis, I am unable to select any of the given columns.

Version: develop

I have attached the screenshot for the same

• Query

• Plot

[nextchamp-saqib]

Hey, I cannot see the query screenshot, can you post it again?

[zeel-codder]

Check now

[nextchamp-saqib]

Since Group by idx is a number field, it is only available on Y axis To overwrite this, you need to cast it to a string field. To do that you need to add a column expression to group by idx like so,