Custom queries for charts

English Forum
1

Adding charts to the layout is an awesome feature, and the built-in query builder is very capable. I’m missing the ability to have all dates in a range for the x axis of chart. I don’t want to burden your team with highly specific use cases, so I’d just ask to enable me to type in my own SQL SELECT statement for the chart data.

Thanks for the great tool!

2

Hi,

Maybe you can use Sql Connection and in Chart you choose the collection created.

https://docs.nocobase.com/handbook/collection-sql

3

That is actually a great idea. I’ll try it out and post here how it went.