I am running version v0.35.4 from official Docker image.
On a Postgresql database source, I have query group by date but the trend line is not displayed.
By using same kind of query on Sample Dataset - Orders, the trend line option is displayed.
I have build the question using the visual editor.
The SQL request is:
SELECT CAST("source"."StartTime" AS date) AS "StartTime", count(distinct "source"."IdentityName") AS "count"
FROM (SELECT "public"."tbl_Command_consolidated"."Application" AS "Application", "public"."tbl_Command_consolidated"."Collection" AS "Collection", "public"."tbl_Command_consolidated"."IdentityName" AS "IdentityName", "public"."tbl_Command_consolidated"."IPAddress" AS "IPAddress", "public"."tbl_Command_consolidated"."StartTime" AS "StartTime", "public"."tbl_Command_consolidated"."UserAgent" AS "UserAgent", "public"."tbl_Command_consolidated"."ExecutionCount" AS "ExecutionCount", "public"."tbl_Command_consolidated"."ExecutionTime" AS "ExecutionTime" FROM "public"."tbl_Command_consolidated") "source"
GROUP BY CAST("source"."StartTime" AS date)
ORDER BY CAST("source"."StartTime" AS date) ASC
By editing the SQL request, if I remove the ORDER BY line then the trend line option is appearing but now my question is only editable in SQL mode.
This ORDER BY is automatically added by the editor.
Adding and removing a sort is not removing this ORDER BY from the SQL request.
Hi @Dendrocitta
Please post “Diagnostic Info” from Admin > Troubleshooting.
What is the visualization Settings > Axes > X-axis scale?
What is the database column type of “Start Time”?
And what is the Field Type in Admin > Data Model > (database+schema) > (table) > (column) ?