SteveGImbroll wrote: so when in set analysis you do Field=, that means, exclude those fields im selecting? |
Yep, that's what it means. Ignore the selections in that field. Now, it's not exactly a perfect ignore, as it will take into account how those fields affect values in other fields that you may be referencing. But I think that's what we want here, in that if you select a day, month and year, you WANT it to use the matching created_date when calculating your 30-day spread.
Thinking a little further, I'd think you'd want your if() to be if(created_date,...), though. I'm guessing that "Day" is the day of the month. In and of itself, that's not enough, as you'd also need to select a month and a year. But I'm thinking that doesn't really matter so much as just you've "selected" a single created_date, which you can check by just seeing if it has a value. If it has a value, then only one value is possible.
