-
Normal distribution probability
Does Domo have anything similar to the norm.dist() function in excel or the probnorm() function in SAS? I'm looking to use it in a beastmode or calculated field within views explorer. norm.dist (excel) - https://support.microsoft.com/en-us/office/norm-dist-function-edb1cc14-a21c-4e53-839d-8082074c9f8d probnorm (sas) -…
-
How exactly does the rand() function work
Based on my testing it seems like the rand() function returns a guaranteed set of pseudo-random numbers seeded by the optional 'value' parameter. For example, if a create a card with a beastmode, the first time a beastmode, calls the rand() function (with no parameters) it will return a value of ~0.69. The second time the…
-
mySQL parameterized querues - resetting the parameter
I setup a parameterized query that pulls just incremental data based on IDs. I initially set the parater to zero and on the first pull it retrieved all rows as expected. On subsequent runs it's pulling just the new records as expected. Is there a way to 'reset' the parameter so that will will re-pull all rows in the table?
-
Simple JSON parsing
I have a field in a table that contains values stored in a JSON string like this: {"enabled":true,"timeout":220,"timeout_buffer":1} There are other fields in the table as well but only one of them contains JSON values. I would like to parse out the values into appropriately named columns, ie. create new columns called…
