2 Replies Latest reply on May 24, 2017 1:12 AM by Simon Runc

How does Jitter work?

How does this jitter formula work? I don't understand what it's doing. Look at sheet Y axis at 0.

If ATTR([Speaker ID])=[Enter Speaker ID] then 7

elseif INDEX()%2=1 then

INDEX()%7

ELSE

(INDEX()%7)+8

end

• 1. Re: How does Jitter work?

I have a horrible memory (so forgive me) but I think this entire concept is a Simon Runc thing. (If not, I'm sure Simon will know who's invention this was.)

--Shawn

• 2. Re: How does Jitter work?

hi Shawn,

While a big proponent (and user) of the Jitter technique...and wish I had the smarts to have come up with it...it was, of course, Mr Joe Mako! (it was one of the first cool tricks I learned in Tableau...so takes me back to the start of my Tableau journey!)

This is different to Alex's post...and just uses the simpler INDEX()%25

where 25 is the number of "jitter positions" you want...so in the attached I have circle marks "randomly" spaced over 25 potential positions.

and then compute using the on the Level of the Viz....

I've also attached an Excel showing what it's actually doing (using INDEX()%5)....which is just return the remainder of the calculation INDEX number/25

Alex, let me know if anything doesn't make sense.

1 of 1 people found this helpful