Forum Discussion

gree1502's avatar
gree1502
Helper II
9 years ago
Solved

Create a measurement based on date

Hi,   I have table with column "notification date". This column is not unique.   I need to create a measurement, where the difference between now() and notification date should be greater than 45...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    9 years ago

    You could try a couple things. One, put a MAX or other aggregator around your Notification Date in your formula. Or, you could put this formula into a calculated column.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
9 years ago

You could try a couple things. One, put a MAX or other aggregator around your Notification Date in your formula. Or, you could put this formula into a calculated column.

gree1502's avatar
gree1502
Helper II
9 years ago

Thanks for the response.

I don't understand the use of max here. I want to check each record, if the difference is > 45.

consider that date if > 45 else ignore.

 

Can you elaborate?