Sub query doesn't work in Trend Metric

[ysfkaya]

• Laravel Version: ^7.0
• Nova Version: ^3.0
• PHP Version: ^7.4
• Database Driver & Version: Mysql ^5.7
• Operating System and Version: MacOS Catalina 10.15.5
• Browser type and version: Mozilla Firefox

Description:

When I trying the custom eloquent query with using sub query I'm getting a Column not found error from mysql.

So I think, Nova recalling selectquery in trend metric aggregate method and so my sub query is not applying.

Is there any way to prevent this?

[crynobone]

For such complex query I would suggest overriding the aggregate() to best meet your requirement.

[ysfkaya]

Well @crynobone, I thought it was a general problem thanks.