New Idea
Data Designer Filter and Summarize by Date
In data designer, working with dates is extremely limited. I cannot summarize by date before a transform, and I cannot dynamically select a date range from the past. For example, I want to summarize usage from last month, the month before that, and the month before that to calculate a growth rate over last 3 months. I can select date = “last 30 days” for last month’s usage, but how do I sum over the date range *between* 30 days ago and 60 days ago to calculate the previous month (or between 60 days ago and 90 days ago for 3 months ago’s usage)?
The date filter needs an option such as “N days ago” so I can input “less than or equal to 30 days ago” and “greater than or equal to 60 days ago”.
