Sort/Reorder Rows or Columns - Sort Categories from Highest to Lowest (Does Not Update When Data Changes)

This QScript sorts the questions in the project from highest to lowest (i.e., ranks the data, so that the order of the rows reveals a ranking). This is computed using the entire sample. The order does not update if the data changes (e.g., when filtered or updated). Also, see Sorting and Reordering - Sort Rows (Automatically Updates when Data Changes).

Example

Technical details

Categories which look like 'Other/Specify', 'Don't Know', 'None of these', or 'All of these' style responses, as well as the NET and SUM rows, will be left at the bottom of the table.
This QScript will not try to sort questions that look like scale questions, according to the rules of the function looksLikeScale.
Tables are sorted in the descending order of the relevant statistic, as determined by their Question Type:
- Pick One, Pick Any, and Pick Any - Compact questions are sorted according to the % shown in their SUMMARY table.
- Number - Multi questions are sorted according to the Average shown in their SUMMARY table.
- Ranking questions are sorted according to the Probability % shown in their SUMMARY table.
- Pick One - Multi questions are sorted according to the Row % in the right-most column of their SUMMARY table that is not the NET column. If the question has had its rows and columns swapped then the question is sorted by according to the Column % shown in the bottom-most row of its SUMMARY that is not the NET row.
- Pick Any - Grid questions are sorted according to the % shown in the first column of their SUMMARY table that is not the NET column.
- Number - Grid questions are sorted according to the Average shown in the first column of their SUMMARY table that is not the SUM column.

Technical details

includeWeb("QScript Functions to Generate Outputs");
includeWeb('QScript Selection Functions');
includeWeb('QScript Table Functions');
includeWeb('QScript Utility Functions');
includeWeb('QScript Functions to Generate Outputs');
includeWeb('QScript Questionnaire Functions');
includeWeb('QScript Value Attributes Functions');


function getAllQuestionsFromDataFiles(data_file_array) {
    let selected_questions = [];
    data_file_array.forEach(function (file) { selected_questions = selected_questions.concat(file.questions)});
    return selected_questions.filter(function(q) { return !q.isHidden && !q.isBanner; }) ;
}


// This function will sort a Pick One - Multi according to the Row % statistics
// in the right-most column that is not the NET columm

// Accounts for the possibility that the data reduction has been transposed
function sortPickOneMultiByRightColumn(question) {
    checkQuestionType(question, ["Pick One - Multi"]);
    let temp_table = project.report.appendTable();
    temp_table.primary = question;

    let output;
    try {
        output = temp_table.calculateOutput();
    } catch(e) {
        temp_table.deleteItem();
        return null;// Table is empty
    }

    // Handle the case where the table has had its rows and columns swapped
    let is_row = output.availableStatistics.indexOf('Row %') > -1;
    let values = is_row ? getRightMostColumnFromTableExcludingNet(temp_table, 'Row %') : getBottomRowFromTableExcludingNet(temp_table, 'Column %');
    if (values.filter(function (x) { return !isNaN(x); }).length > 0)
        anchoredDescendingSortTable(temp_table, values, !is_row);

    temp_table.deleteItem();
}

function sortGridByLeftColumn(question) {
    checkQuestionType(question, ["Pick Any - Grid", "Number - Grid"]);
    let stat;
    if (question.questionType == "Pick Any - Grid")
        stat = '%';
    else
        stat = 'Average';
    let temp_table = project.report.appendTable();
    temp_table.primary = question;
    let values = getLeftMostColumnFromTableExcludingNet(temp_table, stat);
    if (values.filter(function (x) { return !isNaN(x); }).length > 0)
        anchoredDescendingSortTable(temp_table, values, false);
    temp_table.deleteItem();
}


function anchoredDescendingSortTable(table, values, by_columns) {
    let labels;
    let nets;
    let dataReduction = table.primary.dataReduction;
    if (!by_columns) {
        labels = table.primary.dataReduction.rowLabels;
        nets = table.primary.dataReduction.netRows;
    } else {
        labels = table.primary.dataReduction.columnLabels;
        nets = table.primary.dataReduction.netColumns;
    }
    
    let sort_objects = labels.map(function (label, index) {
        let val = values[index];
        if (isNonSortable(label) || nets.indexOf(index) != -1) // Consistent with Displary non-sortable labels
            val = -9999999999;

        return {label: label, value: val};
    });

    sort_objects.sort(function (a, b) {
        return b.value - a.value;
    });

    let prev_label = null;

    sort_objects.forEach(function (obj) {
        dataReduction.moveAfter(obj.label, prev_label);
        prev_label = obj.label;
    });
}


