@geneshackman wrote:
Interesting that two people say they won't open excel files. On the community support website for tableau, most people say they won't help you unless you include a tableau file they can download, along with data.
Different forum, different culture.
Some of us belong to organizations with rules about accessing files. Some, like Excel, are notorious for a number of problems for security.
Another, Excel is a crappy data interchange method. For one thing, it isn't possible to tell if a column should be treated as numeric or character data because columns in Excel can, and entirely too often, do contain mixes of such. So we would have to clean up your example data, as to variable types as a minimum before doing anything. Not to mention getting usable variable names. I've received Excel files with as many as 20 columns named "Total". I just love guessing total of what.
You haven't lived until you get to clean up data provided in Excel that started out as a "fillable PDF" form. 😰
... View more