Example Dashboard syntax
The following script is an example valid dashboard designed to show you how certain displays are achieved. Note, though, that often the best way of determining the correct syntax is to create a tile of the type you want using the GUI and then clicking "Edit script" to see the auto-generated script for that tile.
CREATE DASHBOARD "Furniture Tracker Overview"
TAB "Demographics"
TILE "Summary" WIDTH 12 HEIGHT 2
SUMMARY
TILE "Gender" WIDTH 3 HEIGHT 3
SUBTITLE "Distribution of respondents by gender"
FREQUENCY
FOR s1
COLOR "Male"="#1a7a6e", "Female"="#e07850"
DISPLAY AS DONUT
VALUES PERCENTS
TILE "Age Group" WIDTH 4 HEIGHT 3
SUBTITLE "Distribution of respondents by age"
FREQUENCY
FOR s2
COLOR
"Under 18 years"="#1a7a6e",
"18-24 years"="#2a9d8f",
"25-39 years"="#e07850",
"40-54 years"="#c4a35a",
"55+ years"="#5b4e8c",
"I do not wish to answer this question"="#999999"
DISPLAY AS HORIZONTAL BARS
VALUES PERCENTS
TILE "Location" WIDTH 5 HEIGHT 3
SUBTITLE "Distribution of respondents across British Isles"
FREQUENCY
FOR s3
COLOR
"Channel Islands"="#1a7a6e",
"England"="#2a9d8f",
"Wales"="#e07850",
"Scotland"="#c4a35a",
"Republic of Ireland"="#5b4e8c",
"Northern Ireland"="#3d8b80"
SORT BY MEASURE PERCENTS DESCENDING
DISPLAY AS HORIZONTAL BARS
VALUES PERCENTS
TILE "Industry" WIDTH 6 HEIGHT 4
SUBTITLE "Industries respondents work in (multi-select)"
FREQUENCY
FOR `S4.Doesanyoneinyourhouseholdincludingyourselfworkin...`
SORT BY MEASURE PERCENTS DESCENDING
DISPLAY AS HORIZONTAL BARS
VALUES PERCENTS
TILE "Occupation" WIDTH 6 HEIGHT 4
SUBTITLE "Respondent occupation categories"
FREQUENCY
FOR q40
COLOR
`Professional/manager`="#136b60",
"White collar"="#136b60",
"Skilled worker"="#136b60",
`Other semi/unskilled worker`="#136b60",
"Home maker"="#136b60",
"Student"="#136b60",
"Other (unemployed, non-age pensioner)"="#136b60",
"Retired"="#136b60",
"Professional"="#136b60",
"Manager"="#136b60",
"Small business owner"="#136b60",
`Clerk/typist`="#136b60",
"Sales"="#136b60",
"Semi-professional"="#136b60",
"Farm owner"="#136b60",
"Farm worker"="#136b60",
"Semi-skilled worker"="#136b60",
"Unskilled worker"="#136b60"
SORT BY MEASURE PERCENTS DESCENDING
DISPLAY AS HORIZONTAL BARS
VALUES PERCENTS
TILE "Employment Status" WIDTH 3 HEIGHT 3
SUBTITLE "Full-time, part-time or casual"
FREQUENCY
FOR q41
COLOR "Full-time"="#1a7a6e", "Part-time"="#e07850", "Casual"="#c4a35a"
DISPLAY AS DONUT
VALUES PERCENTS
TILE "Household Income" WIDTH 5 HEIGHT 3
SUBTITLE "Gross annual household income bands"
FREQUENCY
FOR q42
DISPLAY AS HORIZONTAL BARS
VALUES PERCENTS
TILE "Household Status" WIDTH 4 HEIGHT 3
SUBTITLE "Living arrangements of respondents"
FREQUENCY
FOR q43
COLOR
"Unrelated adults sharing a home"="#136b60",
"Single parent with children at home"="#136b60",
"Living with partner – no children at home"="#136b60",
"Living with partner – children at home"="#136b60",
"Single, living alone"="#136b60",
"Adult living with parents"="#136b60",
"I do not wish to answer this question"="#136b60"
SORT BY MEASURE PERCENTS DESCENDING
DISPLAY AS HORIZONTAL BARS
VALUES PERCENTS
TAB "Purchase Behaviour"
TILE "Summary" WIDTH 12 HEIGHT 2
SUMMARY
TILE "Purchased Furniture P12M" WIDTH 3 HEIGHT 3
SUBTITLE "Whether respondent purchased furniture in last 12 months"
FREQUENCY
FOR s5
COLOR "Yes"="#2d8c5a", "No"="#c0392b", `Not sure / Don't know`="#999999"
DISPLAY AS DONUT
VALUES PERCENTS
TILE "Household Purchase Frequency" WIDTH 4 HEIGHT 3
SUBTITLE "How often respondents buy things for the household"
FREQUENCY
FOR s9
DISPLAY AS HORIZONTAL BARS
VALUES PERCENTS
TILE "Homewares Purchase Frequency" WIDTH 5 HEIGHT 3
SUBTITLE "How often homewares were purchased in last 12 months"
FREQUENCY
FOR q1
DISPLAY AS HORIZONTAL BARS
VALUES PERCENTS
TILE "New vs Second-hand" WIDTH 4 HEIGHT 3
SUBTITLE "Whether purchases were new, second-hand or a mix"
FREQUENCY
FOR q6
COLOR
"Exclusively brand new goods"="#1a7a6e",
"Exclusively second-hand goods"="#e07850",
"A mix of brand new and second-hand goods"="#c4a35a",
`Not sure/don't know`="#999999"
DISPLAY AS DONUT
VALUES PERCENTS
TAB "Brand Awareness & Shopping"
TILE "Summary" WIDTH 12 HEIGHT 2
SUMMARY
TILE "Brand Awareness" WIDTH 12 HEIGHT 5
SUBTITLE "Prompted awareness of homewares stores"
FREQUENCY ARRAY
FOR `Q2.BrandAwarenessprompted` CATEGORIES
BY SUBVARIABLES
DISPLAY AS HORIZONTAL BARS
ARRANGE STACKED
VALUES TOTAL_PERCENTS
TILE "Stores Shopped At P12M" WIDTH 12 HEIGHT 5
SUBTITLE "Stores shopped at in the past 12 months"
FREQUENCY
FOR q5_mr
SORT BY MEASURE PERCENTS DESCENDING
DISPLAY AS HORIZONTAL BARS
VALUES PERCENTS
TILE "Main Store" WIDTH 12 HEIGHT 5
SUBTITLE "Which store respondents consider their main homewares store"
FREQUENCY
FOR q10
COLOR
"Homeware Haven"="#136b60",
"Heart & Home"="#136b60",
"Pillowland"="#136b60",
"MiCasa"="#136b60",
"Nester"="#136b60",
"Eastbay"="#136b60",
"Chez Nous"="#136b60",
"Comfort Corner'd"="#136b60",
"Kitbag"="#136b60",
"Snuggle"="#136b60",
"Bed of Roses"="#136b60",
"Davide le Brun"="#136b60",
"Unit"="#136b60",
"Paul’s Warehouse"="#136b60",
"Daven"="#136b60",
"JonDon"="#136b60",
"Rooms and Brooms"="#136b60",
"Nightingale"="#136b60",
"Komfort King"="#136b60",
"Jim-Jam and Co."="#136b60",
"The Athlete’s Foot"="#136b60",
"Womble"="#136b60",
"Anaconda"="#136b60",
"Maggie's Cottage"="#136b60",
"Villa"="#136b60",
"Co-op Manor"="#136b60",
"Decathlon"="#136b60",
"Cubby"="#136b60",
"Hive and Jam"="#136b60",
"Corner'd"="#136b60",
"Peter Harrington"="#136b60",
"Rad Pad"="#136b60",
"Suite Spot"="#136b60",
"Noisy Nanna"="#136b60",
"Don’t have one main store"="#136b60",
"Other (^f('q9Oth_1_other')^)"="#136b60",
`Not sure/don’t know`="#136b60"
SORT BY MEASURE PERCENTS DESCENDING
DISPLAY AS HORIZONTAL BARS
VALUES PERCENTS
TILE "Reasons for Main Store" WIDTH 12 HEIGHT 6
SUBTITLE "Why respondents chose their main store (multi-select)"
FREQUENCY
FOR `Q11.Whydoyouconsiderpipeq10tobeyourmainstore`
SORT BY MEASURE PERCENTS DESCENDING
DISPLAY AS HORIZONTAL BARS
VALUES PERCENTS
TILE "Visit Frequency" WIDTH 12 HEIGHT 6
SUBTITLE "How often respondents visit each store"
FREQUENCY ARRAY
FOR q7_array CATEGORIES
BY SUBVARIABLES
DISPLAY AS HORIZONTAL BARS
ARRANGE STACKED
VALUES TOTAL_PERCENTS
TAB "Brand Perceptions"
TILE "Summary" WIDTH 12 HEIGHT 2
SUMMARY
TILE "Store Satisfaction" WIDTH 12 HEIGHT 6
SUBTITLE "Satisfaction ratings across stores"
FREQUENCY ARRAY
FOR `Q8.Howwouldyourateyoursatisfactionwithyourshoppingexperienceat.` CATEGORIES
BY SUBVARIABLES
DISPLAY AS HORIZONTAL BARS
ARRANGE STACKED
VALUES TOTAL_PERCENTS
TILE "Would Recommend" WIDTH 12 HEIGHT 5
SUBTITLE "Stores respondents would consider purchasing from"
FREQUENCY ARRAY
FOR `Q9.Whichofthefollowingstoreswouldyouconsiderpurchasinghomewares` CATEGORIES
BY SUBVARIABLES
DISPLAY AS HORIZONTAL BARS
ARRANGE STACKED
VALUES TOTAL_PERCENTS
TILE "Brand Image Attributes" WIDTH 12 HEIGHT 5
SUBTITLE "How well statements describe the store (0-10 scale)"
FREQUENCY ARRAY
FOR `Q12a.HowwouldyouratethefollowingstatementsaboutJonDonstores` SUBVARIABLES
BY CATEGORIES
DISPLAY TABLE
CELLS TOTAL_PERCENTS
TILE "Brand Personality - Reb" WIDTH 12 HEIGHT 5
SUBTITLE "Personality words associated with brand (Reb)"
FREQUENCY
FOR `Q12.WhichwordsdoyouassociatedwiththefollowingbrandsYoucanchecka`
SORT BY MEASURE PERCENTS DESCENDING
DISPLAY AS HORIZONTAL BARS
VALUES PERCENTS
TILE "Brand Personality - Int" WIDTH 12 HEIGHT 5
SUBTITLE "Personality words associated with brand (Int)"
FREQUENCY
FOR `Q12.WhichwordsdoyouassociatedwiththefollowingbrandsYoucancheck1`
SORT BY MEASURE PERCENTS DESCENDING
DISPLAY AS HORIZONTAL BARS
VALUES PERCENTS
TILE "Brand Personality - Ath" WIDTH 12 HEIGHT 5
SUBTITLE "Personality words associated with brand (Ath)"
FREQUENCY
FOR `Q12.WhichwordsdoyouassociatedwiththefollowingbrandsYoucancheck2`
SORT BY MEASURE PERCENTS DESCENDING
DISPLAY AS HORIZONTAL BARS
VALUES PERCENTS
TILE "Willingness to Shop" WIDTH 6 HEIGHT 4
SUBTITLE "Willingness to shop at select stores (0-10 scale)"
FREQUENCY ARRAY
FOR Q13aHowlikelyareyoutorecommendthefollowingstores SUBVARIABLES
BY CATEGORIES
DISPLAY TABLE
CELLS TOTAL_PERCENTS
TILE "Likelihood to Recommend" WIDTH 12 HEIGHT 6
SUBTITLE "Likelihood to recommend each store (0-10 NPS-style scale)"
FREQUENCY ARRAY
FOR `Q13bHowlikelyareyoutocontinueshoppingat....` CATEGORIES
BY SUBVARIABLES
DISPLAY AS HORIZONTAL BARS
ARRANGE STACKED
VALUES TOTAL_PERCENTS
TAB "Advertising"
TILE "Summary" WIDTH 12 HEIGHT 2
SUMMARY
TILE `Seen/Heard Advertising` WIDTH 3 HEIGHT 3
SUBTITLE "Whether respondent recalled any homewares advertising in last month"
FREQUENCY
FOR q3a
COLOR "Yes"="#2d8c5a", "No"="#c0392b", `Not sure/don't know`="#999999"
DISPLAY AS DONUT
VALUES PERCENTS
TILE "Advertising Recall by Media" WIDTH 5 HEIGHT 3
SUBTITLE "Types of advertising recalled (multi-select)"
FREQUENCY
FOR q4_mr
SORT BY MEASURE PERCENTS DESCENDING
DISPLAY AS HORIZONTAL BARS
VALUES PERCENTS
TAB "JonDon Conversion"
TILE "Summary" WIDTH 12 HEIGHT 2
SUMMARY
TILE "Aware of HH to JonDon Switch" WIDTH 3 HEIGHT 3
SUBTITLE "Whether respondent knew about the Homeware Haven to JonDon conversion"
FREQUENCY
FOR q17bv2
COLOR "Yes"="#2d8c5a", "No"="#c0392b", `Not sure / Don't know`="#999999"
DISPLAY AS DONUT
VALUES PERCENTS
TILE "Feeling About Switch" WIDTH 5 HEIGHT 3
SUBTITLE "Sentiment about the switch from Homeware Haven to JonDon"
FREQUENCY
FOR q17c
COLOR
"Very Positive"="#2d8c5a",
"Positive"="#6dab4f",
"Neutral"="#999999",
"Negative"="#e07850",
"Very Negative"="#c0392b",
`Not sure / Don’t know`="#cccccc"
DISPLAY AS HORIZONTAL BARS
VALUES PERCENTS
TILE "Reasons for Negative Feelings" WIDTH 12 HEIGHT 4
SUBTITLE "Why respondents feel negative about the switch (multi-select)"
FREQUENCY
FOR `Q17.Whichofthefollowingstatementsbestdescribeyourreasonsforfeel`
SORT BY MEASURE PERCENTS DESCENDING
DISPLAY AS HORIZONTAL BARS
VALUES PERCENTS
TILE "JonDon Meets Expectations" WIDTH 4 HEIGHT 3
SUBTITLE "Whether a visit to JonDon meets, exceeds or falls short of expectations"
FREQUENCY
FOR q16a
COLOR
"The JonDon store experience exceeds my expectations"="#2d8c5a",
"The JonDon store experience is in line with my expectations"="#999999",
"The JonDon store experience falls well short of my expectations"="#c0392b",
`Not sure/don't know`="#cccccc"
DISPLAY AS HORIZONTAL BARS
VALUES PERCENTS
TILE "Purchased from HH P12M" WIDTH 3 HEIGHT 3
SUBTITLE "Whether respondent purchased from Homeware Haven in last 12 months"
FREQUENCY
FOR q17f
COLOR "Yes"="#2d8c5a", "No"="#c0392b", `Not sure / Don't know`="#999999"
DISPLAY AS DONUT
VALUES PERCENTS
TILE "Likely to Continue at JonDon" WIDTH 5 HEIGHT 3
SUBTITLE "Likelihood of continuing to shop at the converted store"
FREQUENCY
FOR q17g
COLOR
"Very likely"="#2d8c5a",
"Somewhat likely"="#6dab4f",
"Neutral"="#999999",
"Not very likely"="#e07850",
"Not at all likely"="#c0392b",
`Not sure / Don’t know`="#cccccc"
DISPLAY AS HORIZONTAL BARS
VALUES PERCENTS
TILE "Continued Shopping Post-Switch" WIDTH 4 HEIGHT 3
SUBTITLE "Whether respondent continued shopping at the same store after conversion"
FREQUENCY
FOR q17h
COLOR
"Yes, I continue to shop at the same store"="#2d8c5a",
"No, I no longer shop at what used to be the Homeware Haven store"="#c0392b",
"I did not shop at Homeware Haven"="#999999",
`Not sure/don't know`="#cccccc"
DISPLAY AS HORIZONTAL BARS
VALUES PERCENTS
TILE "Visited JonDon Website" WIDTH 3 HEIGHT 3
SUBTITLE "Whether respondent has ever visited the JonDon website"
FREQUENCY
FOR q20
COLOR "Yes"="#2d8c5a", "No"="#c0392b", `Not sure/don't know`="#999999"
DISPLAY AS DONUT
VALUES PERCENTS
TILE "Purchased from JonDon Online" WIDTH 3 HEIGHT 3
SUBTITLE "Whether respondent has made an online purchase from JonDon"
FREQUENCY
FOR q21
COLOR "Yes"="#2d8c5a", "No"="#c0392b", `Not sure/don't know`="#999999"
DISPLAY AS DONUT
VALUES PERCENTS
TAB "Tracking"
TILE "Summary" WIDTH 12 HEIGHT 2
SUMMARY
TILE "Responses by Quarter" WIDTH 12 HEIGHT 4
SUBTITLE "Number of respondents per quarter over time"
FREQUENCY
FOR QTR
COLOR
"July 2021"="#136b60",
"October 2021"="#136b60",
"January 2022"="#136b60",
"April 2022"="#136b60",
"July 2022"="#136b60",
"October 2022"="#136b60",
"January 2023"="#136b60",
"April 2023"="#136b60",
"July 2023"="#136b60",
"October 2023"="#136b60",
"January 2024"="#136b60",
"April 2024"="#136b60",
"July 2024"="#136b60",
"October 2024"="#136b60",
"January 2025"="#136b60",
"April 2025"="#136b60",
"July 2025"="#136b60",
"October 2025"="#136b60",
"January 2026"="#136b60",
"April 2026"="#136b60"
DISPLAY AS VERTICAL BARS
VALUES COUNT
TAB "About This Research"
TILE "" WIDTH 12 HEIGHT 8
MARKDOWN ```
# Furniture Tracker Study
## Overview
This is a longitudinal brand tracking study covering the homewares and furniture retail sector across the British Isles. The study runs quarterly and has been in field since July 2021, with 20 waves of data collected to date.
## Sample
- **Total respondents:** 11,150 across all waves
- **Geography:** England, Wales, Scotland, Republic of Ireland, Northern Ireland, Channel Islands
- **Qualification:** Respondents who have personally purchased furniture in the last 12 months
## Key Topics Covered
- **Brand awareness** (prompted) across ~29 homewares retailers
- **Shopping behaviour** — stores visited, visit frequency, main store selection
- **Brand perceptions** — satisfaction, likelihood to recommend (NPS-style), functional image attributes, brand personality
- **Advertising** — recall of advertising by media channel, influential information sources
- **JonDon conversion** — tracking the impact of Homeware Haven stores being rebranded to JonDon, including awareness, sentiment, and behavioural change
## Weighting
Data is weighted by gender to population targets (Male 48%, Female 52%).
## Notes
- The study uses a quarterly fieldwork cycle. Quarter 19 corresponds to January 2026.
- The JonDon conversion module was introduced during the tracking period and is only asked of relevant respondents.
```
GROUPS VARIABLES
s1,
s2,
s3,
QTR
;