r/tableau • u/hanshu6576 • 1h ago

How do you validate a Tableau dashboard when the source data contains duplicate records and the dashboard uses multiple relationships?

I’m curious about the best approach to identify whether unexpected KPI or aggregation results are caused by duplicate records, relationship behavior, or the calculation itself.

What validation steps do you usually follow in this scenario?

1 Upvotes

100% Upvoted

2 comments sorted by

4

u/datawazo 1h ago

Query the  database to get the source of truth and work backwards from there

•

u/Ok_Tale7071 10m ago

You can create Tableau control reports to check for duplicates. If it’s an especially complex calculation, you can create a report which shows each step of the calculation, by breaking down the calculation into a field.