Hi Tableau Community,
I’m experiencing some challenges in combining data to create a hyper file, as I believe this would simplify the process of updating a 3-line chart with a new Excel worksheet each month. In Tableau Prep, one of the worksheets contains a unique column that differs from the others, which I need to retain for comparison purposes. However, when I connect it to Tableau Desktop, the data doesn’t read correctly.
Additionally, I’ve created a bar chart to compare the total number of documents (Actual Submission Total and Publish Date Total). However, it appears a bit unusual because all the months are displayed, which I suspect is due to the way the data is structured.
Could you please assist me with both of these issues?
Thank you!
#Tableau Desktop & Web Authoring #Tableau Prep
hello and welcome back.
Probably best to start from the beginning as it's been awhile since I last looked at the data. As I recall, there were a number of 'weekly' reports that were posted with your question, but really only the most recent one is likely useable because it adds new data to the historical data, so the latest one is the best one.
So, if using the one dated 2026-06-01, for June 1, 2026 for example, are you joining that worksheet called 'Complete List' with any other data from your post in Tableau Prep? Such as 'Report' worksheet from UPDATED Published Documents Report STEM_SB? If yes, what are you joining it on? Or could you post the packaged workbook as .tflx file format so that we better understand what you're trying to do.
Let's start with that question...as I wasn't able to open your originally posted Prep Flow to understand what has been done already, hence this first question. I think, based on what I'm seeing from the .hyper file is that a lot of your data is unioned in Prep and you'll probably only need to use the most recent weekly file, not all of them.
But we need to start with the basics first in understanding what's being joined to what in Prep...it might be simpler than originally believed.
