I have uploaded our invoice data to GoodData and would like to create a report where I will see when the invoices are due. I have invoice date and expiration days. Is it possible to calculate it and display as date "yyyy-mm-dd"?
Example: Invoice date: 2023-01-01 Due: 15 days
Due date: 2023-01-16
Thanks in advance!!
Andres
Best answer by Moises Morales
View original
Hi Andres,
Could you please send your metric so I can review it?
Thanks,
-Moises
This is my LDM
I need a report like this
I’m trying with this metric
Is it possible to calculate and display as date "yyyy-mm-dd"?
Is not possiible for this project calculate on ETL proceess
Thanks!!
It's unfortunately not possible to convert this number to date formatting. We usually recommend using this number for date arithmetic in order to analyze, for example, the duration between two events.
I'm sorry that this wasn't the answer you were hoping for.
Sign in with your community account. This is different than your login to your GoodData account. Don't have a community login? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
