Thank you for the workbook. I have been working at this for awhile and the use of Primary Diagnostic as a linking field on Table view. What is the original data source and is it possible to preprocess the data through Tableau Prep to clean it up? I attempted to start this but one of the attached data sources is a hyber extract rather than a spreadsheet so I was unable to move forward with that idea.
Have you found anything to assist?
Thanks for your reply.
I haven't used Tableau Prep and I'm investigating if my company has bought license for it. So until when I would appreciate if you could find a solution that are independent of Tableau Prep.
In my example all databases are xlsx files. In my real case The crossjoin file are a xlsx file and the other 2 txt files.
Since my attached file seems to be giving you some problems I will attach a new one.
It's almost the same as the previous one. The scaffolding file has some more dates.
Just some information regarding my own progress. I'm investigating the possibility not using a scaffold file.
I have almost solved it by not using the scaffold file but then I run into problem when filtering the view with a date lookup filter. All calculations are correct but the Area chart has some issues. This occurs for months where primary diagnostic is null.
I have tried the yellow mark solution together with adding check for null in the calculated field. If null then 0. No success so far. I hope you can solve the scaffolding version. I think it also will solve the Area chart issue.
Diagnostic Code Rate2.twbx 63.8 KB