This shows you the differences between two versions of the page.
— |
advanced_transformations:formatting_timestamps [2021/09/22 19:15] (current) windsor_ai created |
||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ====== 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, | ||
+ | |||
+ | |||
+ | {{: | ||
+ | |||
+ | 3. Save and add the field to the grouped by columns |