Is there a way to track Data completeness of all field against a single column?

Stuck

Hi all,

From a data quality perspective, I want to analyse the differences in process across teams in one toolset through heatmapping how complete a column's data is against each team.

Effectively, I'm aiming for a percentile value for all columns against each team. There must be a better way than just creating a percentile kpi for all columns individually and then adding them all to one heatmap.

Could a clever trick in MagicETL solve this through a percentile allocation and then follow that with a data pivot? I can't solve it logically without arduous repetition.

Best,

Stuck