1 of 1 people found this helpful
I did this in Tableau Prep in about 7 minutes. Tableau Prep is part of your maintenance so give it a try! If you don't have it, you can also get the 14-day free trial here: Download Tableau Prep
Workflow and related files are attached. I output this as a .csv file but it can also be output as .tde or .hyper for further ingestion into Tableau for further aggregated analysis. If this answers your question please mark this response as correct so that others may find it useful. Thx, Don
Connect to data:
Calculated field to get to when they were converted:
see the attached - this can be done directly in Tableau
first the last change
then use it in a filter
then build the viz
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
max date book.twbx 17.5 KB
Thanks so much for the help, Jim! Your solution worked great, and kept me inside the same workbook within Tableau.
I was able to get a copy of Tableau prep, since it is part of our maintenance. I was able to get an aggregated view of the data, and post that to Tableau Server to use as a datasource. However, I wasn't able to join that data source with another MSSQL table we have. Probably something that I'm doing wrong since I'm not familiar with that tool, yet.
Thanks Steve - I see you have Prep - I agree with Don - great tool - I was on the Beta - if you haven't been out to the on-line training videos in a while there is a section on Prep - could be worth a visit