This one has me stumped. I'm working with survey data that, for each person provides and arrival date & departure date. Each person also has some combination of dietary constraints.

The goal is to produce a single vis that, across all possible dates, shows the headcount within each dietary combination on that particular day.

What I have in mind is a simple cross tab:

- discrete days on the columns

- dietary restrictions on the rows

- a running total of the headcount in the text

headcount is only considered for those persons for whom this day is both >= the arrival date AND <= the departure date

I'm open to any & every solution that only uses Tableau (doesn't require a data re-shaping). Scaffolds & self-blends are 100% valid. Self-join or joins to a scaffold are also valid. The original data arrives in CSV format.

4) [B] shows who underlying persons are via tooltip > view data and therefore better if this is needed.

Pain Issue

Tableau has seemingly no locale language option for the legacy connector. Therefore I had to change Windows Region and Language Location = United States and Format = English (United States) before getting correct dates. I cannot open attached workbook after changing my Windows Region and Language back to its original (Faroe Islands + Faroese).

While my aim was to solve this without reshaping, what we've found is that there's really no good way to do so. I did manage to make it work on the original data shape, with a scaffold and table calculations. But that was complex, brittle, and would be difficult to maintain.

Because this is common type of problem, as evidenced by Jonathan's catalog of similar scenarios started back in 2012, I've written a blog post to explain the pattern.

Do you have suggestions on how I could go about creating this same type of graph however without generating the missing rows in order to perform the counts? 60mins x 24hrs means 1440 entries per day. Because I am going to be measuring two years at a time, I want to avoid this if possible.