Forum Discussion
Elliott
10 years agoAdvocate II
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...
- 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.
Greg_Deckler
10 years agoCommunity Champion
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.