RobertPenridge Member

Comments

  • Thanks @jaeW_at_Onyx . Yeah I stumbled across those function options in the top right corner of the views UI last night. Specifically I was wanting to include 4 observations either side of the current row into the stdev calculation. Unfortunately I think in order to achieve that I need to jump through so many hoops it…
    in Normal distribution probability Comment by RobertPenridge July 2021
  • And if you want it more randomized within each row you would be better seeding it with the current_time() function for the first call, the current_time() + interval 1 day for the second call, and so on.
    in How exactly does the rand() function work Comment by RobertPenridge July 2021
  • It's probably also worth noting you can make the numbers appear more random by seeding it with the result of the current_time() function. This means when you refresh the page at least you will get different results each time...
    in How exactly does the rand() function work Comment by RobertPenridge July 2021
  • The only solution I could figure out was to adjust the SQL so that my `id` field had a hardcoded value of zero, ie... select 0 as id from mytable... That way the internally remembered value became zero. I then reverted the SQL to the original settings.
    in mySQL parameterized querues - resetting the parameter Comment by RobertPenridge December 2019
Default Avatar