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
datename functions, in Postgres you can use
to_char function, etc.