Marketing - Brand Health Table

A brand health table is a table that shows the performance of brands on a series of 'health' metrics, such as awareness, consideration, and trial.

Example

In Displayr, the brand health table is created by selecting Insert > More > Marketing > Brand Health Table.
In Q, select Create > Marketing > Brand Health Table.

The table below is an example of a brand health table, with the four input tables shown underneath.

Options

The inputs used to generate the brand health table are shown in the image below.

DATA SOURCE

Output The outputs - tables and R Outputs - to be used to create the brand health table.

Row name 1... Labels to be used for the rows of the table (by default, the labels are taken from the input tables).

FORMAT

Output When set to Stages, the original data from the inputs is shown. When set to Conversion, the ratios of adjacent rows are shown. When set to Stages and Conversion, both are shown.

Sort by How the table is sorted, from left to right (in descending order).

Show as How the table is formatted. Where applicable, additional color controls appear.

Code

▶ Show Code

var heading_text = "Brand Health Table";
if (!!form.setObjectInspectorTitle)
    form.setObjectInspectorTitle(heading_text);
else
    form.setHeading(heading_text);

form.group("DATA SOURCE");
var outputLabel = "Output";
var outputPrompt = "Outputs are tables or other Q or R outputs";
if (Q.isOnTheWeb()) {
    outputLabel = "Data";
    outputPrompt = "Data is tables or other outputs in your Data Sources (bottom-left) or Report tree (top-left)";
}
var tables = form.dropBox({ name: "formTables",
    label: outputLabel,
    types: ['Table', "RItem:!StandardChart!SignificanceTest:!KMeans:!phraseList:!tidyText:!wordBag"],
    required: true,
    multi: true }).getValues();
var row_name_controls = [];
var n_tables = tables.length;
for (var i = 1; i < (1 + n_tables); i++)
    row_name_controls.push(form.textBox({ label: "Row name " + i,
        default_value: "",
        prompt: "Enter a row label to override the label that appears on the table",
        required: false,
        name: "formRowName" + i }));
form.group("FORMAT");
var output = form.comboBox({ label: "Output",
    name: "formOutput",
    default_value: "Stages",
    alternatives: ["Stages", "Conversion", "Stages and Conversion"] }).getValue();
var sort_alternatives = ["First table's order", "Alphabetic"];
var n_rows = output == "Stages" ? n_tables : (output == "Conversion" ? n_tables - 1 : n_tables * 2 - 1);
for (var i = 1; i < (n_rows + 1); i++)
    sort_alternatives.push("Row " + i);
form.comboBox({ label: "Sort by",
    name: "formSort",
    default_value: sort_alternatives[n_tables == 0 ? 0 : 1],
    alternatives: sort_alternatives });
var show_as = form.comboBox({ label: "Show as",
    name: "formShowAs",
    default_value: "Tiles",
    alternatives: ["Simple", "Numbers", "Bars", "Tiles"] }).getValue();
if (show_as == "Bars") {
    form.colorPicker({ label: "Color",
        name: "formBaseColor",
        default_value: "#8cc0ff" });
    let fixed_width = form.checkBox({ label: "Fixed column width", name: "formFixedWidth",
        default_value: false }).getValue();
    if (fixed_width)
        form.numericUpDown({ label: "Column width (pixels):", name: "formColumnWidth",
            default_value: 100, increment: 1, minimum: 1, maximum: 1000 });
}
else if (show_as == "Tiles") {
    form.colorPicker({ label: "Gradient start",
        name: "formBaseColor",
        default_value: "#B1CBEB" });
    form.colorPicker({ label: "Gradient end",
        name: "formEndColor",
        default_value: "#3E7DCC" });
}