How to structure a complaints trend dashboard

Ticketclosed

Brimscombe Energy · How to structure a complaints trend dashboard

Siân Pritchard asked how to structure a dashboard with multiple dimensions to avoid sparse matrices. Bethan Lister recommended region as the first dimension with resolution type as breakdown, which Siân confirmed worked perfectly.

Priority normal

made from

What happened

What this says

Current to 13 Oct 26

Siân Pritchard asked how to structure a dashboard with multiple dimensions to avoid sparse matrices. Bethan Lister recommended region as the first dimension with resolution type as breakdown, which Siân confirmed worked perfectly.

Problem: Siân wanted to build a complaints dashboard with dimensions for region and resolution type over time, unsure how to structure it to avoid sparse matrices.

Handling: Bethan recommended setting region as the first dimension with resolution type as a breakdown within that, with time on the x-axis and filters available to drill into regions. This design pattern avoids the sparse matrix problem.

Watch: Siân confirmed the approach worked perfectly and found it clean and straightforward. This shows active dashboard building and product engagement.

AI · claude-haiku-4-5-20251001 · 13 Oct 2026

AImade from

Details

Updated 9 Oct 26

Prioritynormal

Statusclosed

Categoryhow_to

Channelchat

First response (min)281

Helpdeskmade from

Trail

created · Siân Pritchard 11 Mar 2026 13:53
Our collections team wants a dashboard showing complaints by region and resolution type over time. I've started using the dashboard builder but I'm unsure about the best way to dimension this to avoid a sparse matrix or too many edge cases. How have you seen other teams approach this?
public_reply · Bethan Lister 11 Mar 2026 18:34
I've picked this up. Just so I've got this right: you want to show complaints by region, then broken down by resolution type, trending over time? If you give me a couple of examples of the regions and resolution types you're working with, I can walk you through building it. Thanks, Bethan
public_reply · Bethan Lister 13 Mar 2026 12:06
Here's what I'd suggest: set region as your first dimension, then add resolution type as a breakdown within that, with time on the x-axis. That way you avoid a huge sparse matrix. If you add filters above the chart you can drill into specific regions. Can you try that and tell me what you see? Thanks, Bethan
public_reply · Siân Pritchard 13 Mar 2026 12:07
That's worked perfectly. Clean and straightforward. Thanks, Bethan.
status_change · Bethan Lister 23 Mar 2026 12:15
status_change · 27 Mar 2026 23:59

Helpdeskmade from

BB-Demo is a fictional company; every organisation and person here is invented. B-Brain is the tool. Built by site/build_site.py from the site tree, data as of Fri 9 Oct 2026. Help & Support

Help & Support

Open as a page

Help & Support

B-Brain is one place to read everything the company knows about its customers: the CRM, calls, emails, support tickets, product usage, invoices, documents, news and HR. Every page is built from those systems and the data is current to Fri 9 Oct 2026.

How to use the site

Summary is the landing page: what happened this week, the calls just held and the calls coming up, the risks and the renewals due.
Organisations lists every customer. Open one to see its key facts, the AI assessment and next step, platform usage, the ARR journey, deals, documents, contacts and activity, and the lineage of every block.
Conversations, Commercial, People, News and Documents cut the same data by topic. System explains how the brain is built and where each figure comes from.
Every card ends with a small made from link: it opens the lineage explorer focused on that card, so you can walk from the figure down to the raw rows it came from.
Use the sun and moon button at the top right to choose dark or light. Choose your device's own mode again to go back to following the device.

How to ask

Press Ask Brain in the header. Type a question, or pick one of the examples.

Search the brain finds the organisations, people, calls, emails, tickets, documents and news that match your words, with links to their pages.
Ask Claude copies your question and opens the B-Brain Claude Project, where Claude answers from the same data using the B-Brain tools and cites the pages it used.

The site itself does not call an AI model; answers in Claude come from the same figures you see here.

What the data covers

Data	Records
Organisations	225
People at customers	862
BB-Demo staff	58
Calls	1,995
Email threads	3,013
Support tickets	1,159
Documents	1,218
Deals	315
Invoices	285
Events	49
News items	119

Data as of Fri 9 Oct 2026. Text marked AI was written by the brain from the records listed in its made-from link; an AI output that cannot cite its evidence is refused and the previous text kept. Where two systems disagree (for example a contract and the CRM), the key facts show both values and mark the difference.

BB-Demo is a fictional company: every organisation, person and figure here is invented for this demonstration. B-Brain is the tool that reads its data.

Who to contact

Email support@b-brain.example or talk to your B-Brain account team. Tell us the page address and what looked wrong; a screenshot helps.

Help