pietersv

protobi.refactorGrid = function(key,ref) {
    let dim = protobi.getDimension(key);
    let result = {}
    let refDim = ref ? this.getDimension(ref) : null
    let refKids = refDim?.getChildren() 
    _.each( dim.getChildren(), function(kid, kidIdx) {
       _.each( kid.getChildren(), function(gkid, gkidIdx) {
            let token1 = ': '
            let token2 = ' - '
            let token3 = ' - '

pietersv

/**
 * This code will set selected elements to unweighted if crosstabbed by particular banner elements.

 */
{
    //TL, 2023-11-02
    //This code is from the QUNIT: Car sales demo
    //Add code that unweighs data when Specialty is used as a crosstab
    let BANNER_THAT_SHALL_BE_UNWEIGHTED = 'quotaquestion'  
    

pietersv

SELECT session_id, statement_id, node_name, LEFT(query,100), query_start, user_name, is_executing FROM v_monitor.query_profiles WHERE is_executing = 't';
SELECT INTERRUPT_STATEment('_protobi_db_node0001-412069:0xc0c1e9',1);

pietersv

SELECT 
	REGEXP_SUBSTR(column_name,'^[a-zA-Z]*',1) AS base, 
	REGEXP_SUBSTR(data_type,'^[a-zA-Z]*',1) AS type,
	COUNT(*)
FROM v_catalog.columns
WHERE table_schema = 'myschema' AND table_name = 'mytable'
GROUP BY 1,2
ORDER BY 1

pietersv

// --------------------------------------------------
// This enables the generation of a XLSX pivot table
// with several restrictions
//
// Last updated: 2023-07-18-13:18
// --------------------------------------------------



// -------------------------------------------------------------------------------------

pietersv

// this method will display null values as n-dashes, and round anything below 5 down, 
// so that 0.22499999999999998 yields 22% not 23%
protobi.widgetFactory.views.BasicElement.prototype.fmtPercent =  function (val) {
  return (val == null || isNaN(val)) ? '—' : ((val * 100).toFixed(protobi.globals.precisionPercent || 0)) + (protobi.globals.showPercentSymbol === false ? '' : '%');
}

pietersv

pietersv

pietersv

Memoized functions to quckly convert z-value and t-values to tables

t-value to p-value

    // memoized table of p values for t values, for df < 30 and t values between 0.1 and 5
    // the first index is the number of drgr
    var _ttable = [null,{"-2.3":0.532,"-1.6":0.563,"-1.2":0.593,"-0.9":0.621,"-0.7":0.648,"-0.5":0.672,"-0.4":0.694,"-0.2":0.715,"-0.1":0.733,"-0.0":0.75,"0.1":0.765,"0.2":0.779,"0.3":0.803,"0.4":0.813,"0.5":0.831,"0.6":0.846,"0.7":0.859,"0.8":0.869,"0.9":0.879,"1.0":0.891,"1.1":0.901,"1.2":0.909,"1.3":0.918,"1.4":0.926,"1.5":0.933,"1.6":0.937},{"-2.3":0.535,"-1.6":0.57,"-1.2":0.604,"-0.9":0.636,"-0.7":0.667,"-0.5":0.695,"-0.4":0.722,"-0.2":0.746,"-0.1":0.768,"-0.0":0.789,"0.1":0.807,"0.2":0.823,"0.3":0.852,"0.4":0.864,"0.5":0.884,"0.6":0.901,"0.7":0.915,"0.8":0.926,"0.9":0.935,"1.0":0.946,"1.1":0.955,"1.2":0.962,"1.3":0.969,"1.4":0.974,"1.5":0.979,"1.6":0.981},{"-2.3":0.537,"-1.6":0.573,"-1.2":0.608,"-0.9":0.642,"-0.7":0.674,"-0.5":0.705,"-0.4":0.733,"-0.2":0.759,"-0.1":0.783,"

pietersv

Rim weighting algorithm

The function below calculates a single respondent-level weight variable such that when applied as a weight, the marginal distribution of multiple elements yields the desired proportions. This can be useful to ensure that the results of a survey sample reflect the population distribution.

Algorithms

Add this function within a Protobi data process:

/**
 * Calculate a single respondent-level  weight such that when weighting is applied 
 * multiple variables yield the desired marginal distribution