Forum Discussion

Elliott's avatar
Elliott
Advocate II
10 years ago
Solved

How to specify different time periods from the same source data

Hello,   I am having difficulty attempting to figure out an issue I am currently facing.   I shall keep it in simple terms as my issue can apply to several different scenarios.    Issue: I hav...
  • Greg_Deckler's avatar
    10 years ago

    Create a new column with the formula:

     

    Days Aging = DATEDIFF([Date],TODAY(),DAY)

     

    This will give you number of days in the past and allow you to use it as a filter in your visualizations for last 7 days and last 30 days.