Solved: SQL and Tableau: Attached is a copy of the query that I am working wit

Home
questions and answers
sql and tableau attached is a copy of the query that i am working with

Question

SQL and Tableau: Attached is a copy of the query that I am working with. And some of the output you would see. To give you some context on what is being accomplished with this query: I am interested in calculating percentage (work done vs. remaining) based on several factors for each table_name(record). In the query business_steward is returned as an array. I have a separate query showing how to retrieve names based on this array – but didn’t see how to add this to the first one. The factors are: • Domain • Critical Data Asset • Title • description • Steward (analysts doing work) • Marketplace_links I would like to see a stacked bar chart running horizontally (one for each of the factors above – being in the has/has count. I would like to have a dynamic filter based on Steward/Domain. And as you apply filters - beneath this bar chart will be a list of records showing the resultset based on filter(s) applied the query showing the value - i added fields to show - has(specific factor)