How to view monthly data for a question created via SQL?

1

I made a question using SQL editor, the result appears as a number I want to view it as monthly visualized

How to view monthly data for a question created via SQL ?

2

Hi @Mohammad_Abdallah
You'll have group by month. I would recommend that you make the query via the GUI https://www.metabase.com/docs/latest/questions/query-builder/introduction and then you can convert to SQL if you want https://www.metabase.com/docs/latest/questions/query-builder/introduction#viewing-the-sql-that-powers-your-question

3

it cannot be created by GUI, because it is like question result divided by question result

so it is percentage and I want to view this percentage monthly