
1. Re: Translate from excel to Tableau
Zac Hilbert Jun 6, 2014 9:21 AM (in response to Fred Dais)Fred,
It will be difficult for any one to help you out with a specific solution because
 We do not know what your Excel data look like
 We do not know what your Tableau data look like
 We do not know what you want your Tableau visualization to look like.
 Your description and Excel formula are unclear and do not tell us exactly what you are trying to compute.
I recommend posting a packaged workbook and your Excel data. And make sure your Excel formula is correctit doesn't look like a valid Excel formula, and the parts that do look valid have some odd things like dividing numbers by the same which would always be 1. It will be easier for someone to help you out if you can provide more info. I also recommend checking out this document: Posting a Perfect Question.
That aside, I am going to make some assumptions based on your Excel data and guess that the solution will involve some calculated fields that look like this:
Passes = if columnM="pass" then 1 else 0 end + if columnN="pass" then 1 else 0 end + ... if columnQ="pass" then 1 else 0 end
Fails = if columnM="fail" then 1 else 0 end + if columnN="fail" then 1 else 0 end + ... if columnQ="fail" then 1 else 0 end
etc.
And you'll need some table calculations, e.g.
TotalPasses = total(sum(Passes)
And then get a percentage by dividing:
Pct = Passes / TotalPasses.
Hope this helps.
Zac