Forum Discussion

John2's avatar
John2
Frequent Visitor
2 years ago
Solved

Calculated column formula

I have a table called asset with ids and last report time of each id.  I want to get the ids which were reported in the last 24hrs, last 7 days, last 8-30 days and not reported for more than 30 days....
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    HI John2,

    So you mean you want to use one calculate field to get dynamic last n period based on current system date? If the is the case, I'd like to suggest you write multiple conditions in variable and add matched conditions flags to return the period levels.
    For example:
    Over one month level 1, last month level 2, last week level 3, last 3 days level 4, yesterday level 5. (the high level also matches the period tag that less than it)
    You can use 'less than or equal to' mode to filter on level to display all match records. Also, you can add a new calculated column to show the description of these levels.

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
2 years ago

HI John2,

So you mean you want to use one calculate field to get dynamic last n period based on current system date? If the is the case, I'd like to suggest you write multiple conditions in variable and add matched conditions flags to return the period levels.
For example:
Over one month level 1, last month level 2, last week level 3, last 3 days level 4, yesterday level 5. (the high level also matches the period tag that less than it)
You can use 'less than or equal to' mode to filter on level to display all match records. Also, you can add a new calculated column to show the description of these levels.

Regards,

Xiaoxin Sheng