function getRightMostColumnFromTableExcludingNet(table, stat) {
    let output;
    let values;
    try {
        output = table.calculateOutput();
        values = output.get(stat);
    } catch (e) {
        return null; //This table is empty or does not have the stat
    }
    let num_rows = output.numberRows;
    let cols_without_net = output.columnIndices(false);
    let result = new Array(num_rows);//as the array could be huge, specifying its size up-front
    if (cols_without_net.length > 0) {
        let col = cols_without_net[cols_without_net.length - 1];
        for (let row = 0; row < num_rows; row ++)
            result[row] = values[row][col];
    }
    return result;
}

function getBottomRowFromTableExcludingNet(table, stat) {
    let output;
    let values;
    try {
        output = table.calculateOutput();
        values = output.get(stat);
    } catch (e) {
        return null; //This table is empty or does not have the stat
    }
    let num_cols = output.numberColumns;
    let rows_without_net = output.rowIndices(false);
    let result = new Array(num_cols);//as the array could be huge, specifying its size up-front
    if (rows_without_net.length > 0) {
        let row = rows_without_net[rows_without_net.length - 1];
        for (let col = 0; col < num_cols; col ++)
            result[col] = values[row][col];
    }
    return result;
}

function getLeftMostColumnFromTableExcludingNet(table, stat) {
    let output;
    let values;
    try {
        output = table.calculateOutput();
        values = output.get(stat);
    } catch (e) {
        return null; //This table is empty or does not have the stat
    }
    let num_rows = output.numberRows;
    let cols_without_net = output.columnIndices(false);
    let result = new Array(num_rows);//as the array could be huge, specifying its size up-front
    if (cols_without_net.length > 0) {
        let col = cols_without_net[0];
        for (let row = 0; row < num_rows; row ++)
            result[row] = values[row][col];
    }
    return result;
}

function consistentQuestionSort(question) {
    let q_type = question.questionType;
    if (q_type == "Text" || q_type == "Text - Multi")
        return null;
    if (["Pick One", "Pick Any", "Pick Any - Compact", "Number - Multi", "Ranking"].indexOf(q_type) > -1) {
        let temp_table = project.report.appendTable();
        temp_table.primary = question;
        let empty = false;
        try {
            temp_table.calculateOutput()
        } catch (e) {
            empty = true;
        }
        if (!empty)
            sortTableDescending(temp_table);
        temp_table.deleteItem();
    }
    else if (q_type == "Pick One - Multi")
        sortPickOneMultiByRightColumn(question);
    else if (q_type == "Pick Any - Grid" || q_type == "Number - Grid")
        sortGridByLeftColumn(question);
}

function sortCategoriesInSelection() {
    let selected_questions;

    if (!inDisplayr()) {
        if (project.dataFiles.length == 0) {
            log("Please add a data set to your project.");
            return;
        }

        // Ask the user to choose which data files to use
        let selected_datafiles = dataFileSelection();
        let candidate_questions = getAllQuestionsFromDataFiles(selected_datafiles).filter(function (q) { return q.questionType != "Text" && q.questionType != "Text - Multi"; } );
        if (candidate_questions.length == 0) {
            log("There are no appropriate questions available to sort.");
            return;
        }
        selected_questions = selectManyQuestions("Select questions to sort: ", candidate_questions).questions;
    } else {
        let user_selections = getAllUserSelections();
        selected_questions = user_selections.selected_questions;
        if (selected_questions.length == 0) {
            log("No appropriate data is selected. Select one or more variable sets containing multiple categories in the Data Sets section and run this option again.");
        }
    }

    selected_questions.forEach(function (question) {
        consistentQuestionSort(question);
    });
}

sortCategoriesInSelection();

Prior to the 15th of December, 2015, this page was known as Sort - Sort from Highest to Lowest (Does Not Update When Data Changes)

Sort/Reorder Rows or Columns - Sort Categories from Highest to Lowest (Does Not Update When Data Changes)

Example

Technical details

Technical details

See also

Navigation menu

Search