I am able to run a sql query to get me the results but can't seem to do the same thing in Tableau. What I want is to display the number of records that have a distinct status value against the total number of records and show that as a percentage (in a graph)?
Below is what I am trying to show in a graph. I am sure it is easy but I am too new at Tableau.
COUNTD() is only available in an extract. MS Jet doesn't support that function. Extract your data so you're using the Tableau data engine and you'll have the tools you need.