Hey,
I am trying to show sum of dealvalue month by month for each year. I am using a custom SQL query to solve this as it isn't possible in another way.
But when doing so, I get the month numbers instead of names. How can I get the names instead of numbers?
This is not related to Metabase. This is a SQL question. You are applying the Month
function which returns a number.
To get the month name, the function you should use depends on the underlying DB instance. In SQL Server you can use format
or datename
functions, in Postgres you can use to_char
function, etc.