MikeRoberts

Thanks @jaeW_at_Onyx.

in How to add a Jitter to a chart (a Scatter plot in my example) Comment by MikeRoberts February 2021

Thanks @GrantSmith. I get that Beast mode runs per a row... but odd that the running of the rand() function would return the same result every time it's used on the same row? That's not quite the point of a rand()? Anyways, doing it another way so no biggie. All good learnings for me. Thanks!

in How to add a Jitter to a chart (a Scatter plot in my example) Comment by MikeRoberts February 2021

Thanks for this @GrantSmith. A neat solution :-) Some slightly strange behavior though... Here's the formulas used in Beast mode... and here they are when put into an ETL. Suggests that in Beast Mode the the rand() function is runfor the row rather than for the row and function. But I've got the result I need, so all good.…

in How to add a Jitter to a chart (a Scatter plot in my example) Comment by MikeRoberts February 2021

MikeRoberts Member

Comments