I am trying to create a query in datasource desinger where the view I am using includes CREATED_DATE in a datetime format. I have no problem creating a new field in the query to translate this to date or month, but I am struggling to use the same statements in ‘Group by’.
Whenever I try to use any type of calculated value (such as to_char) in Group by, to get the results on a daily or monthly level, I get an error message. Is there any way to resolve this?