Hi there, we have a hierarchy for data where it starts with level 1 then 2,3 and so on.
We’re trying to build a dashboard that rolls the data quality results up based on the hierarchy. For example:
I have one company, with multiple departments, and each department has many employees. We would like to build DQ rules for the company’s data, then the departments and finally it’s employees. but we would like this data to be rolled up. Meaning, if employees data has 80% score and departments DQ score 90, we would combine those when we view the data on the department level, and so on for the company.
What is the best way to execute the above?
Thanks in advance,