Jitterpoints

[nseagrave]

Hi Steven

I love this chart, there's so much cool stuff you can do with it.

Not so much an issue, as a request for help. One chart I am trying to set up for a colleague I've got a couple of bar charts layered behind a distribution plot on a standard chart. On that distribution plot you can switch on Jitter points but I can't work out how to do it in here, I'm guessing another scale or something.

Any chance of some pointers?

[AnalyticsEarth]

Support for Jitter requires a manual function on the point location. This is not something native to picasso.js. At the moment its not possible to do this using the extension properties.

[nseagrave]

Just in case anybody is interested I found a workaround.

• I added my dimensions, Unique Machine & Customer Name as a dimension
• I then added a measure to make Unique Machine it dual, using this formula to group all the unique machines into one group: dual([Unique Machine],if(rowno(TOTAL)=1,1,if(Above(TOTAL [Unique Machine])=[Unique Machine],floor(above(TOTAL column(1))),floor(above(TOTAL column(1)))+1)))
• I used this as the scale X axis scale, so effectively my Unique Machine dimension lined up with my Unique Machine measure, incrementing 1,2,3,4,5,6 etc
• I then created a measure, Jitter point, which reused the numerical input I put into the dual function + a random number, I then plotted this against the Unique machine measure, and hey presto my dots move about.

I say hey presto, it took me a while to figure out, but it seems to work.