How to format timestamps in charts

Sometimes timestamps have to be formatted to strings to work better eg. in powerbi.

1. Add the new column as you like

2.Add the transformation Here it is: to_char(date, 'YYYY-MM-DD')

3. Save and add the field to the grouped by columns