I think this does what you need. I created a parameter with a value 1 through 12 and gave an alias for these Jan through Feb. I showed the parameter control (drop down). I have a calc that goes line by line and copies the date column over only if the current row month is equal or less than the parameter.
There's a window calc that checks the maximum date for an AD ID and sees if it occurs within the month chosen. If not, that AD ID is not shown
Finally there's a window sum of the impressions for all impressions prior and including the current month. This is set to partition on Ad ID.
Now, my knowledge of window_calcs is lower than others, and this may not be as robust as you may need. Others could have a much simpler solution...
filter_by_date.twbx 14.2 KB
@Alex Kerin - sounds like you've had some experience with setting a date range within a calculated field. I would very much appreciate it if you could take a look at what I'm trying to do below and let me know if you have any insights:
So here's my data structure:
Tab name: Today's appointments
Customer id TODAY's Appointment start time
8 am 9 am 10 am 11 am 12 pm ....................
002 Past No Shows: 2
My data also has a field called "IsNoShow" which tallies the number of "No Shows" for each customer. Here's the challenge - how do I flag customer's who have "No Showed" in the past for Today's appointments? So, for example, as shown above, I'd like customer 002, who has an appointment at 9 am today, to be flagged with 2 previous No Shows.