4 of 4 people found this helpful
I have not so great news.
Currently the ability to UNION separate Excel files is not a feature built into Tableau.
I recommend simply converting the files to .csv files instead.
Hopefully this helps!
This works thanks! The only issue is that it's doubling the counts, any reason why that might happen? I found an easy workaround by dividing counts in half...
Honestly, not sure why, but if you could post sample data, then I can look for the cause. Not sure if that fixes it or not, but if you have different names in any of reports, it could be duplicating, so you may want to merge it in data source pane, but selecting those fields and right click