Hi, All! I'm facing the following issue - I'm tryi...
# gooddata-platform
Hi, All! I'm facing the following issue - I'm trying to find the number of cards transactions where the transaction date falls within maximum first 90 days of cards' registration date. The two date dimensions (card registration date and card transaction date belong to different tables in the data model which are related). Can anyone help with how the metric should look like? Thanks
Hi Diana, You will need to use some sort of MAX DATE Arithmetic (the documentation will be updated in the newer docs after next release). However, please keep in mind that all object will need to be linked together in your LDM using the BY Clause. How do you plan on using the metric exactly? Are you filtering by date on the dashboard level?