====== 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

{{:advanced_transformations:2021-09-22_20-00.png?600|}}

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


{{:advanced_transformations:2021-09-22_20-13.png?600|}}

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