Short answer: a distributor scorecard is only as fair as the weights behind it, so build those weights in the open and let Tableau do the ranking, highlighting and explaining. A scorecard turns a sprawling partner network into a ranked list a regional manager can act on in a quarterly business review — provided the maths is defensible.
Define the measure before the visual
A score is a model, not a chart, so design it like one. Pick a small set of metrics that genuinely drive results and that you can measure cleanly across every distributor: distribution breadth, velocity, and compliance. Resist the urge to bolt on a dozen vanity metrics; each one you add dilutes the signal and invites disputes.
Normalise each metric to the same scale before weighting, because raw values do not combine — cases per account and percentage compliance live in different units. A simple min-max calculation works:
( SUM([Velocity]) - WINDOW_MIN(SUM([Velocity])) ) / ( WINDOW_MAX(SUM([Velocity])) - WINDOW_MIN(SUM([Velocity])) ) * 100
Then combine the normalised components against weights held in parameters: [w_dist] * [Dist Score] + [w_vel] * [Vel Score] + [w_comp] * [Comp Score]. Exposing the weights as parameters is the single most important design choice — it makes the model auditable and lets a sceptical sales director re-run the ranking under their own assumptions during the meeting.
Rank, highlight and explain
Use Tableau’s RANK() table calculation to order distributors, and present the result as a horizontal bar chart sorted by total score, with the weighted components stacked so a viewer sees not just the rank but its composition. A distributor scoring 72 because of strong velocity but weak compliance is a very different conversation from one scoring 72 on the reverse.
Highlight actions tie the dashboard together. Hovering or clicking a distributor highlights its row across every linked sheet — its trend, its account list, its compliance detail — so the whole story moves with the selection rather than forcing the user to re-filter. When a mark looks off, right-click and run Explain Data: Tableau models the expected value and surfaces the records or dimensions most associated with the deviation. That might point to one delinquent chain dragging down compliance. Treat it as a lead to investigate, not a conclusion; Explain Data describes the data, it does not know your commercial context.
Where it breaks
The deepest risk is not technical, it is behavioural. Any score you publish becomes a target, and targets get gamed. Weight velocity too heavily and a distributor may chase fast-moving SKUs while letting your premium range gather dust. Reward distribution breadth alone and you get token placements with no rate of sale. Goodhart’s law applies in full: when a measure becomes a target, it ceases to be a good measure. Review the weights periodically and watch for behaviour that optimises the score rather than the business.
The second limit is fairness across uneven partners. A scorecard that ignores territory size, account mix or tenure will punish a distributor for a market it inherited rather than performance it controls. Where possible, compare like with like — segment by market type — rather than ranking a rural wholesaler against a metro powerhouse on one absolute scale. And as ever, Tableau will faithfully rank dirty data; a missing compliance feed reads as a zero, not as “unknown”, unless you handle nulls deliberately.
The bottom line
A good distributor scorecard normalises a few honest metrics, weights them transparently through parameters, and uses rank and highlight actions to make the ranking navigable. Explain Data accelerates the diagnosis but does not replace the judgement call. Guard against gaming by revisiting weights and segmenting fairly, and remember the model is a conversation-starter, not the final word.
Part of the Sales Intelligence track. Related: A Depletions and Sell-Through Dashboard in Tableau.
Frequently asked questions
What metrics belong on a distributor scorecard? The durable three are distribution breadth (how many target accounts are stocked), velocity (rate of sale per account), and compliance (orders, payments and reporting hitting agreed terms). Add price or display execution only if you can measure them consistently.
How do I build a weighted score in Tableau? Normalise each metric to a common 0–100 scale with a calculated field, multiply by its weight, and sum the components. Keep the weights in parameters so reviewers can see and adjust them rather than burying them in the formula.
Can Tableau explain why a distributor scored badly? Explain Data can surface the dimensions and records most associated with an unusual mark, which is a useful starting point. It is a statistical hint, not a verdict, so treat it as a prompt for a human conversation.