We want to create a 'Helper Column', which is a New metric from an existing fact in the underlying data model. See attached (MAL).
1. When the insight is loaded into the Matrix/table, it reflects as an integer. Does GoodData Not support Format Date? (See attached).
Best answer by Michael UllockView original
I am afraid such metric syntax is is not possible to convert the result of the “THIS Macro” to date formatting. We usually recommend using this number for date arithmetic in order to analyse, for example, the duration between two events.
For more details on working with Dates, please see our documentation here:
I would also like to point you to previous Community article which you may find useful going forward: