
1. Re: Dynamic event as axis
Joe Mako Jun 17, 2013 9:31 PM (in response to Emily Mueller)How about a calc field like:
IF LAST()==0 THEN
[Running sum shift length]
END
with compute using set to "eventdate"
Then you can apply your filter to this pill as well.

2. Re: Dynamic event as axis
Emily Mueller Jun 18, 2013 7:03 AM (in response to Joe Mako)Thanks Joe, that worked well. I've seen formulas using First() and Last() and ==, can you explain to me what this is doing?
Thanks
Emily

3. Re: Dynamic event as axis
Joe Mako Jun 18, 2013 7:57 AM (in response to Emily Mueller)1 of 1 people found this helpful== is the same as = in Tableau, so [Value]=1 is the same as [Value]==1.
FIRST() returns the distance to the first mark in the partition, so FIRST()==0 will be True for the first mark in the partition. FIRST() will return 0 and negative numbers, because the distance to the first mark from any subsequent mark will be a negative distance.
LAST() returns the distance to the last mark in the partition, so LAST()==0 will be True for the last mark in the partition. LAST() will return 0 and positive numbers, because the distance to the last mark from any previous mark will be a positive distance.
I think of it like a number line, where 0 is the current mark.
These functions are very useful in many situations, because it is quite common to want to reference the first or last mark in a partition.
I think a great way to learn about them is to try them out

4. Re: Dynamic event as axis
Emily Mueller Jun 18, 2013 9:00 AM (in response to Joe Mako)Thanks Joe!